SQL Server 2005: Upgrading for Experienced DBAs

Course Overview

The purpose of this 4-day instructor-led course is to teach Oracle DBAs how to leverage their skills and experience as an Oracle DBA to manage a SQL Server system. This course provides a quick start for the Oracle DBA to map, compare and contrast the realm of Oracle database management to SQL Server database management.

Audience

This course is intended for experienced database professionals currently implementing and administering non Microsoft enterprise database management systems who need to expand their database skill-set to SQL Server 2005.

Prerequisites

Before attending this course, students must:

• Have thorough experience with SQL Server 2000
• Have experience with SQL Server 2005 and a comprehensive understanding of all the new features and technologies
• The relational engine
• Storage engine
• Integration Services
• Analysis Services
• Reporting Services
• Be familiar with SQL Server 2005 features, tools, and technologies.

Course Outline

• Module 1: Database and Instance
• Module 2: Database Architecture
• Module 3: Instance Architecture
• Module 4: Data Objects
• Module 5: Data Access
• Module 6: Data Protection
• Module 7: Basic Administration
• Module 8: Server Management
• Module 9: Managing Schema Objects
• Module 10: Database Security
• Module 11: Data Transport
• Module 12: Backup and Recovery
• Module 13: Performance Tuning
• Module 14: Scalability and High Availability
• Module 15: Monitoring
• Module 16: Microsoft SQL Server Migration Assistant (SSMA)

SQL Server 2005: Upgrading for Experienced DBAs / MS7033 (M7033, MOC 7033)