Mastering Query Tuning

(24 customer reviews)


You need to speed up a SQL Server app, and you’re allowed to change the queries and indexes – but not the server hardware or settings. We’ll teach you how in 3 days of learning and fun.

  • $0.00

Product Description

You need to speed up a SQL Server app, and you’re allowed to change the queries and indexes – but not the server hardware or settings. Good news – I’ll teach you how in 3 days of learning and fun. Join me, Brent Ozar, as I explain how to make your SQL Server apps go faster.

Labs & lectures include:

  • How SQL Server builds query plans
  • How to find the queries you need to focus on first so end users will notice an improvement
  • How to choose between CTEs, temp tables, and APPLY
  • How to tune for SELECT * and lots of rows
  • How to write dynamic SQL that scales
  • How to avoid pitfalls like deadlocks and parameter sniffing
  • How SQL Server 2017 & 2019’s new robots help (and hurt)

Prerequisites – first, you need to be already thoroughly familiar with these classes:

Each student needs to bring their own SQL Server. You’re highly encouraged to follow along with the labs – twice a day during the class, you’ll have homework where you need to complete a hands-on lab using SQL Server 2017 or 2019 and the Stack Overflow database. Read the instructions on how to set up your own lab SQL Server to follow along – a lab server is not included unless you buy my Live Class Season Pass PLUS Lab VM.

This mix of lectures and hands-on labs helps reinforce the topics you’re learning and makes sure that you’ll be able to tackle the same kinds of projects in your own environment. (Many students do just that: after hours, they switch into their own environments and use the same diagnostic queries to make immediate improvements in their apps.)

This is a live online class – but you have two buying choices:

