Get Started Querying with Transact-SQL

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

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.