Exam Ref 70-761

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

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

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

Introduction

Table of Contents

View / Submit Corrections

Order the book at: