SQL Server Performance Essentials – Full Course

In this course, Essentials of SQL Server Performance For Every Developer, you will see how to diagnose what is happening with a slow running SQL statement and what strategies are available to make these statements run faster.

By the end of this course, you as an application developer will have the tools you need to troubleshoot performance problems you may encounter when using SQL Server.

⭐️ Course Contents ⭐️
⌨️ (0:00:00) Introduction

Getting Started
⌨️ (0:00:53) 1.1 Course Introduction
⌨️ (0:04:07) 1.2 Why Developers should Understand SQL Performance
⌨️ (0:06:20) 1.3 Tools you Need
⌨️ (0:09:30) 1.4 Restore the Sample Database
⌨️ (0:12:04) 1.5 Table Concept
⌨️ (0:17:12) 1.6 Index Concept
⌨️ (0:20:32) 1.7 Summary

Analyzing SQL Statements for Performance
⌨️ (0:22:12) 2.1 Introduction
⌨️ (0:24:55) 2.2 Understanding How SQL Server Will Execute a SQL Statement
⌨️ (0:29:33) 2.3 Reading and Interpreting an Execution Plan for a SQL Statement
⌨️ (0:39:44) 2.4 Getting Execution Statistics for a SQL Statement
⌨️ (0:45:29) 2.5 Improving Statement Performance by Adding an Index
⌨️ (0:52:11) 2.6 Rewriting SQL Statements for Improved Performance
⌨️ (0:58:32) 2.7 Common Execution Plan Operations
⌨️ (1:03:50) 2.8 Summary

Building Indexes
⌨️ (1:07:30) 3.1 Introduction
⌨️ (1:09:09) 3.2 Index Terminology Refresher
⌨️ (1:12:11) 3.3 What Should I Index in My Database?
⌨️ (1:16:16) 3.4 Why Index Column Order Matters
⌨️ (1:23:39) 3.5 Index Selectivity Explained
⌨️ (1:36:23) 3.6 LIKE Clauses and Index Selectivity
⌨️ (1:40:27) 3.7 How Functions in the WHERE Clause Affect Indexes
⌨️ (1:46:10) 3.8 Include Columns and Covering Indexes
⌨️ (1:50:40) 3.9 Over-indexing
⌨️ (1:54:40) 3.10 Interpreting SQL Server Index Recommendations
⌨️ (1:57:38) 3.11 Summary

Finding Bottlenecks in SQL Server Performance
⌨️ (2:03:19) 4.1 Introduction
⌨️ (2:08:36) 4.2 Getting Information About SQL Server Sessions and Resource Usage
⌨️ (2:12:02) 4.3 Finding What SQL Statements are Currently Executing
⌨️ (2:18:47) 4.4 Finding the Slowest, Most Expensive SQL Statements
⌨️ (2:24:13) 4.5 Getting SQL Server's Recommendations on Missing Indexes
⌨️ (2:29:38) 4.6 Finding Indexes That are Not Being Used
⌨️ (2:34:13) 4.7 Summary

Capturing Trace Logs of Application from SQL Server
⌨️ (2:35:55) 5.1 Introduction
⌨️ (2:42:03) 5.2 Setting up a SQL Profiler Trace
⌨️ (2:49:59) 5.3 Running a SQL Profiler Trace
⌨️ (2:55:22) 5.4 Running a Trace as a Server Side Trace
⌨️ (3:03:19) 5.5 Introduction to Using Extended Events for SQL Tracing
⌨️ (3:06:58) 5.6 Setting up an Extended Events Trace Session
⌨️ (3:16:50) 5.7 Running and Configuring the Display Settings for an Extended Events Trace
⌨️ (3:20:38) 5.8 Analyzing Extended Events Trace Data
⌨️ (3:27:10) 5.9 Using Extended Events in SQL Azure
⌨️ (3:31:36) 5.10 Summary

Apply Common Practices for Better Performance
⌨️ (3:35:47) 6.1 Introduction
⌨️ (3:37:17) 6.2 Use Parameterized SQL
⌨️ (3:42:59) 6.3 Are Stored Procedures Faster Than SQL in Application Code?
⌨️ (3:43:04) 6.4 Commit Behavior and Performance
⌨️ (3:50:16) 6.5 Object Relational Mappers Just Generate SQL
⌨️ (3:53:19) 6.6 Solving the N+1 Selects Problem
⌨️ (3:59:56) 6.7 Summary

🎉 Thanks to our Champion and Sponsor supporters:
👾 Raymond Odero
👾 Agustín Kussrow
👾 aldo ferretti
👾 Otis Morgan
👾 DeezMaster

--

[ICodeMechanic]

Hey! this is Rajan Arora. Thank you so much Beau for posting my tutorial. I hope this will help all the viewers to tune their SQL Statements in MS SQL Server. I hope we have more collaboration like this in the future!

[mjKeszely]

Exactly what I need. Thank you, Mr. Rajan and FCC team.

[rajendrawarrier]

Very elegant presentation with crisp and clear explanations. Thank you for the amazing effort. This helped me immensely and so would it have been for several others there I bet!

[anandvardhan]

This is wonderful course. I have been waiting to learn these techniques. Thank you so much for making it.

[TheFunVampire]

Outstanding video and resource, thank you so much for making this!

[Norman_Fleming]

As someone that has been writing code for 40 years I totally agree with your initial premise. If you are writing the SQL you need to understand how it operates and the costs/tradeoffs you may be making. Your video content was very well organized and presented.

[chrisgalvez]

I'm glad have found this jewel. Thank you very much.

[noddychoi]

This tutorial is absolutely great and helpful
Hope to see another vid about MySQL and Postgre !!

[shubhamkhinchi]

Thank you so much Rajan for what i exactly looking for .
💯

[rogeriocastellano]

Congratulations, very comprehensive course.

[north-eastblue]

Thank you so much for this course, exactly what I needed.🤩

[universecode]

I am a self-taught developer 😍 who after years of Js and React, and on my YouTube channel 🧑🏻‍💻 I create projects with React and tailwind or Html and Css… right now I’m learning Python and as you well know, SQL is part of his world. This video comes at the right time 😎

[ArunKumar-txre]

Wow great.this is what I was expecting.thank you so much

[NK-xwuu]

At 1:59:11, you have shown an index as lastname, firstname, degreeid. Will the 3rd sql query be able to utilize this index for degreeid?

[Ptoraskar]

Thank you so much for very imp this and if you have any more like this then please upload it.

[zusm]

I coincidentally just started my database course yesterday

[shivaganga]

Awesome Rajan ji it is a great one very easy explanation

[rubeenaparakkal]

Hi..very useful video..Is there any training available for SQL performance tuning in dba or architect level?

[michelchaghoury]

Great tutorial we need more SQL Server tutorials, please in the future make a SQL Server DBA, SSIS, SSRS tuts thank you

[yasumo]

I executed the same query as the section 2.6 at (0:52:30) and got a different result that was an empty table. I wonder why ce.CourseOfferingId is specified as NULL. It supposes to have a not-null constraints. Would you please teach me?