Maintaining a Microsoft SQL Server 2005 Databases

2780 : 5 Day Instructor-Led Workshop

Administration of SQL Server databases

This five-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.

Prerequisites:

  • 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:

  • SQL200 Transact-SQL Programming

Audience:
This course is intended for IT Professionals who want to become skilled on SQL Server 2005 product features and technologies for maintaining a database.

Topics covered:

  • Installing and Configuring SQL Server 2005
  • Managing Databases and Files
  • Managing Security
  • Disaster Recovery
  • Monitoring SQL Server
  • Transferring Data
  • Implementing Replication
  • Automating Administrative Tasks
  • Maintaining High Availability

At course completion:
Students will be able to:

  • Install and configure SQL Server 2005
  • Manage database files
  • Backup and restore databases
  • Manage security
  • Monitor SQL Server
  • Transfer data in and out of SQL Server
  • Automate administrative tasks
  • Replicate data between SQL Server instances
  • Maintain high availability

 

Exams:
70-431:TS Microsoft SQL Server 2005 Implementation and Maintenance.