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

Microsoft Press books

 

Training Kit 70-461: Querying Microsoft SQL Server 2012
By: Itzik Ben-Gan, Dejan Sarka, Ron Talmage 
Released: December 2012

Buy this book from    (Official distributor of Microsoft Press)

Prep resources by objective

1  Create Database Objects

1.1  Create and alter tables using T-SQL syntax

1.2  Create and alter views (simple statements)

1.3  Design views

1.4  Create and modify constraints (simple statements)

2  Work with Data

2.1  Query data by using SELECT statements

2.2  Implement sub-queries

2.3  Implement data types

2.4  Implement aggregate queries

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

2.5  Query and manage XML data

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

3  Modify Data

3.1  Create and alter stored procedures (simple statements)

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

3.2  Modify data by using INSERT, UPDATE, and DELETE statements

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

3.3  Combine datasets

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

3.4  Work with functions

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

4  Troubleshoot & Optimize

4.1  Optimize queries

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

4.2  Manage transactions

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

4.3  Evaluate the use of row-based operations vs. set-based operations

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

4.4  Implementing error handling