|
|
|
|
Title: |
2733 Updating Your Database Administration Skills to Microsoft SQL Server 2005 - ML |
|
Delivery Method: |
Mentored Learning |
|
Duration: |
6 Sessions |
|
Overview: |
This course provides students with the knowledge and skills to upgrade their skills to SQL Server 2005 so that they can support, configure, and maintain enterprise SQL Server 2005 databases and servers. |
| Who
Should Attend: |
This course is intended for experienced database administrators and database developers who are responsible for the supporting, configuring, and maintaining enterprise SQL Server 2005 databases and servers. |
| Pre-requisite(s): |
Before attending this course, students must have:
• MCDBA certification or equivalent knowledge.
• Administration experience with Microsoft SQL Server 2000 or Microsoft SQL Server 7.0.
• Knowledge of SQL Server 2000/7.0
• Database and server architecture.
• Installation and configuration.
• Database security.
• Database recovery (backup and restore).
• SQL Server technologies used for database availability such as log shipping and clustering.
• Job automation.
• Database and server monitoring.
• Troubleshooting.
• Replication.
In addition, it is recommended, but not required, that students have completed:
• Course 2072, Administering a Microsoft SQL Server 2000 Database. |
| CPE
Information: |
CPE Credits:
0
hours
Course Level: Basic
Instructional Method: Group-live
Additional CPE Information |
|
Outline: |
Lesson 1: Overview of SQL Server 2005 Architecture
Overview of SQL Server 2005
System Enhancements for Administrators
Lesson 2: Installing SQL Server 2005
Preparing to Install SQL Server 2005
Performing a SQL Server 2005 Installation
Maintaining a SQL Server 2005 Installation
Lesson 3: SQL Server 2005 Administrative Tools
Using SQL Server Workbench
Using SQL Server Computer Manager
Using the sqlcmd Utility
Using the SQL Management Objects
Lesson 4: Monitoring SQL Server 2005
Using SQL Profiler
Using DDL Triggers
Using Event Notifications
Using the System Virtual Tables
Lesson 5: Maintaining Databases and Indexes
Using the Database Maintenance Plan Wizard
Managing Indexes
Using the Database Tuning Advisor
Lesson 6: Securing SQL Server 2005
SQL Server 2005 Security Overview
Managing SQL Server 2005 Security
SQL Agent Security
Lesson 7: Disaster Recovery
Disaster Recovery in SQL Server 2005
Using Database Snapshots
Backup and Restore Operations
Lesson 8: Data Availability
Introduction to Data Availability
Introduction to Database Mirroring
Configuring Database Mirroring
Lesson 9: Replication
Overview of Replication Enhancements
New Types of Replication
Configuring Replication |
|
