Levi, Ray & Shoup, Inc.
  • Courses
  • Site Content

MS-6317 - Upgrading Your SQL Server 2000 Database Administration (DBA) Skills to SQL Server 2008 DBA Skills

This three-day instructor-led course provides students with the knowledge and skills to upgrade their SQL Server 2000 database administration (DBA) skills to SQL Server 2008 DBA skills. Please note that there is no certification exam related to this course.

Click here to print this page »


Before attending this course, students must have experience developing or administering SQL Server 2000 databases.

Detailed Class Syllabus

Module 1: An Introduction to SQL Server 2008

Lesson 1: The Evolution of SQL Server
Lesson 2: SQL Server 2008 Architectural Components

Module 2: Installing and Upgrading to SQL Server 2008

Lesson 1: Preparing for SQL Server 2008 Installation
Lesson 2: Installing SQL Server 2008
Lesson 3: Upgrading a SQL Server 2000 Instance
Lesson 4: Configuring a SQL Server Installation
Lesson 5: Using SQL Server Configuration Manager

Module 3: Storage Enhancements in SQL Server 2008

Lesson 1: Data Type Enhancements
Lesson 2: Table Partitioning
Lesson 3: Indexing Enhancements
Lesson 4: Tuning Indexes (Optional)

Module 4: SQL Server 2008 Administration Enhancements

Lesson 1: Administration Tools Overview
Lesson 2: Using SQL Server Management Studio
Lesson 3: Using the sqlcmd Utility
Lesson 4: Using Windows PowerShell

Module 5: Security Enhancements with SQL Server 2008

Lesson 1: SQL Server 2008 Security Overview
Lesson 2: Managing SQL Server 2008 Security
Lesson 3: Managing Permissions
Lesson 4: Managing Keys and Certificates
Lesson 5: Data Encryption

Module 6: SQL Server 2008 Disaster Recovery

Lesson 1: Database Backup
Lesson 2: Backup Compression
Lesson 3: Database Restoration
Lesson 4: Database Snapshots

Module 7: High Availability in SQL Server 2008

Lesson 1: Log Shipping
Lesson 2: Database Mirroring
Lesson 3: Determining the Best High Availability Solution

Module 8: Replication Enhancements in SQL Server 2008

Lesson 1: New Types of Replication
Lesson 2: Additional Replication Enhancements

Module 9: SQL Server 2008 Policy-Based Management

Lesson 1: Understanding Central Management Servers
Lesson 2: Understanding Policy-Based Management
Lesson 3: Implementing Policy-Based Management

Module 10: SQL Server 2008 Monitoring Enhancements

Lesson 1: Monitoring a Database
Lesson 2: Using DDL Triggers
Lesson 3: Auditing in SQL Server
Lesson 4: Event Notifications
Lesson 5: Using Static and Dynamic Metadata

Module 11: SQL Server 2008 Performance

Lesson 1: Managing Workloads with Resource Governor
Lesson 2: Monitoring Performance with the Data Collector
Lesson 3: Managing Performance with Plan Freezing