Microsoft SQL Server 2008 Database Infrastructure and Scalability

Overview

This three-day instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2008 server. The course focuses on teaching individuals how to use SQL Server 2008 product features and tools that differ from those experienced in SQL Server 2005.

This course is intended for IT Professionals who want to become skilled on SQL Server 2008 product features and technologies for maintaining servers.

Prerequisites

Before attending this course, students must have:

• Deep working knowledge of Microsoft SQL Server 2005, using it regularly as a DBA.   Delegates would preferably  hold a MCTS / MCITP Administration qualification in SQL Server 2005 or the equivalent.

Course Outline

• Module 1 : Overview
• Module 2 : Availability Enhancements
• Module 3 : Security Enhancements
• Module 4 : Policy-based Management and Multi-Server Admin
• Module 5 : Resource Management and Troubleshooting
• Module 6 : Features That Need to be Managed, Part 1 (Spatial indexes, Integrated full-text search, Sparse columns, Filtered indexes)
• Module 7 : Features That Need to be Managed, Part 2 (Change tracking , Change Data Capture, Filestream)
• Module 8 : Scalability Enhancements
• Module 9 : Query Optimizer Enhancements
• Module 10 : Performance Data Collection