SQL Server Performance: Introduction to Query Tuning
Offered By: Pluralsight
Course Description
Overview
A systematic approach to planning, analyzing, debugging and troubleshooting common query-related problems.
SQL Server performance tuning is an in-depth topic, and an art to master. A key component of overall application performance tuning is query tuning. Writing queries in an efficient manner, and making sure they execute in the most optimal way possible, is always a challenge. The basics revolve around the details of how SQL Server carries out query execution, so the optimizations explored in this course follow along the same lines.
SQL Server performance tuning is an in-depth topic, and an art to master. A key component of overall application performance tuning is query tuning. Writing queries in an efficient manner, and making sure they execute in the most optimal way possible, is always a challenge. The basics revolve around the details of how SQL Server carries out query execution, so the optimizations explored in this course follow along the same lines.
Syllabus
- Introduction 10mins
- Execution Plan Basics 45mins
- Essential Indexing Techniques 20mins
- Query Design for Performance 50mins
- Performance Tuning Tools 75mins
- Tips and Tricks 25mins
- Checklist: Performance Tuning 7mins
Taught by
Vinod Kumar
Related Courses
Learning SQL Server Development on LinuxLinkedIn Learning Master SQL Development
LinkedIn Learning Mastering SQL using Postgresql
Udemy Master SQL Development
LinkedIn Learning Azure Cosmos DB - How to Design and Implement for SQL API
Microsoft via YouTube