Write advanced Transact-SQL queries

  • Learning Path
  • 4 Modules
Advanced
Data Analyst
Data Engineer
Data Scientist
Database Administrator
Developer
Solution Architect
Student
Azure SQL Database
Azure SQL Managed Instance
SQL Server on Azure Virtual Machines
Azure SQL Server on Virtual Machines
SQL Server

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

Modules in this learning path

Create tables, views, and temporary objects

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

Combine query results with set operators

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

Write queries that use window functions

Learn how to use window functions in Transact-SQL.

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

Learn how to transform data using Transact-SQL.