Learn Backend Development Part-Time, Online
Power BI Fundamentals - Create visualizations and dashboards from scratch
Overview
Google, IBM & Meta Certificates — All 10,000+ Courses at 40% Off
One annual plan covers every course and certificate on Coursera. 40% off for a limited time.
Get Full Access
Learn about query planning and optimization in database systems through a comprehensive lecture from Carnegie Mellon University's Introduction to Database Systems course. Explore how database management systems transform SQL queries into executable plans, understand optimization techniques, and delve into the complexities of query processing. Professor Andy Pavlo guides you through essential concepts of query planning, demonstrating how databases make decisions to execute queries efficiently. Access accompanying slides and detailed notes to reinforce understanding of optimization strategies and execution plan generation in modern database systems.
Syllabus
#15 - Query Planning & Optimization (CMU Intro to Database Systems)
Taught by
CMU Database Group