Courses Tech Library

Free Live Masterclass

How to Understand Why Your SQL is Slow: The First Step to Faster SQL

 

Learn the 3 steps to see how your query is actually being run on the database and what may be causing the SQL to run slowly... so you know where to focus and to save yourself time.

Here's just some of what you'll learn during the Masterclass:

  • How to see the steps the database takes to execute your query, so you know what’s actually being done
  • How to read and understand these steps, so you can make sense of what you’re seeing
  • How to see where the biggest bottlenecks are in your query, so you know where to focus your improvement effort

Who is this for?

If any of the following sound like you, do yourself a favour and do not miss this masterclass...

  1. I'm tired of guessing why my query is slow and want to know the real reason.
  2. I know what the database does with my query, but I don’t know what it means or how to understand it
  3. I want to see where the biggest bottlenecks or slowest parts of my query are

Here's what some of my students have said...

Nancy T

Ben has simplified sub-queries for me, regex, and many other topics. I feel slow when reading a lot of explanations off the internet, but his explanations are so clear, they make these topics easy to understand.

Michal Z

Your courses are short and full of practical knowledge + you are responsive and you are listening!

Donna M

Your explanations are so clear and concise that you don’t need to go on and on and on as I have heard others do.

Got questions? I've got answers:

A Note from Ben...

I wish I'd known now what I knew back when I was getting started with SQL and trying to get my queries to perform better.

I've been running my website and YouTube channel, Database Star, for 7 years now,helping hundreds of thousands of visitors each month with improving their SQL and database skills.

And SQL performance is a helpful area to learn about.

I was always asking other, more senior team members for advice. This was good, as they were helpful, but I'm sure they would have been more impressed if I knew the basics of improving a query's performance.

 

I also spent many hours trying to work out why a query was slow and trying to understand what the database was doing.

This brand-new Masterclass aims to teach you how to see what the database does with your SQL query, and how to make sense of what it shows you.

Faster SQL can mean less time spent on a query, better user experience for users of your applications or reports, less time spent running your queries, and lower cloud computing costs.

Register for this Masterclass below to start the first steps on improving your SQL performance.

Can't wait to see you there!

Ben