Transact-SQL Exercises and Demonstrations

These exercises and demos support Microsoft course DP-080: Querying with Transact-SQL and the associated Microsoft Learn training content in the following learning paths:

Links to each of the lab exercises and demos are listed below.

Module	Lab
Setup	Lab Environment Setup
Module 1: Getting Started with Transact-SQL	Get Started with Transact-SQL
Module 2: Sorting and Filtering Query Results	Sort and Filter Query Results
Module 3: Using Joins and Subqueries	Query Multiple Tables with Joins
Module 3: Using Joins and Subqueries	Use Subqueries
Module 4: Using Built-in Functions	Use Built-in Functions
Module 5: Modifying Data	Modify Data
Additional exercises	Create queries with table expressions
Additional exercises	Combine query results with set operators
Additional exercises	Use window functions
Additional exercises	Use pivoting and grouping sets
Additional exercises	Introduction to programming with T-SQL
Additional exercises	Create stored procedures in T-SQL
Additional exercises	Implement error handling with T-SQL
Additional exercises	Implement transactions with Transact SQL

Demos

Module	Demo
Module 1: Getting Started with Transact-SQL	Module 1 Demonstrations
Module 2: Sorting and Filtering Query Results	Module 2 Demonstrations
Module 3: Using Joins and Subqueries	Module 3 Demonstrations
Module 4: Using Built-in Functions	Module 4 Demonstrations
Module 5: Modifying Data	Module 5 Demonstrations