Get Started Querying with Transact-SQL

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.