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:

You can complete the exercises using:

A local installation of SQL Server
Azure SQL Database

Setup instructions are provided for both of these options.

Lab
	Lab Environment Setup - Local SQL Server
	Lab Environment Setup - Azure SQL Database
	Lab Environment Setup - Microsoft Fabric
	Get Started with Transact-SQL
	Sort and Filter Query Results
	Query Multiple Tables with Joins
	Use Subqueries
	Use Built-in Functions
	Modify Data
	Create queries with table expressions
	Combine query results with set operators
	Use window functions
	Use pivoting and grouping sets
	Introduction to programming with Transact-SQL
	Create stored procedures and functions in Transact-SQL
	Implement error handling with Transact-SQL
	Implement transactions with Transact SQL

Instructor demo’s

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