Exam Ref 70-761 Querying Data with Transact-SQL

Update regarding URLs referenced in the book:
Wherever you encounter a URL pointing to the website tsql.solidq.com, please replace solidq with lucient. For example, instead of URL https://tsql.solidq.com/booksdisplay/er70761/ use URL https://tsql.lucient.com/booksdisplay/er70761/

By: Itzik Ben-Gan
Technical Editor: Dejan Sarka
Publication Date: April 2017
ISBN-13: 978-1509304332
ISBN-10: 1509304339
400 pages

Order the book at:

                    

Table of Contents
Chapter 01: Manage data with Transact-SQL

Skill 1.1: Create Transact-SQL SELECT queries
Skill 1.2: Query multiple tables by using joins
Skill 1.3: Implement functions and aggregate data
Skill 1.4: Modify data

Chapter 02: Query data with Advanced Transact-SQL Components

Skill 2.1: Query data by using subqueries and APPLY
Skill 2.2: Query data by using table expressions
Skill 2.3: Group and pivot data by using queries
Skill 2.4: Query temporal data and non-relational data

Chapter 03: Program Databases by using Transact-SQL

Skill 3.1: Create database programmability objects by using Transact-SQL
Skill 3.2: Implement error handling and transactions
Skill 3.3: Implement data types and NULLs

Introduction
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, Exam Ref focuses on the critical-thinking and decision-making acumen needed for success at the MCSA level.

Focus on the expertise measured by these objectives:

  • Filter, sort, join, aggregate, and modify data
  • Use subqueries, table expressions, grouping sets, and pivoting
  • Query temporal and non-relational data, and output XML or JSON
  • Create views, user-defined functions, and stored procedures
  • Implement error handling, transactions, data types, and nulls

This Microsoft Exam Ref:

  • Organizes its coverage by exam objectives
  • Features strategic, what-if scenarios to challenge you
  • Assumes you have experience working with SQL Server as a database administrator, system engineer, or developer
  • Includes downloadable sample database and code for SQL Server 2016 SP1 (or later) and Azure SQL Database
Download Source Code

Copyright notice: you’re only authorized to download the source code if you own a legal copy of the book.

Source Code for ER 70-761

View / Submit Corrections

ER 70-761 – Submit Errata

Update regarding URLs referenced in the book:
Wherever you encounter a URL pointing to the website tsql.solidq.com, please replace solidq with lucient. For example, instead of URL https://tsql.solidq.com/booksdisplay/er70761/ use URL https://tsql.lucient.com/booksdisplay/er70761/