Length:    5 Days
Language(s):    English,  
Audience(s):    IT Professionals
Technology:    Microsoft SQL Server 2008
Delivery Method:    Instructor-led (classroom)
Certification:                   Microsoft SQL Server 2008, Implementation and Maintenance: Exam: 70-432

About this Course

Elements of this syllabus are subject to change.
This five-day instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2008 database. The course focuses on teaching individuals how to use SQL Server 2008 product features and tools related to maintaining a database.

Audience Profile

This course is intended for IT Professionals who administer and maintain SQL Server databases.

At Course Completion

After completing this 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.

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.