Exam Ref 70-761 Querying Data with Transact-SQL

Exam Ref 70-761

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:

buy4._V192207739_          B&N          MSPressFrame

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


Coming Soon

Sample Content

Coming Soon

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