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 »

Prerequisites


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