Exam Ref 70-761: Querying Data with Transact-SQL

This is a reference material to prepare for Microsoft Exam 70-761 and help demonstrate your real-world mastery skills of Transact-SQL data management, querying and database programming. Designed for experienced IT professionals ready to advance their status, book focuses on the critical thinking and decision making acumen needed for success at the MCSA level.
Covered topics focus on the expertise measured by the objectives to filter, sort, join, aggregate and modify data, use subqueries, table expressions, grouping sets and pivoting, query temporal and non-relational data, read and output XML or JSON, create views, user-defined functions and stored procedures, implement error handling, transactions, data types and nulls. View Less