SQL Server Query Tuning Fundamentals

Key Concepts Covered in this Course

Klaus Aschenbrenner

Microsoft Certified Master for SQL Server

I work with Microsoft SQL Server for more than 20 years, and I provide with my company SQLpassion consulting and training services around the whole world.

Since 2012 I’m also a Microsoft Certified Master for SQL Server.

Course Description

If you have a database driven application which reacts very slowly when the data increases, then you are right in this webinar! In this live training you will learn how you can tune SQL Server Queries with the information available inside an execution plan. You will see how SQL Server retrieves data from the database files, how SQL Server can join resultsets, and how you can react with indexes if you are in performance troubles.

5/5

Amazing Course

“My day-to-day writing of SQL has gone up a level – I am able to finely tune individual statements or underlying database objects to get the kind of query plan I want. Moreover I know now what sort of plan I am looking for. I have been already able to use this knowledge to address performance issues that came up this week in capacity testing.”

Arun from London, United Kingdom

Course Details

Course Duration

1 Day

Course Price

EUR 590 incl. 20% VAT

Course Level

Intermediate

Agenda & Breakdown

  • How to access your data through Indexes
    • Heap Tables
    • Clustered Index
    • Non-Clustered Index
    • Index Scans
    • Index Seeks
  • Execution Plans
    • Overview
    • Estimated Execution Plan
    • Actual Execution Plan
    • Data Access Operators
    • Join Operators
    • Aggregation Operators
    • Halloween Protection

This one-day long webinar is primarily for DBAs, Developers, and Consultants who want to speed up their SQL Server installations with Indexes. You don’t need to know anything about Indexing, you just need to have a basic understanding how to write T-SQL queries and stored procedures for SQL Server.

Date & Location

October 7, 2021

EUR 590 incl. 20% VAT
Cancellation Fee: 100%
Course Language: English
Location: Online Live Class