Itzik Ben-Gan
  • Home
  • Books
  • T-SQL Courses
  • Resources
  • About
  • More
    • Home
    • Books
    • T-SQL Courses
    • Resources
    • About
Itzik Ben-Gan
  • Home
  • Books
  • T-SQL Courses
  • Resources
  • About

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 


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

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


Source Code - © You’re only authorized to download if you own a legal copy of the book (zip)

Download

View / Submit Corrections

Submit Errata

Order the book at:

Copyright © 2023 Itzik Ben-Gan - All Rights Reserved.

Powered by GoDaddy