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

SQL Database

SQL Server

SQL Managed Instance

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 will 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.