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 are designed to give you an overview of the breadth of subject knowledge required, plus some indication of the depth to which you should know it.

These videos are high-level and some are quite dated. These are being replaced with our comprehensive online training courses (offered through Pluralsight) so we encourage you to check these out.

For a deeper and richer learning experience, we provide more than 5 weeks of very popular, in-person training.

Immersion Event details and curricula

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

The remainder of this page gives links to all the videos, grouped together to match our IEPTO1 – IEHADR classes. Make sure to also check out the MCM Pre-Reading List that accompanies the videos.


IEPTO1: IMMERSION EVENT ON PERFORMANCE TUNING AND OPTIMIZATION – PART 1

All available from this page on TechNet.

  • Database Structures (+demo)
  • New Database Structures in SQL Server 2008 (+demo)
  • Data File Internals and Maintenance (+demo)
  • Log File Internals and Maintenance (+demo)
  • Index Internals (+demo)
  • The Clustered Index Debate
  • Locking (+demo)
  • Statistics (+demo)
  • Snapshot Isolation
  • Partitioning
  • Indexing Strategies (+demo)
  • Index Analysis
  • Sparse Columns (+demo)
  • Index Fragmentation (+demo)

IEPTO2: IMMERSION EVENT ON PERFORMANCE TUNING AND OPTIMIZATION – PART 2

All available from this page on TechNet.

  • Storage Core Concepts
  • Storage Guidelines
  • DAS vs SAN Architecture
  • Storage Testing and Monitoring
  • Baselining and Benchmarking
  • SQLOS
  • Waits and Queues (+demo)
  • Extended Events (+demo)
  • Resource Governor (+demo)

IEHADR: IMMERSION EVENT ON HIGH AVAILABILITY AND DISASTER RECOVERY

All available from this page on TechNet.

  • Designing an Availability Strategy
  • Backup Internals (+demo)
  • Restore Internals (+demo)
  • Partial Database Availability and Online Piecemeal Restore
  • Virtualization
  • Consolidation
  • Database Mirroring (+demo)
  • Clustering Introduction
  • Clustering Setup and Troubleshooting
  • Database Snapshots (+demo)
  • Consistency Checking (Part 1)
  • Consistency Checking (Part 2)

NOT COVERED IN OUR IN-PERSON CLASSES

All available from this page on TechNet.

  • Replication (+demo)
  • Policy-Based Management (+demo)
  • Multi-Server Management (+demo)
  • Optimizing Procedural Code
  • Service Broker
  • SQL Azure
  • SQL Server Clients
  • Change Data Capture, Change Tracking and Integrated Fulltext Search
  • Security: Introduction and Server Setup
  • Security: Authentication and Authorization
  • Security: Keys and Encryption
  • Security: Auditing and Compliance
  • Security: EXECUTE AS and SQL Injection
  • XML
  • SQLCLR
  • SQL Server Spatial