Improving Query Performance in SQL Server

Overview

This intermediate course addresses the challenge of optimizing slow-running SQL Server queries while improving code readability. Working with real-world sports and geoscience datasets, you examine standard formatting practices and methods to accelerate execution without altering query output.

Who It Is For

Designed for intermediate SQL users and database practitioners who need to refine existing SQL code and boost performance in scenario-driven tasks.

Key Takeaways

• Reformat poorly organized SQL code for improved legibility and maintenance.
• Analyze alternative query execution techniques using real-world datasets.
• Enhance SQL performance to deliver accurate results more efficiently.