Maintaining a Microsoft SQL Server 2005 Database (MS2780)
Overview
This five-day instructor-led course provides students with the knowledge and skills 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 who want to become skilled on SQL Server 2005 product features and technologies for maintaining a database.
Prerequisites
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.
In addition, it is recommended, but not required, that students have completed:
- MS50027: Querying and Processing SQL Server 2005 Data with SQL Statements
- MS2779: Implementing a Microsoft SQL Server 2005 Database
Objectives
Upon completion users will be able to:
- Install and configure SQL Server 2005.
- Manage database files.
- Backup and restore databases.
- Manage security.
- Monitor SQL Server.
- Transfer data into and out of SQL Server.
- Automate administrative tasks.
- Replicate data between SQL Server instances.
- Maintain high availability.
Duration
5 days.
Course Content
Module 1
- Installing and Configuring SQL Server 2005
Module 2
- Managing Databases and Files
Module 3
- Disaster Recovery
Module 4
- Managing Security
Module 5
- Monitoring SQL Server
Module 6
- Transferring Data
Module 7
- Automating Administrative Tasks
Module 8
- Implementing Replication
Module 9
- Maintaining High Availability