Query and modify data with Transact-SQL

This learning path teaches Transact-SQL, the dialect of SQL used by SQL Server and Azure SQL, from the first SELECT statement to modifying data. Microsoft's catalog lists it at 345 minutes, which we show as 5.8 hours, and marks it beginner level; the intended roles range from data analysts and developers to database administrators and students. Six modules run in order: an introduction to Transact-SQL, sorting and filtering results, combining tables with JOINs, writing subqueries, using built-in functions and GROUP BY, and modifying data with insert, update, delete and merge statements.

Each module is a set of text units with worked examples and a knowledge check; the hands-on exercises use a sample database, so you will need access to a SQL Server or Azure SQL environment of your own to run them. The path is free, like all Microsoft Learn training, and can be read without signing in, though a profile records progress and awards the completion trophy. Microsoft does not issue a certificate for finishing a learning path, so we list it without a credential.