Module 1: SQL Server Architecture, Scheduling, and Waits

• SQL Server Components and SQL OS
• Windows Scheduling vs SQL Scheduling
• Waits and Queues 

Module 2: SQL Server I/O

• Core Concepts
• Storage Solutions
• I/O Setup and Testing

Module 3: Database Structures

• Database Structure Internals
• Data File Internals
• TempDB Internals

Module 4: SQL Server Memory

• Windows Memory
•  SQL Server Memory
• In-Memory OLTP

Module 5: SQL Server Concurrency

• Concurrency and Transactions
• Locking Internals

Module 6: Statistics and Index Internals

• Statistics Internals and Cardinality Estimation
•  Index Internals
•  Columnstore Indexes

Module 7: Query Execution and Query Plan Analysis

• Query execution and optimizer internals
• Query execution plans
• Analyzing query execution plans
• Adaptive query processing

Module 8: Plan Caching and Recompilation

• Plan cache internals
•  Troubleshooting plan cache issues
• Automatic tuning
• Query store

Module 9: Extended Events

• Extended events core concepts
• Working with extended events

Module 10: Monitoring, Tracing, and Baselining

• Monitoring and tracing
• Baselining and benchmarking