Get Started Querying with Transact-SQL

  • Learning Path
  • 6 Modules
Beginner
Data Analyst
Data Engineer
Data Scientist
Database Administrator
Developer
Solution Architect
Student
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.

Prerequisites

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

Modules in this learning path

Introduction to Transact-SQL

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.

Sort and filter results in T-SQL

Learn how to sort and filter query results

Combine multiple tables with JOINs in T-SQL

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

Write Subqueries in T-SQL

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

Use built-in functions and GROUP BY in Transact-SQL

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

Modify data with T-SQL

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