Home » Training Courses » Microsoft Certified Training » 6231 - Maintaining a Microsoft SQL Server 2008 Database

6231 - Maintaining a Microsoft SQL Server 2008 Database

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

Course code: 6231

Elements of this syllabus are subject to change.

This five-day instructor-led Maintaining a Microsoft SQL Server 2008 Database training course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2008 database. The Maintaining a Microsoft SQL Server 2008 Database training course focuses on teaching individuals how to use SQL Server 2008 product features and tools related to maintaining a database.

Course Objectives:

After completing this Maintaining a Microsoft SQL Server 2008 Database training course, students will be able to:

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

Course Content

• Module 1: Installing and Configuring SQL Server
• Module 2: Managing Databases and Files
• Module 3: Disaster Recovery
• Module 4: Managing Security
• Module 5: Transferring Data
• Module 6: Automating Administrative Tasks
• Module 7: Implementing Replication
• Module 8: Maintaining High Availability
• Module 9: Monitoring SQL Server
• Module 10: Troubleshooting and Performance Tuning

Course Pre-requisites:

This Maintaining a Microsoft SQL Server 2008 Database training course is intended for IT Professionals who administer and maintain SQL Server databases.

Before attending this Maintaining a Microsoft SQL Server 2008 Database training 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.

Maintaining a Microsoft SQL Server 2008 Database Training Course Recommended Reading

Microsoft® SQL Server® 2008 Step by Step - Mike Hotek - buy from amazon

For full course content and pre-requisites download the 6231 - Maintaining a Microsoft SQL Server 2008 Database Course PDF

Share This

Silicon Beach Training

See independent Google Places, Free Index and Qype reviews.