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

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

Book Details