Tired of slow database queries? This is the course for you!

This course is for any developer who wants to finally use database indexing as a super power. Regardless of your familiarity with databases, including any prior bad experiences with them, the concepts will be introduced in an intuitive new manner from the ground up. Think of this as the "Hello, World!" course for database indexing.

Centered around our exclusive IndeX-Ray™ technology, the modules in this course take you through the following journey:

  • An exploration of what an index "looks" like
  • Determining why queries and indexes pair so well together
  • What makes an index "good" and how the database can use them
  • Figuring out what the generally indexing guidelines are and why they are that way
  • Examining more interesting situations and the associated tradeoffs in them

The lessons are built using custom interactive exercises. This interactivity, combined with the novel representation of indexes, make this a course unlike any other. You will walk away with a strong understanding of how databases use indexes so that you no longer have to guess about which one you need (or ask ChatGPT to guess for you)!

What you'll learn:

  • What indexes are good for, along with when they are NOT helpful
  • Which columns should be included in an index
  • What order the columns in the index should be listed in
  • What factors to consider when tradeoffs are required.

Of course there are only so many exciting things that we can pack into a single place. Here are some things that this course is NOT:

  • A list of contextless rules which should always be followed
  • A look at other ways to improve database performance (e.g. via configuration or hardware)
  • Schema design
  • A dive into the nuances of the behavior of a specific database
  • An exploration of more complicated queries (e.g. those with JOINs or GROUPing) - stay tuned!

Ready to finally unlock the full power of databases?

Lifetime members get access to the course today!

FAQ

Is the course ready?
A bunch of valuable lessons are available for lifetime members to access today. In addition to locking in a discounted rate, lifetime members get tons of other perks including influencing how we refine the course as the final touches are put on it. Now is the best time to get started!
What database is this course applicable to?
Effectively all of them! The specific type of index we discuss in this course is widely used as the default index for most database systems. Although there are some differences in implementation details, the "big picture" is the same across the board.
I've worked with databases before, is there anything in this course for me?
Seasoned professionals who may already have a grasp on the subject matter from extensive experience with indexing may find the new perspective refreshing and useful for future conversations on the topic.