How to Think Like the Engine
The first Microsoft database course you should ever take.
What you will get:
- Watch on any Device
- 2 sections
- lectures
- of video
Last updated: 15 March 2022
Your Instructor
I make Microsoft SQL Server go faster. I've been working with SQL Server since the late 1990s, and I'm one of the rare Microsoft Certified Masters of SQL Server. I love teaching, travel, and laughing. I live in Las Vegas, Nevada.
Course Description
You’re a developer or a DBA, and you’re comfortable writing queries to get the data you need. You’re much less comfortable trying to design the right indexes for your database server.
In my totally free How to Think Like the Engine class, you’ll learn how the SQL Server engine looks at your indexes and builds your query results. You’ll learn the differences between clustered and nonclustered indexes, how Microsoft SQL Server and Azure SQL DB stores them, and how to read an execution plan.
Course Curriculum
- Part 1: Clustered Indexes and the WHERE Clause (25:38)
- Part 2: ORDER BY and Caching (15:44)
- Part 3: Nonclustered Indexes, Seeks vs Scans (15:46)
- Part 4: Key Lookups, the Tipping Point, and Cost-Based Optimization (21:39)
- Part 5: Bad Queries and Wider Indexes (20:51)
- Part 6: Recap and Next Steps (5:56)