Description

Summary: This course will provide you with a technically deep learning experience on installing and securing Microsoft® SQL Server^TM 2005. The course provides detailed reference content and in-depth practical and hands-on activities for database administrators with Microsoft® SQL Server^TM 2005.

Audience: IT Pro
Available Offline: Yes
Subscription: 12 months

Course Type: Self-paced Course
Estimated Time of Completion: 6 Hours
Language: English

Description:
This course will enable database administrators experienced in SQL Server 2000/7.0 and Analysis Services to upgrade their skills to SQL Server 2005. The course is broken into three modules:

• Understanding Disaster Recovery
• Understanding Data Availability in SQL Server 2005
• Understanding SQL Server 2005 Replication Features

Course Objectives

At the end of the course, students will be able to:

• Perform backup and restore operations.
• Configure database mirroring.
• Configure replication using SQL Server 2005.

Technical Requirements

To view this course, you need:

• A Pentium II, 256 MB RAM with a processor speed greater than or equal to 400 MHZ
• Microsoft® Windows® 2000 or higher
• Microsoft Internet Explorer 6.0 or higher
• Macromedia Flash 7.0 or higher (1MB disk space needed to install)
• Microsoft Windows Media Player 7.0 or higher
• Microsoft XML Core Services 3.0 or higher
• A Super VGA monitor with minimum screen resolution 1024x768, with 16-bit color.
• A sound card, and either speakers or headphones (for multi-media audio).
• Internet bandwidth of 56K or faster. Broadband internet access is recommended.
For courses containing Virtual Server-based labs (courses in the IT Professional and Developer Catalog), you will need:
• Microsoft Virtual Server ActiveX control (1MB disk space needed to install)

Accessibility Requirements

The following software must be running on your computer in order to access this course with Screen Reader Software:

• Microsoft Internet Explorer 6.0 or higher
• Window-Eyes from GW Micro
• JAWS from Freedom Scientific
• MSAA enabled