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

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

  • Length: 752 pages
  • Edition: 1
  • Publisher:
  • Publication Date: 2012-12-10
  • ISBN-10: 0735666059
  • ISBN-13: 9780735666054
  • Sales Rank: #295475 (See Top 100 Books)
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

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

To access the link, solve the captcha.