SQL Server Index Tuning Master Class (Online)

15 hours. 3 hours per day. 5 Days. Mon-Fri. Online.

Welcome to the most comprehensive index internals & tuning training by Amit Bansal, Microsoft Certified Master of SQL Server. The 15-hour program covers the right amount of internals and real-world scenarios that you can apply to production right away. The content will give you a brain-melting experience, it covers the breadth and the depth – every aspect of index tuning in SQL Server. After attending the course, you will be powered with practical index tuning & optimization techniques. Apart from attending live, you get lifetime access to the recordings – watch anytime, anywhere, as many times. Make sure to check out the feedback of our most recent master class.

Friendly TitleIndex Tuning Master Class
Class TitleSQL Server Index Tuning Master Class
TrainerAmit Bansal
Delivery TypeOnline. Read about our online delivery model.
Delivery FormatTotal 15 hours. 3 hours each day. Monday to Friday.
DateApril 8 to 12, 2024 (Monday to Friday)
Time9 am to 1 pm EST | 2 pm to 6 pm GMT | 7.30 pm to 11.30 pm IST
Check your time zone
RecordingsFull class recordings will be made available to the trainees (On-Demand Streaming). Lifetime subscription.
Hands-OnTrainees can practice labs/demos along with the instructor or later, whatever is convenient. Training material will be shared with the participants beforehand.
PriceUSD $299 (until Feb 29)
USD $349 (Mar 1 to Mar 31)
USD $399 (April 1 to April 8)
(18% Taxes & 5% Payment Gateway Fee extra)* Prices are subject to change without prior notice
Cancellation PolicyA full refund will be made in case the Master Class is canceled by SQLMaestros. In case the trainee wishes to cancel their enrollment, 18% (GST Tax) + 5% internet fess will be forfeited and the remaining will be refunded. Refunds will be processed within ten working days.
LevelAdvanced to Expert (Level 300 to 400)
Pre-requisitesAt least two years of genuine working experience with SQL Server
Key Highlights
  • Full Class Recordings will be available for lifetime.
  • Comprehensive &amp Advanced covering most important areas.
  • 15 hours of deep dive learning.
  • True level 300-400 content.
  • Gain real-world knowledge, get real-world exposure.
  • Get your own copy of SQLMaestros course material + Scripts.
  • Packed with real-world demos and examples.
  • Apply your learning into production right away.
  • Course Completion Certificate (Digital).
  • Practice Labs/Demos at your own pace
CertificateRegistrants will receive a course completion certificate upon the conclusion of the class.
Course Outline 

  • Why Indexes? (What are Indexes & How they help?)
  • Indexing Architecture
  • Indexing for AND and OR
  • Indexing for Aggregates
  • Indexing for SORT
  • Indexing for Joins
  • Sargability
  • Multi Column Index Seek
  • Multi-Column Indexes
  • BETWEEN vs IN
  • CRUD Performance
  • Filtered Indexes
  • Indexed Views
  • Avoiding Blocking with Indexes
  • Avoid Deadlocks using Covering Index
  • Missing Index High CPU Usage
  • Primary Key Non-Clustered Index
  • Removing SORT
  • Memory Grant
  • Missing and Unused Indexes
  • Redundant Indexes
  • Clustering Key Choices

Note: Course outline and content is being continuously improvised as we get closer to the class dates.

Trainer’s BioAmit R S Bansal is a SQL Server Specialist at SQLMaestros (brand of eDominer Systems). He leads the SQL and BI practice with a much-focused team providing consulting, training and content development services to more than 160+ SQL customers globally. He frequently speaks at international conferences including Data Platform Summit, MS Ignite (US), SQLBits (UK), PASS Summit (US) & SQL Saturday events across the globe. Amit is also honored with Microsoft Regional Director status, MVP award and Microsoft Certified Master of SQL Server credential. Amit has been working with SQL Server since 1999 and has been part of countless mission critical SQL deployments. Performance Tuning in SQL Server is his core area of expertise. His videos are available on YouTube. To learn more about Amit, Click Here
SQLMaestros Contact Detailsclasses@SQLMaestros.com
FAQClick Here
Testimonials (Dec 2023 Batch)Click Here
General TestimonialsClick Here
FAQClick Here

SQL Server Performance Tuning Master Class (Online)

40 hours. 4 hours per day. 10 Days. Mon-Fri. Online.

Have you ever been to Army-Training? When was the last time you had a brain-melting experience? Welcome to the most rigorous SQL training you ever had. This 40-hour course is designed to give you the right amount of internals and loads of practical tuning & optimization techniques that you can put into production right away. The course will be taught by Amit Bansal, Microsoft Certified Master of SQL Server. Apart from attending LIVE, registrants will get lifetime access to the class recordings (full 40 hours).

