Write advanced Transact-SQL queries

3 hr 27 min
Learning Path
4 Modules

At a glance

Level

Advanced
Skill

 
Product

Azure SQL Database Azure SQL Managed Instance SQL Server on Azure Virtual Machines Azure SQL Server on Virtual Machines SQL Server
Role

Data Analyst Data Engineer Data Scientist Database Administrator Developer Solution Architect Student

Learn how to use advanced Transact-SQL features to fetch and transform data in your databases.

Prerequisites

Familiarity with working with tables of data
Familiarity with Transact-SQL

Start

Modules in this learning path

Create tables, views, and temporary objects

58 min
Module
9 Units

Learn how to use Transact-SQL to create tables, views, and temporary objects for your databases.

Introduction 1 min
Create and query tables 4 min
Create and query views 4 min
Use temporary tables 4 min
Use Common Table Expressions 4 min
Write queries that use derived tables 6 min
Exercise: Create queries with table expressions 30 min
Module assessment 4 min
Summary 1 min

Combine query results with set operators

48 min
Module
7 Units

Learn how to use Transact-SQL to combine query results.

Introduction 1 min
Use the UNION operator 4 min
Use the INTERSECT and EXCEPT operators 3 min
Use the APPLY operator 4 min
Exercise: Combine query results with set operators 30 min
Module assessment 5 min
Summary 1 min

Write queries that use window functions

51 min
Module
7 Units

Learn how to use window functions in Transact-SQL.

Introduction 1 min
Describe window functions 3 min
Use the OVER clause 5 min
Use RANK, AGGREGATE, and OFFSET functions 6 min
Exercise: Use window functions 30 min
Module assessment 5 min
Summary 1 min

Transform data by implementing pivot, unpivot, rollup, and cube

50 min
Module
6 Units

Learn how to transform data using Transact-SQL.

Introduction 1 min
Write queries that pivot and unpivot result sets 7 min
Write queries that specify multiple groupings with grouping sets 7 min
Exercise: Pivoting and grouping sets 30 min
Module assessment 4 min
Summary 1 min