Exam Ref 70-761 Querying Data with Transact-SQL

✍ Scribed by Ben-Gan, Itzik

• Publisher: Microsoft Press;Pearson Education
• Year: 2017
• Tongue: English
• Leaves: 336
• Category: Library

✦ Synopsis

This is a reference material to prepare for Microsoft Exam 70-761 and help demonstrate your real-world mastery of SQL Server 2016 Transact-SQL data management, queries, 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 include 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.

✦ Table of Contents

CHAPTER 1 Manage data with Transact-SQL CHAPTER 2 Query data with advanced Transact-SQL components CHAPTER 3 Program databases by using Transact-SQL

✦ Subjects

Nonfiction;Reference;Computer Science;Programming