|
|
|
Maintaining a Microsoft
SQL Server 2005 Database
Course 2780: Three days; Instructor-Led
Introduction
This three-day instructor-led course
provides students with product knowledge and skills needed to maintain a
Microsoft SQL Server 2005 database. The course focuses on teaching individuals
how to use SQL Server 2005 product features and tools related to maintaining a
database.
This course is intended for IT Professionals
wanting to become skilled on SQL Server 2005 product features and technologies
for maintaining a database.
After completing this course,
students will be able to:
•
Install and configure SQL Server
2005.
•
Manage database files.
•
Manage security.
•
Perform administrative tasks.
•
Back up databases.
•
Restore databases.
•
Monitor SQL Server.
•
Troubleshoot SQL Server.
•
Transfer data.
•
Maintain high availability.
Before attending this course,
students must have:
•
Basic knowledge of the Microsoft
Windows operating system and its core functionality.
•
Working knowledge of Transact-SQL.
•
Working knowledge of relational
databases.
•
Some experience with database
design.
Course Outline
Module 1: Installing and Configuring
SQL Server 2005
This module explains how to plan for
and install SQL Server 2005, how to manage a SQL Server 2005 installation, and
how to use the SQL Server 2005 administrative tools.
Module 2: Managing Databases and
Files
This module explains how to manage databases and files.
Module 3: Disaster Recovery
This module explains how to plan and
implement a backup and restore strategy.
Module 4: Managing Security
This module explains how to manage
principals, securables, and permissions, and how to
implement cryptography in a SQL Server database.
Module 5: Monitoring SQL Server
This module explains how to monitor
SQL Server performance and activity.
Module 6: Transferring Data
This module explains how to transfer
and transform data.
Module 7: Automating Administrative
Tasks
This module explains how to use the
SQL Server Agent to automate administrative tasks.
Module 8: Maintaining High
Availability
This module explains how to
implement high availability technologies with SQL Server 2005.
Module 9: Introduction to Replication
This module explains considerations
for implementing replication.