Exam 70-433

TS: Microsoft SQL Server 2008, Database Development

$150.00 USD*

Not in the United States?

Microsoft Certified Professional exams are provided by a third-party vendor. Register for an exam at Prometric's website.

Schedule now

* Pricing does not include any promotional offers or reduced pricing for Microsoft IT Academy program members, Microsoft Certified Trainers, and Microsoft Partner Network program members. Price is subject to change without notice. Price does not include applicable taxes. Please confirm exact pricing with the exam provider before registering to take an exam.
SQL Server logo
  • Published: 10 December 2008
  • Languages: English, German, Japanese, Chinese (Simplified)
  • Audiences: Developers
  • Technology: Microsoft SQL Server 2008
  • Credit towards certification: MCTS, MCITP

Convince your boss email

Copy the following content into an email message to your boss and update [the bracketed text] with the appropriate content.

Dear [your boss's name]:

I'd like to expand and prove my technical skills by earning a Microsoft Certification. My next step is taking Exam 70-433. The registration fee is $150.00 USD.

When I pass this certification, you'll have proof of my ability to work with Microsoft SQL Server 2008. Microsoft has training and online resources to help me prepare for the exam. I believe I'll be more effective and productive after achieving this valuable technical certification.

Let me know if you have any questions. In the meantime, you can find out more about this exam at http://www.microsoft.com/learning/en-hk/exam-70-433.aspx. As you can see, the exam validates skills that are crucial to our team's success.

Thank you for your support,

[your name]

Skills measured

This exam measures your ability to accomplish the technical tasks listed below. The percentages indicate the relative weight of each major topic area in the exam. The higher the percentage, the more questions you are likely to see on that content area in the exam.

Please note that the questions may test on, but will not be limited to, the topics described in the bulleted text.

  • Create and alter tables

    • Computed and persisted columns; schemas; scripts to deploy changes to multiple environments, for example, dev, test, production; manage permissions (GRANT, DENY, REVOKE)

  • Create and alter views

    • WITH ENCRYPTION; WITH SCHEMABINDING; WITH CHECK OPTION; manage permissions (GRANT, DENY, REVOKE)

  • Create and alter indexes

    • Filtered, included columns, unique, clustered, non-clustered, FILL FACTOR; CREATE STATISTICS; indexing views, compression

  • Create and modify constraints

    • PRIMARY KEY, FOREIGN KEY, UNIQUE, CHECK, cascading referential integrity, enabling/disabling, NOCHECK; SET IDENTITY_INSERT

  • Implement data types

    • FILESTREAM; spatial, structured and semi-structured; collations

  • Implement partitioning solutions

    • Partitioned tables and indexes (constraints, partition functions, partition schemes, MERGE, SPLIT, SWITCH); distributed partitioned views (constraints, linked servers)

  • Create and alter stored procedures

    • Table-valued parameters (TVPs), EXECUTE AS, RECOMPILE, parameter direction (output); WITH ENCRYPTION; manage permissions (GRANT, DENY, REVOKE)

  • Create and alter user-defined functions (UDFs)

    • WITH SCHEMABINDING, EXECUTE AS; manage permissions (GRANT, DENY, REVOKE)

  • Create and alter DML triggers

    • INSERTED, DELETED, INSTEAD OF, EXECUTE AS

  • Create and alter DDL triggers

    • Enabling/disabling; return event data

  • Create and deploy CLR-based objects

    • Permission sets (SAFE, UNSAFE, EXTERNAL_ACCESS), SET TRUSTWORTHY

  • Implement error handling

    • TRY/CATCH, RAISERROR, retrieving error information, custom error messages, @@ERROR

  • Manage transactions

    • BEGIN TRANSACTION, COMMIT, ROLLBACK, SET TRANSACTION ISOLATION LEVEL, named transactions

  • Query data by using SELECT statements

    • LIKE, WHERE, ORDER BY, INTO

  • Modify data by using INSERT, UPDATE and DELETE statements

    • Row constructors, DELETE FROM, UPDATE FROM, TRUNCATE TABLE

  • Return data by using the OUTPUT clause

    • INSERTED, DELETED, INTO

  • Modify data by using MERGE statements

    • INSERTED, DELETED, OUTPUT

  • Implement aggregate queries

    • Built-in aggregate functions, GROUPING SETS, GROUP BY, HAVING

  • Combine datasets

    • CROSS APPLY, OUTER APPLY, all join types; UNION, UNION ALL, INTERSECT, EXCEPT

  • Apply built-in scalar functions

    • CAST and CONVERT; REPLACE; LEN and DATALENGTH; PATINDEX and CHARINDEX

  • Implement subqueries

    • Simple, correlated, scalar, list, table valued

  • Implement CTE (common table expression) queries

    • Recursive, non-recursive

  • Apply ranking functions

    • RANK, PARTITION BY, DENSE_RANK, OVER, ROW_NUMBER, NTILE

  • Control execution plans

    • Table hints, query hints

  • Manage international considerations

    • Collations, defining custom errors, filtering data, sort order, nvarchar, database collation, column collation

  • Integrate Database Mail

  • Implement full-text search

    • CONTAINS, CONTAINSTABLE, FREETEXT, FREETEXTTABLE, STOPLIST

  • Implement scripts by using Windows PowerShell and SQL Server Management Objects (SMOs)

    • cmdlets

  • Implement Service Broker solutions

    • Services, queues, messages, message types, message validation, contracts, activation procedures, routes

  • Track data changes

    • Change tracking; database audit specification; CHANGETABLE, Change Data capture

  • Retrieve relational data as XML

    • FOR XML

  • Transform XML data into relational data

    • OPENXML, sp_xml_preparedocument, sp_xml_removedocument

  • Query XML data

    • XQUERY, XPATH

  • Manage XML data

    • XML datatype, XML indexes, XML schema collections

  • Capture execution plans

    • Graphical execution plans; SHOWPLAN, index details in Query Plans

  • Gather trace information by using the SQL Server Profiler

  • Collect output from the Database Engine Tuning Advisor

    • Prepare a workload

  • Collect information from system metadata

    • Dynamic Management Views (DMVs), catalogue views

Preparation options

Find training near you

Buy a practice test for Exam 70-433 from:

Cover of 'MCTS Self-Paced Training Kit (Exam 70-433): Microsoft SQL Server 2008 - Database Development'

MCTS Self-Paced Training Kit (Exam 70-433): Microsoft SQL Server 2008 - Database Development

Published: February 2009

Ace your preparation for the skills measured by MCTS Exam 70-433—and on the job. Work at your own pace through a series of lessons and reviews that fully cover each exam objective. Then, reinforce and apply what you’ve learned through real-world case scenarios and practice exercises. This official Microsoft study guide is designed to help you make the most of your study time.

Buy this book at the Microsoft Press Store

Who should take this exam?

Candidates should have two to three years of experience creating business intelligence (BI) solutions with SQL Server 2008. Candidates for this exam typically work with the full suite of BI technologies in SQL Server 2008, including Reporting Services, Analysis Services and Integration Services.

More information about exams

We recommend that you review this exam preparation guide in its entirety and familiarise yourself with the resources on this website before you schedule your exam. See the Microsoft Certification exam overview for information about registration, videos of typical exam question formats, and other preparation resources. For information on exam policies and scoring, see the Microsoft Certification exam policies and FAQs.

This preparation guide is subject to change at any time without prior notice and at the sole discretion of Microsoft. Microsoft exams might include adaptive testing technology and simulation items. Microsoft does not identify the format in which exams are presented. Please use this preparation guide to prepare for the exam, regardless of its format. To help you prepare for this exam, Microsoft recommends that you have hands-on experience with the product and that you use the specified training resources. These training resources do not necessarily cover all of the topics listed in the "Skills measured" section.