TK 70-461

T-SQL Courses

Training Kit (Exam 70-461): Querying Microsoft SQL Server 2012 (MSPress)

By: Itzik Ben-Gan, Dejan Sarka, Ron Talmage
Technical Editor: Herbert Albert
Publication Date: November, 2012
0-7356-6605-9, ISBN-13: 978-0-7356-6605-4
738 pages

Order the book at:
- amazon
- Barnes & Noble

- Oreilly (Ebook also available) (use discount code MSINT, details here)


This Training Kit is designed for information technology (IT) professionals who need to query data in Microsoft SQL Server 2012 and who also plan to take Exam 70-461, “Querying Microsoft SQL Server 2012.”

It is assumed that before you begin using this Training Kit, you have a foundation-level understanding of using Transact-SQL (T-SQL) to query data in SQL Server 2012 and have some experience using the product. Although this book helps prepare you for the 70-461 exam, you should consider it as one part of your exam preparation plan. Meaningful, real-world experience with SQL Server 2012 is required to pass this exam. The material covered in this Training Kit and on Exam 70-461 relates to the technologies in SQL Server 2012. The topics in this Training Kit cover what you need to know for the exam as described on the Skills Measured tab for the exam, which is available at

By using this Training Kit, you will learn how to do the following:

  • Create database objects

  • Work with data

  • Modify data

  • Troubleshoot and optimize T-SQL code

Refer to the objective mapping page in the front of this book to see where in the book each exam objective is covered.

Itzik, Dejan and Ron







Home ] Books ] T-SQL Courses ] Resources ] About ]

[SolidQ Home] [SolidQ Blog] [SolidQ Courses] [The SolidQ journal]