SQL Server Performance Tuning Master Class (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-hours course is designed to give you the right amount of internals knowledge and loads of practical tuning & optimization techniques that you can put into production right-away. As part of the class, all Master Class participants will get a 1-month FREE subscription of SQLMaestros Hands-on-Labs.

This Master Class will be delivered by Amit Bansal, Microsoft Certified Master of SQL Server & 11 times Microsoft’s Most Valuable Professional awardee.

Read Master Class Testimonials

Course Code PI_SQL_101
Course Title SQL Server Internals, Troubleshooting and Performance Tuning
Course Brochure Download   download_img
Delivery Format Online (Instructor-led, synchronous) using GoToMeeting Platform. Learn more about our Online Delivery Model
Date, Time & Duration January 15 to January 19, 2018, 40 hours Master Class comprising of:

  • 5 days of online (instructor-led synchronous) training of 5 hours each
  • 16-20 hours of Hands-on-Labs Exercises (to be practiced anytime/anywhere for 1 month or until the free subscription expires)

During the 5 days of online training, class timings will be 10.30 am to 1.00 pm and 2.00 pm to 4.30 pm IST

List Price
Date Amount
Super Early Bird – Till Oct 31, 2017 INR 39,000
Early Bird – Nov 1 to Dec 3, 2017 INR 43,000
Regular – Dec 4 to Jan 14, 2018 INR 47,000
Note:
    *Taxes: 18% GST extra
    *Prices are subject to change without prior notice
Level Level 300-400 (Advanced to Expert)
Target Audience This course is intended for SQL Server Database Administrators, SQL Database Engineers, SQL Developers & SQL Architects.
Prerequisites This course requires that participants have at least 2 years of genuine experience with Microsoft SQL Server. This course is not meant for Fresher
Trainer/Instructor Amit R S Bansal (SQL MCM, SQL MVP)
Key Highlights:

  • The most advanced SQL Server Performance Tuning Workshop
  • 40 hours of deep-dive learning
  • Exclusive, level 300/400 content
  • Packed with real-world scenarios and examples
  • Get your own copy of SQLMaestros course material developed by Amit Bansal
  • Learn from the Master: Amit Bansal is one of the very few Microsoft Certified Master

Module 1:  SQL Server Architecture, Scheduling and Waits

  • SQL Server Components and SQL OS
  • Windows Scheduling vs SQL
  • Waits and Queues

Module 2:  SQL Server I/O

  • Core Concepts
  • IO Setup and Testing
  • SQL Server IO Patterns

Module 3:  Database Structures

  • Database Structure Internals
  • Data File Internals
  • TempDB Internals

Module 4:  SQL Server Memory

  • Windows Memory
  • SQL Server Memory

Module 5:  Concurrency and Transactions

  • Concurrency and Transactions
  • Locking Internals

Module 6:  Statistics and Index Internals

  • Statistics Internals and Cardinality Estimation
  • Index Internals

Module 7:  Extended Events

  • Extended Events core concepts
  • Implementing Extended Events

Module 8:  Monitoring, Tracing and Baselining

  • Monitoring and Tracing
  • Baselining and Benchmarking

Module 9:  Troubleshooting Common Performance Issues

  • Troubleshooting CPU Performance
  • Troubleshooting Memory Performance
  • Troubleshooting I/O Performance
  • Troubleshooting TempDB Performance
  • Troubleshooting Concurrency Performance

Module 10:  Query Execution and Query Plan Analysis

  • Query Execution and Optimizer Internals
  • Optimizing T-SQL code / Rewriting including Query Hints
  • Analyzing Query Plans

Module 11:  Plan Caching and Recompilation

  • Plan Cache Internals
  • Troubleshooting Plan Cache Issues

Module 12:  Index and Query Tuning

  • Index Fragmentation
  • Indexing Techniques
  • Indexing Strategy
  • Tuning Queries

Module 13:  Resource Governor

  • Concept & Architecture
  • Implementation

Module 14:  Table & Index Partitioning

  • Concept & Architecture
  • Implementation

In The Words Of Amit Bansal

“ Hi, My name is Amit Bansal and I am the instructor for this course. SQL Server is an enterprise level RDBMS server with a very powerful database engine capable of handling toughest of requirements in terms of scalability, availability, extensibility and performance. Many factors impact performance. A solid understanding of SQL Server internals is very critical for anyone who troubleshoots SQL Server performance. This course is designed to give you the right amount of Internals knowledge and loads of practical tuning & optimization techniques that you can put into production right-away.

The 40-hour class offers a comprehensive coverage of SQL Server architecture, indexing and statistics strategies, optimize transaction log operations, tempdb and data file configuration, transactions and isolation levels, and locking and blocking. The course also teaches you how to create baselines and benchmark SQL Server performance, how to analyze your workload and figure out where performance problems are, and how to fix them.

The course has a special focus on SQL Server I/O, CPU usage, memory usage, query plans, statement execution, parameter sniffing and procedural code, deadlocking, plan cache, wait and latch statistics, Extended Events, DMVs and PerfMon. Not to mention, Table/Index Partitioning & Resource Governor is also covered. Throughout the course, you will see dozens of advanced, real-world demos. Note that this 40-hour class is rigorous, deep-dive & very practical oriented. The course is packed with Hands-On-Labs powered by SQLMaestros.com. This course is not version specific and everything you learn can be applied to SQL Server 2005 through SQL Server 2016.” Amit R S Bansal (SQL MCM, SQL MVP)

Note:This 40-hour long training is rigorous and deep-dive! The course is packed with Hands-On-Labs powered by SQLMaestros.com.

This course is not version specific and everything you learn can be applied to SQL Server 2005 through SQL Server 2016.

Please feel free to contact us if you need any further information

Email : classes@sqlmaestros.com
Skype : classes@sqlmaestros.com
Contact: +91-7829999046 / +91-9503124667