Exam Ref 70-461 Querying Microsoft SQL Server 2012 (MCSA)

Book description

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. 

Book content

  1. Chapter 1. Foundations of Querying
  2. Chapter 2. Getting Started with the SELECT Statement
  3. Chapter 3. Filtering and Sorting Data
  4. Chapter 4. Combining Sets
  5. Chapter 5. Grouping and Windowing
  6. Chapter 6. Querying Full-Text Data
  7. Chapter 7. Querying and Managing XML Data
  8. Chapter 8. Creating Tables and Enforcing Data Integrity
  9. Chapter 9. Designing and Creating Views, Inline Functions, and Synonyms
  10. Chapter 10. Inserting, Updating, and Deleting Data
  11. Chapter 11. Other Data Modification Aspects
  12. Chapter 12. Implementing Transactions, Error Handling, and Dynamic SQL
  13. Chapter 13. Designing and Implementing T-SQL Routines
  14. Chapter 14. Using Tools to Analyze Query Performance
  15. Chapter 15. Implementing Indexes and Statistics
  16. Chapter 16. Understanding Cursors, Sets, and Temporary Tables
  17. Chapter 17. Understanding Further Optimization Aspects

About Author

Dejan Sarka, is a mentor with SolidQ and focuses on development of database and business intelligence applications. He is a frequent speaker at international conferences such as TechEd, SqlDevCon, and PASS. He is the founder of the Slovenian SQL Server and .NET Users Group. As main author or coauthor, Dejan has written nine books about SQL Server. He has also developed three courses for SolidQ: Data Modeling Essentials, Data Quality and Master Data Management, and Data Mining.

Ebooks download available as