Training Kit (Exam 70-461)

By: Itzik Ben-Gan, Dejan Sarka, Ron Talmage
Technical Editor: Herbert Albert
Publication Date: November 2012
ISBN-13: 978-0735666054
ISBN-10: 0735666059
738 pages

Order the book at:



Table of Contents
Chapter 01: Foundations of Querying
Chapter 02: Getting Started with the SELECT Statement
Chapter 03: Filtering and Sorting Data
Chapter 04: Combining Sets
Chapter 05: Grouping and Windowing
Chapter 06: Querying Full-Text Data
Chapter 07: Querying and Managing XML Data
Chapter 08: Creating Tables and Enforcing Data Integrity
Chapter 09: Designing and Creating Views, Inline Functions, and Synonyms
Chapter 10: Inserting, Updating, and Deleting Data
Chapter 11: Other Data Modification Aspects
Chapter 12: Implementing Transactions, Error Handling, and Dynamic SQL
Chapter 13: Designing and Implementing T-SQL Routines
Chapter 14: Using Tools to Analyze Query Performance
Chapter 15: Implementing Indexes and Statistics
Chapter 16: Understanding Cursors, Sets, and Temporary Tables
Chapter 17: Understanding Further Optimization Aspects
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

Sample Content
Chapter 1: Foundations of Querying Microsoft SQL Server 2012 – Online

Chapter 7: Querying Full-Text Data in Microsoft SQL Server 2012 – Online

Chapter 1 & 7 – Download


Download Source Code

Copyright notice: you’re only authorized to download the source code if you own a legal copy of the book.

Source Code for Training Kit 70-461

View / Submit Corrections

Training Kit 70-461 – Submit Errata

Training Kit 70-461 – Submitted Errata

Training Kit 70-461 – Old Errata