Understanding Query Optimization in SQL Server

Retrieving the data from SQL Server is something that every data professional should know. However, retrieving the data from SQL Server in an efficient and performant way is a mastery of its own!

Retrieving the data from SQL Server in an efficient and performant way is a mastery of its own! In this course, Understanding Query Optimization in SQL Server, you’ll gain the ability to create and maintain efficient and performant T-SQL queries. First, you’ll explore when and how to start troubleshooting your queries. Next, you’ll discover why it is important to read and understand query plans and how plan caching features may speed up query execution. You’ll also understand the benefit of having a proper indexing strategy and up to date statistics. Finally, you’ll learn how to optimize T-SQL queries in various scenarios and how to avoid the most common pitfalls when writing your T-SQL code. When you’re finished with this course, you’ll have the skills and knowledge of query optimization in SQL Server needed to retrieve the data from SQL Server in the most efficient and performant way.

• Course Overview 1min
• Introducing Query Optimization in SQL Server 18mins
• Understanding Query Plans 11mins
• Understanding Plan Reuse and Plan Cache 11mins
• Understanding Indexing and Statistics 22mins
• Optimizing Ad-hoc Expressions and Parameterization 10mins
• Understanding Plan Guides and Query Hints 7mins