Free Online SQL Server MCM / MCSM Training Videos
OVERVIEW
SQLskills.com teamed up with Microsoft in 2010 to provide 40 hours of online training geared towards studying for the SQL Server 2008 MCM certification. These videos were designed to give you an overview of the breadth of subject knowledge required, plus some indication of the depth to which you needed to know it to pass the MCM certification. In September 2013, the MCM program was permanently canceled. In 2017, Microsoft started removing the MCM training videos and gave us permission to host some of them.
The remainder of this page gives links to some MCM videos, grouped together to match our IEPTO1 – IEHADR classes. Please be warned that these videos are not comprehensive and some are really out-of-date and contain information that’s no longer applicable to recent versions. For this reason, where an MCM video is no longer appropriate, a list of applicable Pluralsight courses is also provided.
For a deeper and richer learning experience, we provide very popular, in-person training.
Immersion Event details and curricula
- IE0: Immersion Event for the Junior/Accidental DBA
- IEPTO1: Immersion Event on Performance Tuning and Optimization – Part 1 (formerly IE1)
- IEPTO2: Immersion Event on Performance Tuning and Optimization – Part 2 (formerly IE2)
- IEHADR: Immersion Event on High Availability and Disaster Recovery (formerly IE3)
- IEAzure: Immersion Event on Azure SQL Database and Azure VMs
Schedule of Upcoming Classes
- Click HERE for our scheduled classes for the coming year, along with links to per-class information and registration.
Class Costs and Frequently Asked Questions
- Click HERE for details about class costs, discounts, and other questions
IEPTO1: IMMERSION EVENT ON PERFORMANCE TUNING AND OPTIMIZATION – PART 1
Old MCM videos:
- Database Structures + demo
- Data File Internals and Maintenance + demo
- Index Internals + demo
- The Clustered Index Debate
- Locking + demo
- Statistics
- Snapshot Isolation
- Indexing Strategies + demo
- Index Analysis
- New Database Structures in SQL Server 2008 + demo
Pluralsight courses:
- SQL Server: Index Fragmentation Internals, Analysis, and Solutions
- SQL Server: Logging, Recovery, and the Transaction Log
- SQL Server: Why Physical Database Design Matters
IEPTO2: IMMERSION EVENT ON PERFORMANCE TUNING AND OPTIMIZATION – PART 2
Old MCM videos:
Pluralsight courses:
- SQL Server: Advanced Extended Events
- SQL Server: Benchmarking and Baselining
- SQL Server: Collecting and Analyzing Trace Data
- SQL Server: Common Performance Issue Patterns
- SQL Server: Common Query Tuning Problems and Solutions – Part 1
- SQL Server: Common Query Tuning Problems and Solutions – Part 2
- SQL Server: Deadlock Analysis and Prevention
- SQL Server: Introduction to Extended Events
- SQL Server: Optimizing Ad Hoc Statement Performance
- SQL Server: Optimizing Stored Procedure Performance
- SQL Server: Optimizing Stored Procedure Performance – Part 2
- SQL Server: Performance Troubleshooting Using Wait Statistics
- SQL Server: Query Plan Analysis
- SQL Server: Introduction to Query Store
- SQL Server: Replacing Profiler with Extended Events
- SQL Server: Improving Storage Subsystem Performance
IEHADR: IMMERSION EVENT ON HIGH AVAILABILITY AND DISASTER RECOVERY
Old MCM videos:
- Designing an Availability Strategy
- Backup Internals + demo
- Restore Internals + demo
- Partial Database Availability and Online Piecemeal Restore
- Database Mirroring + demo
- Clustering Introduction
- Clustering Setup and Troubleshooting
- Database Snapshots + demo
Pluralsight courses:
- SQL Server: Detecting and Correcting Database Corruption
- SQL Server: Advanced Corruption Recovery Techniques
- SQL Server: Transactional Replication Fundamentals
- SQL Server: Virtualization
- Understanding Server Hardware
- SQL Server: Consolidation Tactics and Best Practices
NOT COVERED IN OUR IN-PERSON CLASSES or Pluralsight courses
- Policy-Based Management + demo
- Multi-Server Management
- Partitioning
- CDC, Change Tracking, and Fulltext
- SQL Server Clients
- Security: Introduction and Server Setup
- Security: Authentication and Authorization
- Security: Keys and Encryption
- Security: Auditing and Compliance
- Security: EXECUTE AS and SQL Injection
- XML
- Sparse Columns + demo
- SQLCLR
- SQL Server Spatial