24 reviews for Mastering Query Tuning

  1. Chris Beecy (verified owner)

    A good training course will teach you something that you can apply at work within a week to solve a problem for your team making you queen for the day. A great training course will shatter many misconceptions you have clung to, humble you, make you quietly change your ways and your code, AND make you consider killing some of the people that have trained you. This was a great course! If you trained me in the past, sleep with one eye open until I decide.

  2. Mokles (verified owner)

    Brent is a great educator and presenter. The course is designed very well. He keeps the presentation very engaging. That makes learning enjoyable, and efficient. The exercises are designed well to bolster the understanding of the topic. Highly recommended.

  3. Angela Couch (verified owner)

    This class is a must-have for database professional. Brent’s class delivery is impeccable. He is very proficient and engaging. He demystified performance tuning with a very effective methodology that I put in use at my work right away. I especially appreciate the way he talks through his logic of resolving problems. After years of being a DBA, I feel a lot of knowledge he shared was still eye popping/opening to me. His performance tuning training series are the most useful classes I have had.

  4. Jay Taylor (verified owner)

    Brent is entertaining and full of knowledge. The class is a joy. I picked up tons of useful Sql Server background that I use often. The class has helped me spot lurking problems in existing procs and functions that previously I would have skipped over, unknowing. It’s like being trained to fend for yourself in the wilderness.

  5. Mokles (verified owner)

    Both the content and presentation of the class are of top quality. Brent is very enthusiastic, makes it fun, while keeping the class on track. I am very glad that I signed up for this class. Now instead of guessing we can pinpoint performance issues and provide possible solutions. This gives a great satisfaction in everyday work. Being able to replay the recorded videos is also a big plus.

  6. Michael Devor (verified owner)

    This class both elevated and lowered my perception of my own knowledge. I now know many more things than I did before as well as how little I actually knew before the class. The class was very challenging and informative, I could not really ask for anything more based on the time provided. Even with a fairly good group of people Brent was able to provide constant feedback and information to each individual based on their understanding and experience. The black friday deal was the best money that I have spent on training in my career and I am only scratching the surface. I look forward to completing all of the available classes multiple times.

  7. Sam Carey (verified owner)

    Mastering query tuning is a great for beginners and experts alike. Not only will you see new techniques and approaches, you get to see the ramifications of some popular bad habits. Great exercises and labs to challenge you and the opportunity to watch a pro’s pro walk you through various approaches for talking tough problems. You’re only regret taking the class was you didn’t sign up sooner.

  8. Carlos Perez (verified owner)

    Great class was enjoyable and very informative. The class as a whole was eye opening and the value of the class was well worth it. I ran the labs on my end but all were straightforward and were similar to what I am experiencing at work. Unfortunately I did miss small sections due to work issues but the amazing part of it is that there are recordings. Highly recommend this class. Thank you again Brent.

  9. kalotai (verified owner)

    If Mastering Index Tuning is a must have, Mastering Query Tuning is an absolute must have. I already know I will be in trouble for Mastering Server Tuning in about a month time :). Back to Mastering Query Tuning: it is not only informative, but the knowledge transfer is very entertaining too. And there is a great amount of knowledge in the class. By the end of the third day my head was tried to burst open a bit with the extra information, as it turned out I was not alone with this. I feel about Mastering classes as I feel about electric heated motorcycle gear: until you try it, you cannot even imagine what you missing from life. Once you had it, you do not want to live without it. If you work with SQL and you can only have one training course in your life, you really need to pick the Mastering classes. Go for all 3.

  10. Mohammad Darab (verified owner)

    Another very educational, eye-opening course in the Mastering series! I’m not a developer by any means but after this course I am pretty comfortable tackling slow performing queries. Thank you Brent!

  11. Andy Benner (verified owner)

    After taking the Mastering Index Tuning class, I was expecting to come into Mastering Query Tuning and learn a lot. I was not disappointed. I would argue this class is harder then Index Tuning. There are just more moving parts to understand and take advantage of.
    One of the things I enjoy about this training is watching someone do things that are not necessarily part of the “plan” and then figure out what went wrong. Brent does a good job of it live. He’s not just a “trainer” who is parroting things off an MS SQL Server Training slide deck.
    I really like this training format. Brent does a great job in front of the camera.

    The difference between people that want 10 and 20 minutes breaks made me laugh out loud !

  12. Jeremy Baxendell (verified owner)

    Brent shares his knowledge of the query optimizer’s dark secrets. He explains what most people are tempted to do, why that’s probably a bad idea, and offer some interesting alternatives. This is a very useful training for anyone that is looking to gain mastery of their DBA profession.

  13. Sammy (verified owner)

    The training was a big eye opener for me, revealing logical ways of tuning query as well as the underline technical details.

  14. Michael Hinz (verified owner)

    I’ve followed Brent for years and was recently able to take this class, and it didn’t disappoint. Brent is a great speaker and is able to keep the conversation interesting, and the labs and demos are extremely useful. I’ll easily be able to take most of this and apply it in my job, and that’s what makes it worth the cost. Can’t wait for the next class!

  15. Douglas Riga (verified owner)

    Great course for learning to understand how query design decisions can affect performance. This course really gave me insight in how to change queries to improve performance and to look at external factors that affect query performance as well. The labs were challenging and informative and the entertaining lectures, as always, are packed full of information.

  16. Heather Hahn (verified owner)

    Brent is a truly amazing instructor. I always find myself glued to my monitor during class in awe at how knowledgeable he is and how he can explain things so clearly and make each subject that he teaches so interesting. He always knows how to deliver the material in a fun and unique way that helps to more easily grasp the ideas and concepts. Erik and Brent are a great team and I found myself learning so much from them along with laughing out loud throughout the training which makes these classes not only full of great information but delivered in an exciting and entertaining way. These classes are NEVER dry, dull, or boring. So, if you are looking for that kind of class, don’t take this one! LOL Instead of staring at executions plans for hours until your eyes bleed, Brent actually makes reading and digging into them more amusing and fun. I can never look at an execution plan again and not hear the voices of Clippy or SQL Server and second guessing and questioning everything they would ever recommend for me to do in order to improve it.
    The training sections of the class were fully-loaded with great content and examples that Brent walks you through to teach you the ideas and concepts that you can apply to the lab sessions. Labs were do-able but challenging, in a very good way! to really make you think about how to apply the concepts you just learned and work through real-world examples that you might face on your own.
    I really enjoyed this class along with the Mastering Index Tuning course and I would recommend this to anyone looking to boost their SQL DBA skills and Master Query Tuning.

  17. Payam (verified owner)

    Brent really knows what he teaches genuinely. Although his focus is MS SQL, the mechanics and concepts he is teaching is eye-opener and insightful for other databases as well. I used many of the ideas in the class as a key to finding the relevant stuff for other RDBs as well.

  18. Brian Huff

    Very engaging and informative. The class covers real-world situations, including VM’s with DB’s and stress test data so you can immediately use knowledge in a real-world situation. Brent and Eric are right there to assist as you work through the labs.

    I was able to take the lessons and apply them in my production environment.

    Great experience, hard to come by these days in online-training.

  19. Daryl Smith (verified owner)

    The training is first-rate. The actual work is hands on after watching Brent and Erik walk through similar type issues in StackOverflow base data.
    Immediately after this class I have a list of items I need to address in my environment, including the modification of a multi-statement function to a Inline Table Function. This trick cut the time of one of my ETL’s by almost half.
    Knowledgeable, interesting, focused training. THANKS!

  20. Victoria L. Ree (verified owner)

    Excellent, fun, engaging!

  21. Bryan Rebok

    This class was a thorough reminder of how skilled Brent Ozar and Erik Darling are at query tuning and how much more I have to learn. The structure of the course was unique and wonderful in that the labs were realistic representations (not AdventureWorks) of many of the same problems that we fight in production every day – with not necessarily one “right answer” to the problem. It was also very cool to see the presenters go off-script and adapt their query tuning approach on the fly. This class is training that is well worth the time.

  22. Kevin Kelso (verified owner)

    This class gave me a giant toolkit for improving query performance. I found holes in my current process as well. I look forward to finding bad queries now because I can make them so much better. I highly recommend you take this course if you have queries that need to be tuned. You won’t be disappointed or bored while the Brent Ozar team provides a fun but very intense class.

  23. Todd Nelson (verified owner)

    Mastering Query Tuning is another fantastic training offering from Brent Ozar Unlimited. Brent and Erik did a fantastic (and entertaining) job of presenting the material and associated triage and tuning methods. The interactive discussion in Slack was very beneficial. The well planned course labs allow attendees to experience, triage, and improve on all of the issues present in the demo database. After spending hours with the lab environment I feel confident that I can diagnose and solve (or at least improve) any of the issues in our production environment.

  24. James Smith (verified owner)

    The class is well worth the cost. Many of the queries that we tuned is very close to the same problems my company has in our system. Everything that we went over will be directly used in my office daily. I have already signed up to take this class again.

    Interaction between teacher and student
    Best VM setup for testing
    Example queries to tune
    Everything is recorded for playback
    All scripts provided
    Classroom material

    Wish the class was longer

    Work Cons:
    Leave me alone during training!

Only logged in customers who have purchased this product may leave a review.

Bert Wagner of SQL with Bert attended one of our Mastering classes with hands-on labs, and here’s what he said about the quality of the labs and how our online classes are so different:

You may also like…