Learn SQL Server & T-SQL — Microsoft's Database Language

Microsoft SQL Server runs a huge share of enterprise systems, and its dialect — T-SQL — is the SQL flavour you'll need for any role touching the Microsoft data stack. This free interactive tutorial covers T-SQL from basic queries to stored procedures, window functions, CTEs, and query optimisation.

Every topic includes worked examples you can run against AdventureWorks-style sample tables, practice exercises, and a quick quiz. Use the sidebar to dive into the feature you need, or follow the chapters in order to build T-SQL fluency end-to-end.

What you'll master in T-SQL and SQL Server

• T-SQL syntax, batches, and the GO separator
• SELECT, joins, common table expressions (CTEs)
• Window functions and the OVER clause
• Stored procedures, user-defined functions, and triggers
• Indexes, statistics, and execution plans
• Transactions, isolation levels, and snapshot isolation