SQL Server Performance Tuning Master Class (Online)

SQL Server Performance Tuning Master Class (Online)SQLMaestros Admin2020-08-25T17:16:19+05:30

Practical SQL Server Troubleshooting & Performance Tuning (Online)

This Master Class will be delivered by Amit Bansal

Friendly Title	SQL Server Performance Tuning
Class Title	Practical SQL Server Troubleshooting & Performance Tuning
Trainer	Amit Bansal (India)
Brochure	Download
Delivery Type	Online
Delivery Format	Total 8 hours Two consecutive days 5 hours each day with one-hour break in between
Date	March 12 & 13, 2019
Time	IST: 10.00 AM – 3.00 PM (Break from 12 PM to 1 PM) UTC: 4.30 AM – 9.30 AM (Break from 6.30 AM to 7.30 AM) PST: 9.30 PM – 2.30 AM (Break from 11.30 PM to 12.30 AM) ACT: 3.00 PM – 8.00 PM (Break from 5 PM to 6 PM)
Price	Regular Price: $190 USD / INR 13300 Discounted Price: $147 / INR 10300 (Limited Seats. Limited Period Offer) * Conversion rate of INR 70 per USD has been taken into consideration * For Indian Credit Cards, 18% GST will be charged extra * Group discounts available
Level	Intermediate
Pre-requisites	At least two years of genuine working experience with SQL Server
Key Highlights	Practical SQL Server Performance Troubleshooting & Tuning Pre-Con is designed for the working SQL Server professionals, Developers, Database Administrators & Architects who have relevant experience with SQL Server and only needs practical examples of performance troubleshooting & tuning that can be applied in applications & production right away. In this full-day training, participants will see relevant, crisp, real-world examples of tuning SQL Server performance.
Takeaways	Practical, Real-World Examples All Demo Scripts Loads of learning that can be applied into production right-away
Course Outline	Module 1: SQL Server Wait Types & Statistics Query Lifecycle Connections -> Sessions -> Requests -> Tasks -> Workers -> Threads Common Wait Types in SQL Server, identification & diagnosis Module 2: The Holy Trinity – CPU, Memory, IO Identifying, troubleshooting & tuning workload patterns that cause excessive CPU Identifying, troubleshooting & tuning workload patterns that cause excessive Memory Usage Identifying, troubleshooting & tuning workload patterns that cause excessive IO Module 3: Query Execution & Query Plan Analysis Statistics & Cardinality Estimation Reading & Analysing Execution Plans Important Iterators Module 4: Query Tuning Rewriting Transact-SQL Optimizing Stored Procedures Solving Parameter Sniffing Issues Parametrization Best Practices Tips with Procedural Code Module 5: Index Tuning Demystifying Common Myths with Indexes Indexing Strategies Index Fragmentation Real-World Index Tuning Examples Module 6: Dealing with Deadlocks SQL Server Concurrency, Isolation Levels, Locking Granularity & Hierarchy Common Deadlock Types Deadlock Best Practices Practical Deadlock Troubleshooting & Diagnosis `
Demos	Complete 8-hr content is demo packed
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 (India), 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 www.youtube.com/SQLMaestros. To learn more about Amit, visit https://sqlmaestros.com/amit-bansal/.
SQLMaestros Contact Details	Email: Classes@SQLMaestros.com Phone: +91 9606482131 / +91 9606482133 Skype: Classes@SQLMaestros.com

Important Links :

Home page	https://sqlmaestros.com/
SQLMaestros Master Classes	https://sqlmaestros.com/sql-server-classes-india/
Video Courses	https://sqlmaestros.com/sql-server-videos-courses/
Learning Kits	https://sqlmaestros.com/sql-server-courseware/
SQL Server Health Check Service	https://sqlmaestros.com/sql-server-health-check/
Hands-On-Labs	http://hols.sqlmaestros.com/
Testimonials	https://sqlmaestros.com/sql-server-master-class-feedback-testimonials/
FAQ	https://sqlmaestros.com/faqs/

Please feel free to contact us if you need any further information
Email: Classes@SQLMaestros.com
Phone: +91 9606482131 / +91 9606482133
Skype: Classes@SQLMaestros.com