Course curriculum

  • 1

    Module 01: SQL Server Architecture, Scheduling, and Waits

    • 01 Presentation

    • 01 Reading

    • 01 Lab
  • 2

    Module 02: SQL Server I/O

    • 02 Presentation

    • 02 Reading

    • 02 Lab
  • 3

    Module 03: Database Structures

    • 03 Presentation

    • 03 Reading

    • sql_pt_lab_03
  • 4

    Module 04: SQL Server Memory

    • 04 Presentation

    • 04 Reading

    • 04 Lab
  • 5

    Module 05: SQL Server Concurrency

    • 05 Presentation

    • 05 Reading

    • 05 Lab
  • 6

    Module 06: Statistics and Index Internals

    • 06 Presentation

    • 06 Reading

    • 06 Lab
  • 7

    Module 07: Query Execution and Query Plan Analysis

    • 07 Presentation

    • 07 Reading

    • 07 Lab
  • 8

    Module 08: Plan Caching and Recompilation

    • 08 Presentation

    • 08 Reading

    • 08 Lab
  • 9

    Module 09: Extended Events

    • 09 Presentation

    • 09 Reading

    • 09 Lab
  • 10

    Module 10: Monitoring, Tracing, and Baselines

    • 10 Presentation

    • 10 Reading

    • 10 Lab