YoVDO

Query Optimizer Deep Dive

Offered By: PASS Data Community Summit via YouTube

Tags

PASS Data Community Summit Courses SQL Courses Performance Improvement Courses

Course Description

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
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

Doing More with Less - The Challenges Ahead for Every Data Professional
PASS Data Community Summit via YouTube
Build a Modern Data Strategy and Put Your Data to Work
PASS Data Community Summit via YouTube
Transform Your Data Estate
PASS Data Community Summit via YouTube
Azure SQL and SQL Server 2022 - Intelligent Database Futures
PASS Data Community Summit via YouTube
SQL Server in Azure Virtual Machines Reimagined
PASS Data Community Summit via YouTube