Preparation Tools and Resources

Search here for prep resources for specific exam topics and add any exam prep resources that you have found helpful in preparing for this exam.

General preparation material

Learning plans and classroom training

Prep resources by objective

1  Implement Database Objects

1.1  Create and alter tables (complex statements)

1.2  Design, implement, and troubleshoot security

  • <<Add your resources here>>
  • <<Add your resources here>>

1.3  Design the locking granularity level

  • <<Add your resources here>>
  • <<Add your resources here>>

1.4  Maintain indexes

  • <<Add your resources here>>
  • <<Add your resources here>>

1.5  Implement data types

  • <<Add your resources here>>
  • <<Add your resources here>>

1.6  Create and modify constraints (complex statements)

  • <<Add your resources here>>
  • <<Add your resources here>>

1.7  Work with XML data

  • <<Add your resources here>>
  • <<Add your resources here>>

2  Implement Programming Objects

2.1  Write automation scripts

  • <<Add your resources here>>
  • <<Add your resources here>>

2.2  Design and implement stored procedures

  • http://msdn.microsoft.com/en-us/library/dn452281(v=sql.120).aspx

2.3  Design T-SQL table-valued and scalar functions

  • <<Add your resources here>>
  • <<Add your resources here>>

2.4  Create, use, and alter user-defined functions (UDFs)

  • <<Add your resources here>>
  • <<Add your resources here>>

2.5  Create and alter views (complex statements)

  • <<Add your resources here>>
  • <<Add your resources here>>

3  Design Database Objects

3.1  Design tables

  • <<Add your resources here>>

3.2  Design for concurrency

  • <<Add your resources here>>
  • <<Add your resources here>>

3.3  Create and alter indexes

  • <<Add your resources here>>
  • <<Add your resources here>>

3.4  Design data integrity

  • <<Add your resources here>>
  • <<Add your resources here>>

3.5  Design for implicit and explicit transactions

  • <<Add your resources here>>
  • <<Add your resources here>>

4  Optimize and Troubleshoot Queries

4.1  Optimize and tune queries

  • <<Add your resources here>>

4.2  Troubleshoot and resolve performance problems

  • <<Add your resources here>>
  • <<Add your resources here>>

4.3  Optimize indexing strategies

  • <<Add your resources here>>
  • <<Add your resources here>>

4.4  Capture and analyze execution plans

  • <<Add your resources here>>
  • <<Add your resources here>> 

4.5  Collect performance and system information

  • <<Add your resources here>>
  • <<Add your resources here>>