Home Remote DBA Service Consulting and Performance Server Health Checks Training Resources Calendar Past Customers What our Students say About SQLskills.com		SQLskills Free Online MCM Training Overview SQLskills.com has teamed up with Microsoft 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. 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! If you want to download all the videos using PowerShell, check out this cool script by Aaron Nelson here. Immersion Event on Internals and 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 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 Immersion Event on HA+DR 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) 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 Become a SQLskills Insider for lots of exclusive content and we'll send you a sticker! "A lot of great material! As a newbie, there is a lot of stuff I can use immediately, and also a lot for future consideration. Really gave me a good understanding of some of the internals and a new way to look at our systems." Tim Magney Quick Links Paul’s Blog Kimberly’s Blog Jonathan’s Blog Joe’s Blog Bob's Blog Follow us on Twitter! Immersion Events Schedule
Privacy Policy. All Rights Reserved. Copyright 2011 SQLskills.com