TS: Microsoft SQL Server 2008, Database Development

Exam 70-433:

• TS: Microsoft SQL Server 2008, Database Development

Audience Profile

Candidates should have one to two years of experience using Microsoft SQL Server 2008 or two to three years of experience using a previous version of SQL Server. Candidates for this exam are IT professionals who work in jobs in which database development is their main area of responsibility, or they work in environments in which databases are central to their primary job roles. These job roles include the following:

• IT generalists who work in environments in which SQL Server 2008 is part of an overall solution
• IT professionals who manage systems that run SQL Server 2008
• Developers who build applications that use SQL Server 2008
• IT professionals who work with third-party applications that are built on SQL Server 2008

Credit Toward CertificationWhen you pass Exam 70-433: TS: Microsoft SQL Server 2008, Database Development, you complete the requirements for the following certification(s):

Microsoft Certified Technology Specialist (MCTS): SQL Server 2008, Database Development

Skills Being Measured

This exam measures your ability to accomplish the technical tasks listed below. The percentages indicate the relative weight of each major topic area on the exam.

Implementing Tables and Views (14 percent)

• Create and alter tables.
• Create and alter views.
• Create and alter indexes.
• Create and modify constraints.
• Implement data types.
• Implement partitioning solutions.
  
  

Implementing Programming Objects (16 percent)

• Create and alter stored procedures.
• Create and alter user-defined functions (UDFs).
• Create and alter DML triggers.
• Create and alter DDL triggers.
• Create and deploy CLR-based objects.
• Implement error handling.
• Manage transactions.
  
  

Working with Query Fundamentals (21 percent)

• Query data by using SELECT statements.
• Modify data by using INSERT, UPDATE, and DELETE statements.
• Return data by using the OUTPUT clause.
• Modify data by using MERGE statements.
• Implement aggregate queries.
• Combine datasets.
• Apply built-in scalar functions.
  

Applying Additional Query Techniques (15 percent)

• Implement subqueries.
• Implement CTE (common table expression) queries.
• Apply ranking functions.
• Control execution plans.
• Manage international considerations.
  
  

Working with Additional SQL Server Components (11 percent)

• Integrate Database Mail.
• Implement full-text search.
• Implement scripts by using Windows PowerShell and SQL Server Management Objects (SMOs).
• Implement Service Broker solutions.
• Track data changes.
  
  

Working with XML Data (12 percent)

• Retrieve relational data as XML.
• Transform XML data into relational data.
• Query XML data.
• Manage XML data.
  
  

Gathering Performance Information (11 percent)

• 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.