Understanding Query Optimization in SQL Server

Focused View

Nikola Ilic

1:23:54

25 View

1. Course Overview

1. Course Overview.mp4

01:28

2. Introducing Query Optimization in SQL Server

1. Introducing Query Optimization in SQL Server.mp4

05:30

2. Introducing SQL Server Query Optimizer.mp4

03:59

3. Understanding the Stages of the Query Optimization Process.mp4

02:59

4. Demo - Capturing Query Performance Metrics.mp4

06:16

3. Understanding Query Plans

1. Understanding Query Plans.mp4

02:48

2. Reading and Interpreting the Query Plan.mp4

04:15

3. Demo - Analyzing and Comparing Query Plans with SSMS.mp4

04:48

4. Understanding Plan Reuse and Plan Cache

1. Understanding Plan Caching.mp4

05:49

2. Demo - Querying Plan Cache for Ad Hoc and Prepared Workloads.mp4

05:43

5. Understanding Indexing and Statistics

1. Introduction to Indexing with SQL Server.mp4

06:37

2. Index Design Recommended Practices.mp4

01:58

3. Demo - Understanding Query Performance with Indexes.mp4

04:59

4. Understanding Statistics.mp4

02:44

5. Demo - Understanding Query Performance with Statistics.mp4

05:54

6. Optimizing Ad-hoc Expressions and Parameterization

1. Demo - Optimizing for Ad Hoc Workloads.mp4

02:54

2. Understanding Parameter Sniffing.mp4

03:54

3. Demo - Parameter Sniffing and Recompiling.mp4

04:05

7. Understanding Plan Guides and Query Hints

1. Understanding Plan Guides.mp4

03:22

2. Demo - Optimizing Performance with Query Hints.mp4

03:52

Description

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.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

SQL Server

Microsoft SQL

Nikola Ilic

Instructor's Courses

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's why Nikola's professional motto is: "Make Music from your Data!" Coming from the business environment, Nikola holds a Bachelor’s degree in both Communicology and Computer Science. He is regularly blogging on data-mozart.com and speaking at global data conferences. Nikola is also a Microsoft Data Platform MVP, Microsoft Certified Trainer, and a certified Data Analyst.

Pluralsight

View courses Pluralsight

Pluralsight, LLC is an American privately held online education company that offers a variety of video training courses for software developers, IT administrators, and creative professionals through its website. Founded in 2004 by Aaron Skonnard, Keith Brown, Fritz Onion, and Bill Williams, the company has its headquarters in Farmington, Utah. As of July 2018, it uses more than 1,400 subject-matter experts as authors, and offers more than 7,000 courses in its catalog. Since first moving its courses online in 2007, the company has expanded, developing a full enterprise platform, and adding skills assessment modules.