Live Instructor-Led SQL Server Training Classes

Performance Tuning Fundamentals

You need to make SQL Server go faster, fast. I do this stuff in real life every week, and I can teach you how to make it happen.

Recorded Class Season Pass

Want all of my Fundamentals? Get access to lots of self-paced recorded training for one low price. Teams of 3 or more folks get a discount, too.

Fundamentals of Index Tuning

The easiest way to make all of your queries go faster is to build the right indexes to support them. Learn how in one day.

Fundamentals of Query Tuning

You want faster queries, but you’re not comfortable reading execution plans, finding problems, and tuning T-SQL. Learn how in one day.

Fundamentals of Columnstore Indexes

Your report queries are too slow, and regular indexes aren’t enough. You’re on SQL 2016 or newer, and your data’s up over 250GB. Find out if columnstore indexes can help.

A query just suddenly runs slowly. Your fix is to update stats or rebuild indexes. It seems to work, but you don’t know why, and it keeps coming back. Understand why in one day.

Fundamentals of Server Tuning

You have a slow SQL Server, and you know the bottleneck is in there somewhere, but where? Learn how to measure and interpret wait stats, plus tune them, in 5 hours of videos.

You’ve downloaded my First Responder Kit with sp_Blitz, sp_BlitzCache, sp_BlitzIndex, and more, but you feel like you’re groping around blindly in the back seat of a car. Learn how I use these tools.

Mastering Performance Tuning

You’ve conquered the fundamentals, and now you’re ready for the toughest challenges.

My Mastering classes are live 3-day classes that push you harder than any other class or conference out there. In the morning, I teach you a concept with lectures & demos, and then you get 2 hours to do lunch and solve a tough lab with live queries. Then, the process starts again in the afternoon.

Most of my Mastering students get my Live Class Season Pass because they’ve already attended a few of my Fundamentals classes, and they trust me to raise their skill levels rapidly in just one year. Plus, they get Instant Replay access, so they can watch the most recent live classes whenever they want, jumping into a specific module when they’re facing a relevant problem at work.

Live Class Season Pass

The Live Class Season Pass gets you into all my live online classes for a year straight, over and over – including both my Fundamentals and Mastering classes, plus any new classes I bring out during your membership.

Want to learn quickly at your own rapid pace? Don’t need to wait for live classes? The Masters Class Recordings let you watch the Instant Replays of my most recent classes and work the labs on your own.

Mastering Index Tuning

You don’t have time to fix queries, and you need quick wins. Learn how to use my D.E.A.T.H. Method to fix indexes on an existing database, fast, in 3 days of live lab challenges.

Mastering Query Tuning

You need to speed up an existing app, and you’re allowed to change both queries & indexes, but you can’t throw hardware at it. Let’s tackle it in 3 days of live labs.

You’ve conquered Fundamentals of Parameter Sniffing, and now you need to master all the different ways to mitigate parameter sniffing problems for good. I’ll show you in 3 days of nonstop demos.

Mastering Server Tuning

You’re the kind of admin who’s constantly facing new performance challenges on different servers. Learn how to solve lots of different problems in 3 days of my toughest lectures & labs.

Database Administration Training

Databases are harder than ever – with even more specialized topics to learn.

Remember that day when the senior DBA sat you down and gave you clear, specific instructions on how to handle SQL Server? No? Ah, that never happens. Let’s get you started.

DBA Job Interview Questions and Answers

You don’t go to a lot of job interviews, and you don’t really talk about what you do for a living. So how are you supposed to pass these things? I’ll show you how to ace it.

Menu
{"cart_token":"","hash":"","cart_data":""}