Get Started Querying with Transact-SQL

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-sqlserver-vm
azure-sql-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.

Start

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.

Start

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.

Modify data with T-SQL

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