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).
Full class recordings will be made available to the trainees (On-Demand Streaming). Lifetime access.
Trainees 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.
Regular (Nov 1 to Nov 30): USD $499 (18% Taxes & 5% Payment Gateway Fee extra). (Download Reminder) Last-Minute (Dec 1 to Dec 4): USD $549 (18% Taxes & 5% Payment Gateway Fee extra).
* Prices are subject to change without prior notice
A 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.
Advanced to Expert (Level 300 to 400)
At least two years of genuine working experience with SQL Server
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
Registrants will receive a course completion certificate upon the conclusion of the class.
Module 1: SQL Server Architecture, Scheduling & Waits
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
Identifying, troubleshooting & tuning workload patterns that cause excessive Tempdb usage
Module 4: SQL Server I/O Internals & Tuning
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
Troubleshooting Blocking Scenarios
Module 7: Query Execution and Query Plan Analysis
Query Execution and Optimizer Internals
Analyzing Query Plans
Module 8: Statistics and Index Internals
Cardinality Estimation 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
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
Amit 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