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.

Module Lab
Setup Lab Environment Setup - Local SQL Server
Setup Lab Environment Setup - Azure SQL Database
Setup Lab Environment Setup - Microsoft Fabric
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 Transact-SQL
Additional exercises Create stored procedures and functions in Transact-SQL
Additional exercises Implement error handling with Transact-SQL
Additional exercises 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