Skip to content

Microsoft Exam 70-433 (part 4)

2010 June 30
by Shannon Lowder

I’m putting together a new series to cover the materials you’ll need to know in order to pass the 70-433.  Microsoft’s exam that covers Database Development using Microsoft SQL Server 2008.  I’m going to list the topics covered in several posts, each one will include links to details to those topics.  If you have any questions, let me know!

Applying Additional Query Techniques (15 percent)

  • Implement subqueries.
    This objective may include but is not limited to: simple, correlated, scalar, list, table valued
  • Implement CTE (common table expression) queries.
    This objective may include but is not limited to: recursive, non-recursive
  • Apply ranking functions.
    This objective may include but is not limited to: RANK, PARTITION BY, DENSE_RANK, OVER, ROW_NUMBER, NTILE
  • Control execution plans.
    This objective may include but is not limited to: table hints, query hints
  • Manage international considerations.
    This objective may include but is not limited to: collations, defining custom errors, filtering data, sort order, nvarchar, database collation, column collation
No comments yet

Leave a Reply

Note: You can use basic XHTML in your comments. Your email address will never be published.

Subscribe to this comment feed via RSS