Write advanced Transact-SQL queries

Data Analyst
Data Engineer
Data Scientist
Database Administrator
Solution Architect
SQL Database
SQL Managed Instance
SQL Server on Azure Virtual Machines
SQL Server on Virtual Machines
SQL Server

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


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

Modules in this learning path

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

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

Learn how to use window functions in Transact-SQL.

Learn how to transform data using Transact-SQL.