Loading page
SQL / Learning path
84 lessons · 19h 28m estimated · Beginner
Start your path
Your first lesson is ready.
Progress appears here after you complete a lesson.
Pick up where you left off.
Learning path
SQL learning path
Learn SQL Server from relational foundations through queries, data changes, design, performance, and advanced T-SQL in 13 practical chapters.
Browse lessons↓Completion is saved in this browser.
Follow the route
Module 1
Understand what SQL Server stores, how tables connect, and how to set up the shared practice dataset.
Module 2
Read chosen columns, shape results, and understand the order in which SQL Server evaluates a query.
Module 3
Use predicates and explicit ordering to retrieve precise, repeatable result sets.
Module 4
Work with SQL Server values, conversions, conditional expressions, and common functions.
Module 5
Summarize rows at the intended grain and recognize misleading counts after joins.
Module 6
Combine related tables and compatible result sets while checking cardinality.
Module 7
Use subqueries, CTEs, recursion, and APPLY to express related queries.
Module 8
Practice INSERT, UPDATE, DELETE, and transaction rollback without changing the shared dataset.
Module 9
Design tables and constraints using disposable practice objects.
Module 10
Rank, compare, and aggregate rows across ordered windows.
Module 11
Understand transaction boundaries, isolation, locks, and error cleanup.
Module 12
Inspect access structures and plans while measuring changes against stable results.
Module 13
Use procedures, functions, JSON, permissions, and an end-to-end report safely.