|Applying Additional Query Techniques|
Applying Additional Query Techniques weighs 15% of exam 70-433. It covers concepts like, Implement subqueries, Implement CTE (common table expression) queries, Apply ranking functions, Control execution plans, Manage international considerations.
|Gathering Performance Information|
Gathering Performance Information weighs 11% of Exam 70-433 TS: Microsoft SQL Server 2008, Database Developement. It covers concepts like, 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.
|Implementing Programming Objects|
Implementing Programming Objects weighs 16% of the exam. This category includes topics likes, 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.
|Implementing Tables and Views|
Implementing Tables and Views weighs 14% of the Exam 70-433 and includes topics like creating and altering tables, Create and alter views.Create and alter views, Create and alter indexes, Create and modify constraints, Implement data types, Implement partitioning solutions.
|Working with Additional SQL Server Components|
Working with Additional SQL Server Components weighs 11% of Exam 70-433. It covers topics like, 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 Query Fundamentals|
Working with Query Fundamentals includes the following topics and weighs 21% of the exam.
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, Apply built-in scalar functions.
|Working with XML Data|
Working with XML Data weighs 12% of Exam 70-433 and covers topics like, Retrieve relational data as XML, Transform XML data into relational data, Query XML data, Manage XML data.