This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Learn how to use Transact-SQL to query data in a database.
Familiarity with working with tables of data, for example in a spreadsheet.
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.
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.