Im going to take the 70-461 (Querying Microsoft SQL Server 2012) exam shortly so will be compiling some Curahs for each major section and a SSMS Solution for the exam to learn from, I’ll update everything as I go along but for starts my study material / resources are:


PluralSight – Joe Sack has large collection of T-SQL related series
PluralSight – Kimberly Tripp has a wealth of information on Stored procs and optimizations
SQL Bits – Loads of TSQL related videos available
CBT Nuggets – 70-461


Training Kit (Exam 70-461): Querying Microsoft SQL Server 2012
Microsoft SQL Server 2012 T-SQL Fundamentals
Joes 2 Pros TSQL Series lots of code examples and tests to go throw


Exam 70-461 Create database objects (24%)
Exam 70-461 Work with data (27%)
Exam 70-461 Modify data (24%)
Exam 70-461 Troubleshoot and optimise (25%)

SSMS Solution

Coming soon, I have 3/4 of a create db objects project.