Home » Training Courses » Microsoft Certified Training » 2780 - Maintaining a Microsoft SQL Server 2005 Database Training

2780 - Maintaining a Microsoft SQL Server 2005 Database Training

• Book this course
• Email to a friend
• Download PDF

Course code - 2780

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.

Course Objectives:

At the end of this course participants 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.

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

Course Pre-requisites:

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

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:

• Course 2778: Writing Queries Using Microsoft SQL Server 2005 Transact-SQL.
• Course 2779: Implementing a Microsoft SQL Server 2005 Database.

Microsoft Certification Exams:

This course prepares delegates for the 70-431 Microsoft SQL Server 2005 - Implementation and Maintenance exam

When you pass Exam 70-431: TS: Microsoft SQL Server 2005 - Implementation and Maintenance, you complete the requirements for the following certification(s):

• Microsoft Certified Technology Specialist: SQL Server 2005

This exam can also be used as credit towards the following certifications:

• Microsoft Certified Systems Administrator (MCSA) - on Windows Server 2003
• Microsoft Certified Systems Engineer (MCSE) - On Windows Server 2003

 

SQL Server 2005 Database Training Courses Recommended Reading

SQL Server 2005 Database Essentials Step by Step by Solid Quality Learning - buy from amazon

 

For full course content and pre-requisites download the 2780 - Maintaining a Microsoft SQL Server 2005 Database Training Course PDF

Share This