Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Pluralsight

SQL Server Performance: Introduction to Query Tuning

via Pluralsight

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.

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

Reviews

3.9 rating at Pluralsight based on 551 ratings

Start your review of SQL Server Performance: Introduction to Query Tuning

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.