https://sqlmaster.mssqlplanner.com

SQL Server Course Index

SQL Server Course Index

Every lesson in this series, organized by course. Pick your track and expand for the full chapter-by-chapter map.

Beginner ✓ COMPLETE

SQL Server Fundamentals

Zero to confident with Microsoft SQL Server — data manipulation, queries, aggregate functions, multi-table joins, and data integrity.

8 chapters25 lessons25 published

Start Here

View Full Course Index

Ch. 0 — Orientation

Ch. 1 — SQL & Database Foundations

Ch. 2 — Data Manipulation (DDL & DML)

Ch. 3 — Queries

Ch. 4 — Aggregate & Built-in Functions

Ch. 5 — Multiple Tables

Ch. 6 — Keys, Constraints & Data Integrity

Ch. 7 — Capstone

Advanced ✓ COMPLETE

SQL Server for Developers & DBAs

Production-grade T-SQL: stored procedures, functions, temp objects, triggers, transactions, indexing, performance tuning, and interview prep.

12 chapters39 lessons39 published

Start Here

View Full Course Index

Ch. 1 — Advanced T-SQL Programming

Ch. 2 — Functions Deep Dive

Ch. 3 — Temp Objects Deep Dive

Ch. 4 — Stored Procedures

Ch. 5 — Business Rules, Constraints & Keys

Ch. 6 — Views, CTEs & Window Functions

Ch. 7 — Triggers

Ch. 8 — Performance Tuning & Indexing

Ch. 9 — Transactions & Concurrency

Ch. 10 — Security Essentials

Ch. 11 — Interview Preparation & Scenarios

Ch. 12 — Capstone

Expert ✓ COMPLETE

SQL Server Performance Tuning

Architecture, indexing strategy, query optimization, execution plan analysis, locking & concurrency, monitoring/tooling, and advanced performance features — the evidence-first diagnostic workflow real DBAs use.

7 modules38 published

Start Here

View Full Course Index

Intro — Methodology

Module 1 — Architecture Fundamentals

Module 2 — Indexing Strategy

Module 3 — Query Optimization

Module 4 — Execution Plan Analysis

Module 5 — Locking & Concurrency

Module 6 — Monitoring & Tooling

Module 7 — Advanced Performance

Bonus Content