via YouTube Free video
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.
💻 Code, links, Dynamic Views(DMVs), and Database Backups: https://github.com/iCodeMechanic/Essentials-of-Sql-Server-Performance-for-Every-Developer
✏️ Course from Rajan Arora. Check out his channel: https://www.youtube.com/c/ICodeMechanic
❤️ Try interactive Databases courses we love, right in your browser: https://scrimba.com/freeCodeCamp-Databases (Made possible by a grant from our friends at Scrimba)
⭐️ 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
--
Learn to code for free and get a developer job: https://www.freecodecamp.org
Read hundreds of articles on programming: https://freecodecamp.org/news
Some points apply to every course of this kind; see how we rank.
freeCodeCamp is in Tier 3: good universities, respected companies, nonprofits and well-known teachers of our institution ranking (78/100). Free full courses and certifications; practical, but not university-level depth.
Instructor: Prof. Gary Gensler View the complete course: https://ocw.mit.edu/15-S12F18 This course is for students wishing to explore blockchain technology’s potential use - by entrepreneurs & incumbents - to change the world of money and finance. License: Creative Commons BY-NC-SA More information…
This course provides an introduction to mathematical modeling of computational problems. It covers the common algorithms, algorithmic paradigms, and data structures used to solve these problems. The course emphasizes the relationship between algorithms and programming, and introduces basic performa…
This is CS50P, CS50's Introduction to Programming with Python. Register for free at https://cs50.edx.org/python. Slides and source code at https://cs50.harvard.edu/python. Playlist at https://www.youtube.com/playlist?list=PLhQjrBD2T3817j24-GogXmWqO5Q5vYy0V. An introduction to programming using a la…
This is CS50, Harvard University's introduction to the intellectual enterprises of computer science and the art of programming, for concentrators and non-concentrators alike, with or without prior programming experience. (Two thirds of CS50 students have never taken CS before.) This course teaches…
Instructor: Ana Bell View the complete course: https://ocw.mit.edu/courses/6-100l-introduction-to-cs-and-programming-using-python-fall-2022/ *Note: Lectures 6, 10 have been updated! This subject is aimed at students with little to no programming experience. It aims to provide students with an under…
Get more information about the courses and programs we offer. In this playlist you can learn more about course content, pricing, credentials and more!
