Kursbeschreibung: MOC 2733B

Updating Your Database Administration Skills to SQL Server 2005 (5 Tage)

Lernziele:

• Describe the architecture of SQL Server 2005
• Install SQL Server 2005
• Use SQL Server 2005 administrative tools and utilities
• Monitor SQL Server 2005
• Maintain SQL Server 2005 databases
• Secure SQL Server 2005 databases
• Implement a backup and restore solution for SQL Server 2005
• Implement a data availability solution using database mirroring
• Use enhanced SQL Server 2005 replication features

Dauer:

5 Tage

Zielgruppe:

Database administrators and database developers who are responsible for the support, configuration, and maintenance of enterprise SQL Server 2005 databases and servers.

Voraus-setzungen:

• Architecture
• Installation and configuration
• Security
• Data recovery - backup and restore
• Data availability - log shipping and clustering
• Job automation
• Monitoring
• Troubleshooting

Inhalte:

Module 1: Overview of SQL Server 2005 Architecture

• Overview of SQL Server 2005
• System Enhancements for Administrators

Module 2: Installing SQL Server 2005

• Preparing to Install SQL Server 2005
• Performing a SQL Server 2005 Installation
• Maintaining a SQL Server 2005 Installation

Module 3: SQL Server 2005 Administrative Tools

• Using SQL Server Management Studio
• Using SQL Computer Manager
• Using the sqlcmd Utility
• Using the SQL Management Objects

Module 4: Monitoring SQL Server 2005

• Using SQL Profiler
• Using DDL Triggers
• Using Event Notifications
• Using Metadata Views

Module 5: Maintaining Databases and Indexes

• Managing Indexes
• Using the Database Tuning Advisor

Module 6: Securing SQL Server 2005

• SQL Server 2005 Security Architecture
• Managing SQL Server 2005 Security
• Managing Permissions
• Managing Certificates

Module 7: Disaster Recovery

• Disaster Recovery in SQL Server 2005
• Using Database Snapshots
• Backup and Restore Operations

Module 8: Data Availability in SQL Server 2005

• Introduction to Data Availability
• Introduction to Database Mirroring
• Configuring Database Mirroring

Module 9: SQL Server 2005 Replication

• Overview of Replication Enhancements
• New Types of Replication
• Configuring Replication

Dieses Seminar bezog sich im Original auf eine Beta-Version von SQL Server 2005 und wird von Microsoft nicht mehr abgeboten. Es wurde von uns speziell angepasst, so daß im Seminar die aktuelle Version verwendet werden kann.
Die Schulungsunterlagen sind nur als Kopien verfügbar.