Understanding how SQL Server indexing works is crucial for diving deeper into SQL Server internals and overall becoming a SQL Server “badass” :) Having said that, it’s definitely not an easy topic to pickup and comprehend.
I’ve seen many videos online on Indexing and none of them really sunk in with me. Either the teacher was boring (monotone voice) which would put me to sleep, or the pace and material flat out was confusing.
I recently finished, in my opinion, the best course out there on SQL Server Indexes.
BEST SQL Server Indexing Course
Kimberly Tripp’s “SQL Server: Indexing for Performance” is a 7+ hour long course that dives deep into all aspects of Indexes. I highly recommend it for people who are passionate about SQL Server.
If you want to take your game to the next-level, take this course.
Why is it the Best
Why do I claim this is the best? Well first of all, it’s Kimberly Tripp. If you don’t know who that is, then you better “check yourself before you wreck yourself” (Ice Cube reference). Second, her method of teaching doesn’t put me to sleep! If you have taken her courses before (in person or online) you know that she anticipates a level of student confusion and mentions that during her training, i.e. “I know you might be thinking…” I have taken SQLSkills IEPTO1 and many of their online courses, I can’t count how many times I’ve said to myself, “wow, they read my mind!” Third, you’re learning from the best!
Tips for Learning
In an earlier blog post titled, “How to Study Smarter, Not Harder” I mention a few methods to help retain knowledge faster/smarter. I’m sure it will help when you’re studying a topic as complex as SQL Server Indexing :)