Friendly TitleSQL Server Performance Tuning
Class TitleSQL Server Internals, Troubleshooting & Performance Tuning
TrainerAmit Bansal
Delivery TypeOnline. Read about our online delivery model.
Delivery FormatTotal 40 hours. 4 hours each day. Monday to Friday. Two consecutive weeks.
DateNext schedule coming soon. Meanwhile, for a corporate delivery of this class, drop an email to classes@SQLMaestros.com.
TimeNext schedule coming soon. Meanwhile, for a corporate delivery of this class, drop an email to classes@SQLMaestros.com.
RecordingsDec 2023 Batch Class Recordings Available. Click Here.
Hands-OnTrainees can practice labs/demos along with the instructor or later, whatever is convenient. Training material will be shared with the participants closer to the class start date.
PriceFor a corporate delivery of this class, drop an email to classes@SQLMaestros.com.
Cancellation PolicyA full refund will be made in case the Master Class is canceled by SQLMaestros. In case the trainee wishes to cancel their enrollment, 18% (GST Tax) + 5% internet fess will be forfeited and the remaining will be refunded. Refunds will be processed within ten working days.
LevelAdvanced to Expert (Level 300 to 400)
Pre-requisitesAt least two years of genuine working experience with SQL Server
Key Highlights
  • Full Class Recordings will be available for lifetime.
  • Comprehensive & Advanced covering most important areas.
  • 40 hours of deep dive learning.
  • True level 300-400 content.
  • Gain real-world knowledge, get real-world exposure.
  • Get your own copy of SQLMaestros course material + Scripts.
  • Packed with real-world demos and examples.
  • Apply your learning into production right away.
  • Course Completion Certificate (Digital).
  • Practice Labs/Demos at your own pace
CertificateRegistrants will receive a course completion certificate upon the conclusion of the class.
Course OutlineModule 1: SQL Server Architecture, Scheduling & Waits

  • SQL Server Components and SQL OS
  • Waits and Queues
  • Query Lifecycle
  • Connections -> Sessions -> Requests -> Tasks -> Workers -> Threads
  • Common Wait Types in SQL Server, identification & diagnosis

Module 2: CPU Performance Monitoring & Tuning

  • Troubleshooting CPU Performance
  • Identifying, troubleshooting & tuning workload patterns that cause excessive CPU

Module 3: SQL Server Tempdb Internals & Tuning

  • Tempdb Internals
  • Identifying, troubleshooting & tuning workload patterns that cause excessive Tempdb usage

Module 4: SQL Server I/O Internals & Tuning

  • Core Concepts
  • IO Setup and Testing
  • SQL Server IO Patterns
  • Identifying, troubleshooting & tuning workload patterns that cause excessive IO

Module 5: SQL Server Memory Internals & Troubleshooting

  • Windows Memory Internals
  • SQL Server Memory Internals & Troubleshooting
  • Identifying, troubleshooting & tuning workload patterns that cause excessive Memory Usage

Module 6: Concurrency and Transactions

  • Concurrency and Transactions
  • Locking Internals
  • Troubleshooting Blocking Scenarios
  • Troubleshooting Deadlocks

Module 7: Query Execution and Query Plan Analysis

  • Query Execution and Optimizer Internals
  • Analyzing Query Plans

Module 8: Statistics and Index Internals

  • Statistics Internals
  • Cardinality Estimation Internals
  • Index Internals

Module 9: Query Tuning

  • Understanding common patterns & antipatterns
  • Troubleshooting Slow Running Queries
  • Identify Plan Quality Issues
  • Optimizing T-SQL code/Rewriting
  • Optimizing Stored Procedures
  • Real-World Query Tuning Examples

Module 10: Index Tuning

  • Indexing Techniques
  • Indexing Strategies
  • Real World Index Tuning Examples

Module 11: Plan Caching and Recompilation

  • Plan Cache Internals
  • Troubleshooting Plan Cache Issues

Module 12: Extended Events

  • Extended Events core concepts
  • Implementing Extended Events

Module 13: Monitoring, Tracing and Baselining

  • Tools & Techniques
  • Monitoring and Tracing
  • Baselining and Benchmarking

Module 14: SQL Server New Features

  • New Tuning Features in Latest Versions of SQL Server
Trainer’s BioAmit R S Bansal is a SQL Server Specialist at SQLMaestros (brand of eDominer Systems). He leads the SQL and BI practice with a much-focused team providing consulting, training and content development services to more than 160+ SQL customers globally. He frequently speaks at international conferences including Data Platform Summit, MS Ignite (US), SQLBits (UK), PASS Summit (US) & SQL Saturday events across the globe. Amit is also honored with Microsoft Regional Director status, MVP award and Microsoft Certified Master of SQL Server credential. Amit has been working with SQL Server since 1999 and has been part of countless mission critical SQL deployments. Performance Tuning in SQL Server is his core area of expertise. His videos are available on YouTube. To learn more about Amit, Click Here
SQLMaestros Contact Detailsclasses@SQLMaestros.com
FAQClick Here
Testimonials (Dec 2023 Batch)Click Here
General TestimonialsClick Here


Looking for Master Class Recordings? Go here.