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!
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 is an officially Business Intelligence Developer, focusing on Microsoft Data Platform technologies, especially Power BI - but “off the record” he is a data fanatic, interested in everything related to extracting meaningful information from the raw data. Nikola is self-proclaimed "Data-Mozart". As he lives in the wonderful city of Salzburg, Austria, which is well-known as the birthplace of W.A.Mozart, he was brave enough to use the composer's last name as part of his nickname. That'... more