Episode 9: Query Planning and Optimization
In this lesson, we talk about what a query planner is and does in the database. We talk about the difference between declarative and imperative programming languages, and we wrap up with a discussion of some common strategies for database optimization.
▶︎
Episode 5: Distributed Databases Part 1
▶︎
Episode 8: Indexes
▶︎
Postgres Explain Explained - How Databases Prepare Optimal Query Plans to Execute SQL
▶︎
#15 - Query Planning & Optimization (CMU Intro to Database Systems)
▶︎
Episode 3: Transactions Part 1
▶︎
Microsoft Teams Is Watching You | Here's What They See
▶︎
SQL Execution Plans (Visually Explained) | SQL Hints | #SQL Course 40
▶︎
F2023 #14 - Query Planning & Optimization (CMU Intro to Database Systems)
▶︎
7 Must-know Strategies to Scale Your Database
▶︎
Episode 4: Transactions Part 2
▶︎
LIVE: Conan O’Brien speaks at Harvard graduation ceremony (full)
▶︎
Secret To Optimizing SQL Queries - Understand The SQL Execution Order
▶︎
The French Do Not Care About Work
▶︎
Episode 7: Distributed Databases Part 3 -- Consensus!
▶︎
Stop Rambling: The 3-2-1 Speaking Trick That Makes You Sound Like A CEO
▶︎
The ACTUAL audition that changed cinema forever
▶︎
Use MySQL EXPLAIN for Query Optimization
▶︎
Episode 1: Analytical vs. Transactional
▶︎
5-Minute SQL Performance Boost Using Execution Plans
▶︎