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

Ace your preparation for Microsoft® Certification Exam 70-461 with this 2-in-1 Training Kit from Microsoft Press®. Work at your own pace through a series of lessons and practical exercises, and then assess your skills with practice tests on CD—featuring multiple, customizable testing options.

Maximize your performance on the exam by learning how to:

• Create database objects
• Work with data
• Modify data
• Troubleshoot and optimize queries

You also get an exam discount voucher—making this book an exceptional value and a great career investment.

Table of Contents

Chapter 1: Foundations of Querying
Chapter 2: Getting Started with the SELECT Statement
Chapter 3: Filtering and Sorting Data
Chapter 4: Combining Sets
Chapter 5: Grouping and Windowing
Chapter 6: Querying Full-Text Data
Chapter 7: Querying and Managing XML Data
Chapter 8: Creating Tables and Enforcing Data Integrity
Chapter 9: 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