Príprava na certifikačnú skúšku MCTS 70-433: SQL Server 2008 Database Developer

Cieľ kurzu: Pripraviť IT profesionálov, ktorí pracujú ako databázoví vývojári, alebo pracujú v databázovom prostredí, tak, aby mohli sebavedome podstúpiť certifikačnú skúšku 70-433. Kurz je vedený plne certifikovaným lektorom na SQL Server 2008.

Vstupné požiadavky: jeden až dva roky skúseností s používaním SQL Servera 2008 alebo dva až tri roky skúseností s používaním predchádzajúcej verzie SQL Servera

Trvanie: 5 dní

Obsahová náplň:

Implementing Tables and Views

  • Creating and altering tables
  • Creating and altering views
  • Creating and altering indexes
  • Creating and modifying constraints
  • Implementing data types
  • Implementing partitioning solutions

Implementing Programming Objects

  • Creating and altering stored procedures
  • Creating and altering user-defined functions (UDFs)
  • Creating and altering DML triggers
  • Creating and altering DDL triggers
  • Creating and deploy CLR-based objects
  • Implementing error handling
  • Managing transactions

Working with Query Fundamentals

  • Querying data by using SELECT statements
  • Modifying data by using INSERT, UPDATE, and DELETE statements
  • Returning data by using the OUTPUT clause
  • Modifying data by using MERGE statements
  • Implementing aggregate queries
  • Combining datasets
  • Applying built-in scalar functions

Applying Additional Query Techniques

  • Implementing subqueries
  • Implementing CTE (common table expression) queries
  • Applying ranking functions
  • Controlling execution plans
  • Managing international considerations

Working with Additional SQL Server Components

  • Integrating Database Mail
  • Implementing full-text search
  • Implementing scripts by using Windows PowerShell and SQL Server
  • Management Objects (SMOs)
  • Implementing Service Broker solutions
  • Tracking data changes

Working with XML Data

  • Retrieving relational data as XML
  • Transforming XML data into relational data
  • Querying XML data
  • Managing XML data

Gathering Performance Information

  • Capturing execution plans
  • Gathering trace information by using the SQL Server Profiler
  • Collecting output from the Database Engine Tuning Advisor
  • Collecting information from system metadata