Independent Modules from 'SQL Server Performance Tuning – Fast Track' Video Course - SQL Server Training, SQL Server Video Courses, SQL Server Learning Kits, Online Classes, Hands On Labs

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 (Lifetime Access)

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

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 (Lifetime Access)

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

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 (Lifetime Access)

A Classic Example
CPU Troubleshooting
Memory Troubleshooting
IO Troubleshooting
Tempdb Troubleshooting
Demos
Summary

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 (Lifetime Access)

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

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 (Lifetime Accessn)

Indexing Architecture
Index Fragmentation
Indexing Guidelines
Index Tuning
Identifying Missing Indexes
Identifying Unused Indexes
Demos
Summary

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(Lifetime Access)

Data Modification & Concurrency Architecture
Isolation Levels
Troubleshooting Blocking
Best Practices
Troubleshooting Deadlocks
Best Practices
Demos
Summary

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

More Testimonials

T-SQL Querying Video Course

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

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