SQL Server Performance Tuning Video Course (Master Track)

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 50-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.

Please note that from the website here, you can only make an individual subscription. For team/corporate subscription (for a group of people), please Click Here.
Read Terms of Use
.

Instructor: Amit R S Bansal

Total Duration: 50 hours

Level: Advanced to Expert (Level 300 to 400)

Delivery Format: Video Course. Stream anywhere, anytime, any device, as many times.

Release Date: April 2022.

Pre-Requisite: You need to have at least two years of genuine SQL Server experience to gain maximum from this course

Pricing, Discounts & Bundles

Regular Price: $1499 USD (Yearly Subscription)

Discounted Price: $749USD (Yearly Subscription | Limited Period Offer)

Show Your Interest

Corporate Licensing

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

Important Links

FAQs

Click Here

Corporate Subscription

Click Here

Watch Samples

Click Here

Testimonials (Across The Globe)

Click Here

Corporate Feedback

Click Here

LinkedIn Recommendations

Click Here

About Amit Bansal

Click Here

Amit Bansal’s Profile

Click Here

Why Amit Bansal?

Click Here

Why Video Course

Click Here

Terms of Use

Click Here

 

Social Media Links, Our Forums & Free Learning Resources

Free Videos

Click Here

Twitter

Click Here

LinkedIn Page

Click Here

LinkedIn Group

Click Here

Facebook Page

Click Here

Telegram Forum

Click Here

 

Other Learning Solutions

Hands-On-Labs Learning Solution

Click Here

More Video Courses

Click Here

Learning Kits

Click Here

Electronic Books (PDFs)

Click Here

 

More Testimonials

T-SQL Querying Video Course

Microsoft made a beautiful illustration of Amit Bansal’s original pic. Thanks Microsoft for all the encouragement.

 

Show Your Interest

Corporate Licensing