|
 |
|
Gain the knowledge and skills to support, configure and maintain enterprise SQL Server 2005 databases and servers.
- Overview of SQL Server 2005 Architecture
- Install SQL Server 2005
- Use SQL Server 2005 Administrative Tools
- Monitor SQL Server 2005
- Maintain Databases and Indexes
- Secure SQL Server 2005
- Disaster Recovery
- Data Availability
- Perform Replication
|
|
|
 |
|
Experienced database administrators and database developers who are responsible for the supporting, configuring, and maintaining enterprise SQL Server 2005 databases and servers. |
|
|
 |
|
2072 Administering a Microsoft SQL Server 2000 Database |
|
 |
|
- Describe the architecture of SQL Server 2005
Install SQL Server 2005
- Use SQL Server 2005 administrative tools and utilities
- Maintain SQL Server 2005 server and databases
- Secure a SQL Sever 2005 sever 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
|
|
| |
|
- Each student will receive a copy of the Microsoft course manual for post-class reference and review.
|
|
| |