Query Optimizer Deep Dive
Offered By: PASS Data Community Summit via YouTube
Course Description
Overview
Delve into the intricacies of query optimization in this advanced-level conference talk presented by Paul White from SQL Kiwi Limited. Explore the inner workings of database query optimizers, gaining insights into their decision-making processes and learning techniques to improve query performance. Discover strategies for analyzing execution plans, identifying bottlenecks, and fine-tuning SQL statements for optimal efficiency. Enhance your understanding of cost-based optimization, statistics management, and index selection to write more effective queries and troubleshoot complex performance issues in database systems.
Syllabus
Query Optimizer Deep Dive (AD)
Taught by
PASS Data Community Summit
Related Courses
Introduction to DatabasesMeta via Coursera Web Development
Udacity Introduction to Data Science
University of Washington via Coursera Datenmanagement mit SQL
openHPI Sabermetrics 101: Introduction to Baseball Analytics
Boston University via edX