Fundamentals · Live class · Nov 2–6, 2026
Fundamentals Week
Mon–Tue Index Tuning, Wed Query Tuning, Thu–Fri Server Tuning. Five half-days, live, with labs.
$1,495 one payment
Next rotation
Live registration opens October 1, 2026.
12d 10h 19m
One email when registration opens, with first dibs on seats. That’s it.
Dates & times
Five half-days, live. Then the whole thing again, every rotation.
Your next session
Nov 2–6, 2026
Monday to Friday, five half-days. Lectures live, questions answered as we go, optional labs after.
Also attend every later rotation
- Spring 2027 Mar 1–5, 2027 · Mon–Fri
- Summer 2027 Jun 28–Jul 2, 2027 · Mon–Fri
- Fall 2027 Nov 8–12, 2027 · Mon–Fri
Same class, every rotation through Feb 2028, included. Miss a day this time? Catch it next time. Or come twice: the labs are different every time I run them.
Class hours, every day
| Pacific | 9:00 AM – 1:00 PM |
|---|---|
| Eastern | 12:00 PM – 4:00 PM |
| GMT | 17:00 – 21:00 |
Pacific and Eastern are the fixed ones: class always runs 9 AM Pacific. GMT shifts to 16:00 – 20:00 for rotations held while the US is on daylight saving time, roughly March through October.
What’s included
- The Recorded Class Season Pass: Fundamentals (all 10 recordings), right now.
- Five live half-days, Nov 2–6, 2026, with me answering questions as we go.
- A seat in all 3 later rotations too, through Feb 2028, and each new recording as it’s cut.
- Recordings through Dec 31, 2026; live seats through Feb 2028. One payment, no auto-renew.
Live attendees get listed in my public alumni directory (name and class, opt-in). Recordings-only buyers don’t. See the alumni directory →
Curriculum · Every lecture
Three classes, five half-days.
- 3 classes
- Live, with labs after each day
- Recordings included
- Taught by Brent Ozar
Fundamentals
Fundamentals of Index Tuning 2026
$195 on its own
Before the Class
- Introductions 15:08
- Prerequisites
- Change Log for This Class
- Download the Slides & Demos
The Most Important Index Internals
- Setting Good Defaults for New Tables 53:31
- Reading SQL Server’s Missing Index Requests 26:49
- How to Visualize Index Contents 30:33
Designing Indexes for Individual Queries
- Designing Indexes for the WHERE Clause 30:03
- Brent Does Your First Hands-On Lab 59:04
- Designing Indexes for ORDER BY 24:58
- Designing Indexes for JOINs 40:46
Designing and Maintaining Indexes at Scale
- Designing Indexes at Scale 55:11
- How to Maintain Databases in 2026 40:19
- Recapping What You Learned 9:52
- Brent Does the Final Lab 65:14
Fundamentals
Fundamentals of Query Tuning 2026
$195 on its own
Before the Class
- Prerequisites
- Change Log for This Class
- Introductions 1:27
- Download the Slides & Demos
How Plans Get Built
- How SQL Server Builds Query Plans 51:24
- Good Defaults for New Apps 30:04
- Tools to Improve Cardinality Estimation 92:02
- Execution Plans are Lying Liars 39:27
Recap
- Class Recap 7:31
Lab, Improving Cardinality Estimation
- Lab Setup 2:51
- Fixing usp_RptUsersByName 22:16
- Fixing usp_UsersOutracingMe 12:51
- Fixing usp_RptControversialPosts 20:08
- Fixing usp_YouVsJonSkeet 11:30
Fundamentals
Fundamentals of Server Tuning 2026
$195 on its own
Before the Class
- Prerequisites
- Change Log for This Class
- Download the Slides & Demos
- Introductions and Lab Setup 9:55
Class Modules
- Measuring Your SQL Server 56:27
- When CX Is Your Top Wait Type 30:52
- When PAGEIOLATCH Is Your Top Wait Type 39:07
- Recap 7:42
- Brent Does the Hands-On Lab 15:18
This class is included in…
Or take every live class this year.
One bundle contains this class, and it contains everything else too.
Live Class Season Pass 2027
One pass. Every class. All year.
Fundamentals Week and all three Mastering classes, live, every rotation through Feb 2028. Plus the Recorded Class Season Pass: Fundamentals + Mastering (all 13 recordings) the minute you buy, and your name in the alumni directory.
$4,395 one payment
Registration opens October 1, 2026Prerequisites & logistics
The fine print, in regular-size type.
- Labs (optional)
- Labs follow each day’s lectures and are optional.
- Alumni directory
- Live attendees are listed at brentozar.com/classes/alumni/ (name and class, opt-in).
- Access
- Recordings through Dec 31, 2026, on training.brentozar.com. One payment, no auto-renew.
- Refunds
- None. Watch the free previews and read the curriculum above first; that’s what it’s there for.
- Purchase orders
- Accepted for 10 or more seats; email help@brentozar.com for a quote. Everything else goes through the website by credit card.
Free, 3× a week
3 posts a week, in your inbox
Plus a Monday roundup of my favorite database news from around the web. No fluff, occasional jokes.
Questions first
Not sure this is the one?
Email help@brentozar.com and tell me what’s slow. It’s me answering, and I’d rather sell you the right class than the biggest one.
Email me