| |
|
| |
Updating Your Database Administration Skills to Microsoft SQL Server 2005 Training Class
Course ID: 5726
|
|
| |
|
|
| |
|
|
| |
Updating Your Database Administration Skills to Microsoft SQL Server 2005 Training Seminar
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.
At Course Completion:
After completing this course, students will be able to: - Describe the architecture of SQL Server 2005. - Install SQL Server 2005. - Use SQL Server 2005 administrative tools and utilities. - Maintain SQL Server 2005 servers and databases. - Secure a SQL Server 2005 server and database. - Monitor SQL Server 2005. - Implement a Backup and Restore solution for SQL Server 2005. - Implement a data availability solution with database mirroring or clustering. - Use enhanced SQL Server 2005 replication features.
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
Agenda |
|
| |
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 Management Studio
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 Metadata Views
|
Lesson 5: Maintaining Databases and Indexes
Managing Indexes
Using the Database Tuning Advisor
|
|
Lesson 6: Securing SQL Server 2005
SQL Server 2005 Security Overview
Managing SQL Server 2005 Security
Managing Permissions
Managing Certificates
|
Lesson 7: Disaster Recovery
Disaster Recovery in SQL Server 2005
Using Database Snapshots
Backup and Restore Operations
|
Lesson 8: Data Availability in SQL Server 2005
Introduction to Data Availability
Introduction to Database Mirroring
Configuring Database Mirroring
|
Lesson 9: SQL Server 2005 Replication
Overview of Replication Enhancements
New Types of Replication
Configuring Replication
|
|
|
|
| Top |
|
|
|
| |
|
|
|
| |
|
|
| |
Pre-requisites |
|
| |
MCDBA certification or equivalent knowledge
Administration experience with Microsoft SQL Server 2000 or Microsoft SQL Server 7.0
2072 Administering a Microsoft SQL Server 2000 Database
|
|
|
|
| |
|
|
|
|
| |
|
|
| |
|
|
|
| |
| |
|
|
| |
Updating Your Database Administration Skills to Microsoft SQL Server 2005 Training Course Dates and Locations
|
|
| |
|
|
| |
Course ID: 5726
| Course Duration: 3 Days
|
|
| |
|
|
| |
Locations: |
|
| |
|
|
| |
|
|
| |
|
|
| |
| Start Date |
Price |
|
Location/Event Details |
Register Online |
Request
More Info |
|
Print/Fax
Register |
|
|
| |
|
|
| |
|
|
|
|
| |
|
|
|
| |
|
|
| |
|
|
| |
Select a market segment to view more courses
|
|
| |
|
|
| |
Or, select a category to view more Information Technology courses
|
|
| |
|
|
| |
 Browse By Category
Browse By Location
Browse New Courses
|
|
| |
|
|
|
| |
| |
|
|
|
|