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

Microsoft Certification PREP Talk: Exam 464

In this episode of Prep tips from certification experts, James Seymour, Certification Planner, and Dandy Weyn, Senior Program Manager on the SQL Server product group, discuss the relevancy of the skills being measured on Exam 464.

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 using 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>>