Training Kit (Exam 70-461): Querying Microsoft SQL Server 2012
- Length: 752 pages
- Edition: 1
- Language: English
- Publisher: Microsoft Press
- Publication Date: 2012-12-10
- ISBN-10: 0735666059
- ISBN-13: 9780735666054
- Sales Rank: #295475 (See Top 100 Books)
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