Book description
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
For customers who purchase an ebook version of this title, instructions for downloading the CD files can be found in the ebook.
Table of contents
- Training Kit (Exam 70-461): Querying Microsoft® SQL Server® 2012
- Contents
- Introduction
- 1. Foundations of Querying
-
2. Getting Started with the SELECT Statement
- Before You Begin
- Lesson 1: Using the FROM and SELECT Clauses
- Lesson 2: Working with Data Types and Built-in Functions
- Case Scenarios
- Suggested Practices
- Answers
- 3. Filtering and Sorting Data
- 4. Combining Sets
- 5. Grouping and Windowing
- 6. Querying Full-Text Data
- 7. Querying and Managing XML Data
- 8. Creating Tables and Enforcing Data Integrity
- 9. Designing and Creating Views, Inline Functions, and Synonyms
- 10. Inserting, Updating, and Deleting Data
- 11. Other Data Modification Aspects
-
12. Implementing Transactions, Error Handling, and Dynamic SQL
- Before You Begin
- Lesson 1: Managing Transactions and Concurrency
- Lesson 2: Implementing Error Handling
- Lesson 3: Using Dynamic SQL
- Case Scenarios
- Suggested Practices
- Answers
-
13. Designing and Implementing T-SQL Routines
- Before You Begin
- Lesson 1: Designing and Implementing Stored Procedures
- Lesson 2: Implementing Triggers
- Lesson 3: Implementing User-Defined Functions
- Case Scenarios
- Suggested Practices
- Answers
- 14. Using Tools to Analyze Query Performance
- 15. Implementing Indexes and Statistics
- 16. Understanding Cursors, Sets, and Temporary Tables
- 17. Understanding Further Optimization Aspects
- Index
- About the Authors
- Copyright
Product information
- Title: Training Kit (Exam 70-461): Querying Microsoft® SQL Server® 2012
- Author(s):
- Release date: December 2012
- Publisher(s): Microsoft Press
- ISBN: 9780735667259
You might also like
book
Training Kit Exam 70-462: Administering Microsoft® SQL Sever® 2012 Databases
EXAM PREP GUIDE Ace your preparation for the skills measured by Exam 70-462—and on the job—with …
video
MCSA Querying Microsoft SQL Server 2012 (Exam 70-461): Required Knowledge for SQL Server 2012 and 2014
Lesson Files: http://www.informit.com/content/images/9780789753984/downloads/Code_70-461.zip More than 12 hours of video instruction on Querying Microsoft SQL Server 2012 …
book
SQL Server MVP Deep Dives, Volume 2
SQL Server MVP Deep Dives, Volume 2 lets you learn from the best in the business—64 …
book
Microsoft® SQL Server 2012 Unleashed
Buy the print version of¿ and get the eBook version for free! eBook version includes chapters …