Existing User Login

New User? Create An Account

Request new password

We Are All About You

XpertSkills - the parent company under which iCollege operates - was established in South Africa in 2003 and since then, we have grown globally in leaps and bounds with customers and partners in more than 120 countries. With employees on 3 continents and as a next-generation, virtual organization we are unconstrained by the limits that are usually associated with traditional “brick & mortar” companies.

This allows us to focus, without distraction, on reaching our ultimate goal – ensuring your ongoing success – by providing affordable, reliable, high quality and relevant learning products whilst remaining innovative and agile.

Contact Details:

Web: www.xpertskills.com
Skype: xpertskills
Mail: info@xpertskills.com

Physical Address:

Head Office - South Africa
16 Monte Carlo Crescent
Kyalami business Park
Johannesburg
South Africa 1684

You are here

Microsoft 70-433: Microsoft SQL Server 2008 Database Development

LIVE LAB:

Microsoft 70-433: Microsoft SQL Server 2008 Database Development

Practical exercises in a live environment to help you get real-world, hands-on experience.

Overview

The 70-433 Practice-Lab will provide you with the necessary platform to gain hands on skills in SQL Server 2008. By completing the lab tasks you will improve your practical skills in Tables & Views, Constraints Data Types & partitioning Solutions, Programming Objects, Query Fundamentals, XML Data and Performance Information. These same tasks will help you understand the objectives and competencies required by the TS: Microsoft SQL Server 2008, Database Development certification exam.

Vendor:   Microsoft
Vendor Id:   70-433
Version:   1
Level:   Intermediate
Learning Time:   530  Minutes

Exercises

  1. Implementing Tables and Views
  2. Total Learning Time is 50  Minutes and module version is 1

    Exercises:
    • Introduction
    • Creating and Altering Tables
    • Creating and Altering Views
    • Creating and Altering Indexes
    • Summary
  3. Implementing Constraints Data Types and Partitioning Solutions
  4. Total Learning Time is 50  Minutes and module version is 1

    Exercises:
    • Introduction
    • Creating and Modifying Constraints
    • Implementing Data Types
    • Implementing Partitioning Solutions
    • Summary
  5. Implementing Programming Objects
  6. Total Learning Time is 80  Minutes and module version is 1

    Exercises:
    • Introduction
    • Creating and Altering Stored Procedures
    • Creating and altering DML Triggers
    • Create and Alter DDL Triggers
    • Error Handling
    • Manage Transactions
    • Create and Deploy CLR Based Objects
    • Summary
  7. Working with Query Fundamentals
  8. Total Learning Time is 90  Minutes and module version is 1

    Exercises:
    • Introduction
    • Query Data by Using SELECT Statements
    • Modify Data by Using INSERT UPDATE and DELETE Statements
    • Combine Datasets
    • Return Data by Using the OUTPUT Clause
    • Modify Data by Using MERGE Statements
    • Builtin Aggregate Functions
    • Apply Builtin Scalar Functions
    • Summary
  9. Applying Additional Query Techniques
  10. Total Learning Time is 70  Minutes and module version is 1

    Exercises:
    • Introduction
    • Implementing Subqueries
    • Implement CTE (Common Table Expression) Queries
    • Applying Ranking Functions
    • Control Execution Plans
    • International Considerations
    • Summary
  11. Working with Additional SQL Server Components
  12. Total Learning Time is 70  Minutes and module version is 1

    Exercises:
    • Introduction
    • Integrate Database Mail
    • Implement Full Text Search
    • Implement Windows PowerShell and SMO
    • Implement Service Broker
    • Track Data Changes
    • Summary
  13. Working with XML Data
  14. Total Learning Time is 60  Minutes and module version is 1

    Exercises:
    • Introduction
    • Retrieve Relational Data as XML
    • Transform XML Data to Relational Data
    • XML Schema Collections
    • Query XML Data and XML Indexes
    • Summary
  15. Gathering Performance Information
  16. Total Learning Time is 60  Minutes and module version is 1

    Exercises:
    • Introduction
    • Capture Execution Plans
    • Gather Trace Information by Using the SQL Server Profiler
    • Collect Output from the Database Engine Tuning Advisor
    • Collect Information from System Metadata
    • Summary
LIVE LAB Access to real hardware and software in real time and with full administrator privileges to gain real-world practical experience.
USD 295 USD 120 59% OFF
  • Gain practical experience with real-world scenarios
  • Access to real hardware & software in real time
  • Experiment & put theory to practice
  • Includes exercises designed to prepare for exams.
  • 12 Months access
  • 10-Day money-back guarantee
Back to Top