Hands On Training

SQL Server Performance: Introduction to Query Tuning

via

Pluralsight

Course Features

Duration

3.92 hours

Delivery Method

Online

Available on

Downloadable Courses

Accessibility

Mobile, Desktop, Laptop

Language

English

Subtitles

English

Level

Intermediate

Effort

3 hours per week

Teaching Type

Self Paced

Video Content

3.92 hours

Course Description

SQL Server performance tuning can be a complex topic and a difficult art. Query tuning is a key component in overall application performance tuning. It is difficult to write queries efficiently and ensure they execute in the best possible way. This course will cover the basics of SQL Server query execution. The optimizations discussed in this course are also based on these details.

Course Overview

International Faculty

Case Based Learning

Post Course Interactions

Case Studies,Hands-On Training,Instructor-Moderated Discussions

Case Studies, Captstone Projects

Skills You Will Gain

What You Will Learn

Essential Indexing Techniques

Execution Plan Basics

Performance Tuning

Performance Tuning Tools

Query Design for Performance

Tips and Tricks

Course Content

Expand all sections

Module 1: Introduction

Module 2: Execution Plan Basics

Module 3: Essential Indexing Techniques

Module 4: Query Design for Performance

Course Instructors

Pinal Dave

Instructor

Pinal Dave is a SQL Server Performance Tuning Expert and an independent consultant. He has authored 11 SQL Server database books, 25 Pluralsight courses and has written over 5000 articles on the data...

Vinod Kumar

Instructor

Vinod Kumar has worked with SQL Server extensively since joining the industry over a decade ago. Before joining Microsoft, he was a Microsoft MVP for SQL Server for more than 3 years. He now works wi...