Independent Modules from ‘SQL Server Performance Tuning – Fast Track’

We recommend that you opt for the full course, ‘SQL Server Performance Tuning – Fast Track’ Video Course. However, if you wish to subscribe only for some select modules, you may do so from this page. Please note that the modules are directly from the said course. So for any module you choose, you will receive that module (lecture & demos) + Module 0 + Module 7 (just for the sake of completeness and good learning experience).

‘SQL Server Performance Tuning – Fast Track’ Video Course has six modules comprising of close to 50 demos, all from the real-world. For the module you subscribe to, you will get all the demo scripts for that module and PDF version of the content.

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: Depends on the module.

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

Pre-Requisite: You need to have at least one year of genuine SQL Server experience.

Course Outline & Duration Breakup – View Online | Download

Independent Modules that you can subscribe to:

  Module 1: Performance Troubleshooting Methodology

  Total Duration: 82 Mins 7 Secs

  Regular Price: $99 USD (Yearly Subscription)

  Discounted Price: $39 USD (Yearly Subscription)

  • Where Shall I Begin?
  • An Ocean Within An Ocean
  • Installation & Configuration Best Practices
  • Performance Monitoring, Benchmarking & Baselining
  • Developing a Performance Troubleshooting Methodology
  • Tools & Utilities
  • Demos
  • Summary
Subscribe
Start Watching

Corporate Licensing
  Module 2: Wait Statistics

  Total Duration: 2 Hrs 19 Mins 57 Secs

  Regular Price: $149 USD (Yearly Subscription)

  Discounted Price: $69 USD (Yearly Subscription)

  • Query Execution
  • Waiting & Queuing
  • Putting It Together
  • Working With Wait Stats
  • Common Wait Types
  • System Wait Types
  • PAGEIOLATCH Wait Type
  • CXPACKET Wait Type
  • ASYNC_NETWORK_IO Wait Type
  • RESOURCE_SEMAPHORE Wait Type
  • Demos
  • Summary
Subscribe
Start Watching

Corporate Licensing
  Module 3: The Awesome Foursome – CPU, Memory, IO, Tempdb

  Total Duration: 3 Hrs 31 Mins 30 Secs

  Regular Price: $199 USD (Yearly Subscription)

  Discounted Price: $109 USD (Yearly Subscription)

  • A Classic Example
  • CPU Troubleshooting
  • Memory Troubleshooting
  • IO Troubleshooting
  • Tempdb Troubleshooting
  • Demos
  • Summary
Subscribe
Start Watching

Corporate Licensing
  Module 4: Query Tuning

  Total Duration: 3 Hrs 57 Mins 53 Secs

  Regular Price: $199 USD (Yearly Subscription)

  Discounted Price: $109 USD (Yearly Subscription)

  • Understanding Execution Plan
  • Statistics & Cardinality Estimation
  • Query Tuning
    • The Bad Bookmark Lookups
    • Expensive Sorts
    • Implicit Conversion
    • Non-SARGability
    • Stale Statistics
    • Parameter Sniffing
    • Re-Writing T-SQL
  • Query Store (SQL 2016)
  • Automatic Query Tuning (SQL 2017)
  • Intelligent Query Processing (SQL 2017 & 2019)
  • Demos
  • Summary
Subscribe
Start Watching

Corporate Licensing
  Module 5: Index Tuning

  Total Duration: 2 Hrs 18 Mins 49 Secs

  Regular Price: $149 USD (Yearly Subscription)

  Discounted Price: $69 USD (Yearly Subscription)

  • Indexing Architecture
  • Index Fragmentation
  • Indexing Guidelines
  • Index Tuning
  • Identifying Missing Indexes
  • Identifying Unused Indexes
  • Demos
  • Summary
Subscribe
Start Watching

Corporate Licensing
  Module 6: Concurrency Troubleshooting

  Total Duration: 1 Hrs 32 Mins 54 Secs

  Regular Price: $99 USD (Yearly Subscription)

  Discounted Price: $39 USD (INR 3,675) (Yearly Subscription)

  • Data Modification & Concurrency Architecture
  • Isolation Levels
  • Troubleshooting Blocking
  • Best Practices
  • Troubleshooting Deadlocks
  • Best Practices
  • Demos
  • Summary
Subscribe
Start Watching

Corporate Licensing

 

Module 0 & Module 7 will be automatically added to your subscription. You will not see it in the cart, but will see in the course page.

Module 0: Introduction

  • Before You Begin
  • Modules
  • Demo Setup
  • What Not To Expect
  • What To Expect
  • How To Get The Best Out Of This Course

Module 7: Wrap Up

Why ‘SQL Server Performance Tuning – Fast Track’ Video Course

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.