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.

The four weeks of intensive training that SQLskills.com provides has a little overlap with the content in the videos, but most material in the class is not available anywhere online. These videos also server as good preparation for taking our classes.

This page gives links to all the videos, grouped together to match our training classes. Make sure to also check out the MCM Pre-Reading List that accompanies the videos, and our much deeper online training.

---

IE1: IMMERSION EVENT ON INTERNALS AND DESIGNING FOR PERFORMANCE

• Database Structures

• Database Structures – Demo

• New Database Structures in SQL Server 2008

• New Database Structures in SQL Server 2008 – Demo

• Data File Internals and Maintenance

• Data File Internals and Maintenance – Demo

• Log File Internals and Maintenance

• Log File Internals and Maintenance – Demo

• Index Internals

• Index Internals – Demo

• The Clustered Index Debate

• Locking

• Locking – Demo

• Statistics

• Snapshot Isolation

• Partitioning

• Indexing Strategies

• Indexing Strategies – Demo

• Index Analysis

• Sparse Columns

• Sparse Columns – Demo

• Index Fragmentation

• Index Fragmentation – Demo

---

IE2: IMMERSION EVENT ON PERFORMANCE TUNING

• Storage Core Concepts

• Storage Guidelines

• DAS vs SAN Architecture

• Storage Testing and Monitoring

• Baselining and Benchmarking

• SQLOS

• Waits and Queues

• Waits and Queues – Demo

• Extended Events

• Extended Events – Demo

• Resource Governor

• Resource Governor – Demo

• Policy-Based Management

• Policy-Based Management – Demo

• Multi-Server Management

• Multi-Server Management – Demo

---

IE3: IMMERSION EVENT ON HIGH AVAILABILITY AND DISASTER RECOVERY

• Designing an Availability Strategy

• Backup Internals

• Backup Internals – Demo

• Restore Internals

• Restore Internals – Demo

• Partial Database Availability and Online Piecemeal Restore

• Virtualization

• Consolidation

• Replication

• Replication – Demo

• Database Mirroring

• Database Mirroring – Demo

• Clustering Introduction

• Clustering Setup and Troubleshooting

• Database Snapshots

• Database Snapshots – Demo

• Consistency Checking (Part 1)

• Consistency Checking (Part 2)

---

IE4: IMMERSION EVENT ON SECURITY AND DEVELOPMENT SUPPORT

• 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