Get Started Querying with Transact-SQL

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

Learn how to use Transact-SQL to query data in a database.


Familiarity with working with tables of data, for example in a spreadsheet.

Modules in this learning path

This module provides an introduction to relational databases, the SQL language and Transact-SQL. You'll learn what kinds of statements make up the SQL language and look at the SELECT statement in detail.

Learn how to sort and filter query results

Explore T-SQL queries accessing data from multiple tables with various kinds of JOIN operations.

Learn how to use subqueries to combine multiple SELECT statements and compose nested queries.

Learn how to use functions in Transact-SQL, and how to group aggregated results.

Learn how to use Transact-SQL to insert, update, and delete data in a database.