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

  • Paperback: 752 pages
  • Publisher: Microsoft Press (November 2012)
  • Language: English
  • ISBN-10: 0735666059
  • ISBN-13: 978-0735666054
Download [49.5 MiB]

You may also like...

Leave a Reply