Featured resource
pluralsight tech forecast
2025 Tech Forecast

Which technologies will dominate in 2025? And what skills do you need to keep up?

Check it out
Hamburger Icon
  • Course
    • Libraries: If you want this course, consider one of these libraries.
    • Data

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!

Nikola Ilic - Pluralsight course - Understanding Query Optimization in SQL Server
by Nikola Ilic

What you'll learn

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.

Table of contents

About the author

Nikola Ilic - Pluralsight course - Understanding Query Optimization in SQL Server
Nikola Ilic

Nikola has multi-year experience working with various flavors of data, predominantly with Microsoft BI stack. Started with SQL Server, then brushed himself with SSAS Multidimensional, SSIS, SSRS, Power BI, Azure, etc. Nikola is really curious by nature and always trying to learn something new.

More Courses by Nikola