SQL Server Performance Tuning Master Class, Online, May 8 to May 19, 2017

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. The course will be taught by Amit Bansal, Microsoft Certified Master of SQL Server

All Master Class participants will get a 6-month FREE subscription to SQLMaestros Hands-on-Labs. Apart from practicing course specific labs, participant’s will have access to the entire library.

Read Master Class Testimonials
Register For Sample Master Class (FREE)

Course Code PI_SQL_101
Course Title SQL Server Internals, Troubleshooting and Performance Tuning
Course Brochure Download   download_img
List Price
(Super Early Bird) till Mar 4, 2017 USD 1,999
(Early Bird) March 5 to April 8, 2017 USD 2,199
(Regular) April 9 to May 8, 2017 USD 2,499
Duration 40 hours
(4 hours per day, 10 working days/2 consecutive weeks)
Date Week 1: May 8-12, 2017
Week 2: May 15-19, 2017
Time Pre-Register with us and let us know your preferred timings. Learn more about our Registration Process
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!
Online Delivery GoToMeeting. Learn more about our Online Delivery Model
Sample Master Class(FREE) Register
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 or Book a call with us now!

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