SQL Server Internals, Troubleshooting & Performance Tuning Master Class

Description

Friendly Title	SQL Server Performance Tuning
Class Title	SQL Server Internals, Troubleshooting & Performance Tuning
Trainer	Amit Bansal (India)
Delivery Format	Total 40 hours. 4 hours each day. Monday to Friday. Two consecutive weeks.
Date	14 June to 18 June 2021 21 June to 25 June 2021
Time	10.30 am to 2.30 pm (Eastern Time US). View in your own time zone
Price	USD 1499 until March 31, 2021 USD 1699 (April 1 to April 30, 2021) USD 1899 (May 1 to May 31,) USD 2099 (June 1 to June 14, 2021) * Group discounts available (write to classes@SQLMaestros.com) * Prices are subject to change without prior notice
Level	Advanced to Expert (Level 300 to 400)
Pre-requisites	At least two years of genuine working experience with SQL Server
Key Highlights	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).
Course Outline	Module 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 Bio	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.

 

FEE : $ 1499

Registration : sql-server-internals-troubleshooting-performance-tuning-master-class