SQL Server Query Tuning Fundamentals
Key Concepts Covered in this Course
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.
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.
“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
Agenda & Breakdown
- How to access your data through Indexes
- Heap Tables
- Clustered Index
- Non-Clustered Index
- Index Scans
- Index Seeks
- Execution Plans
- 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
May 3, 2022
EUR 590 incl. 20% VAT
Course Language: English
Location: Online Live Class