Designing High Availability Database Solutions Using
Microsoft SQL Server 2005
• Course Number: 2788
• Length: 3 Day(s)
Certification Exam
This course will help you prepare for the following Microsoft Certified Professional
exams:
MCITP Exam 70–443: Designing a Database Server Infrastructure by Using
Microsoft SQL Server 2005
MCITP Exam 70–447: MCITP Upgrade for existing MCDBA Database
Administrators.
Course Overview
This three-day course provides students with the knowledge and skills to design high
availability database solutions using Microsoft SQL Server 2005 The course focuses
on teaching experienced database administrators working in enterprise environments
to design database solutions that meet the availability needs of their organization. It
emphasizes that students should think broadly about high availability, which includes
thinking about the database itself and about their entire environment, including
business needs; regulatory requirements; and network, systems, and database
considerations during design. Students will also learn how to document and test the
high availability database solution.
Prerequisites
Before attending this course, students must:
Have a basic understanding of network architecture. For example, what can fail in
a network, Virtual Private Networks (VPNs), differing performance characteristics
of network components, etc.
Understand the tradeoffs among the different redundant storage types. For
example, what RAID levels mean, how it differs from a SAN, etc.
Understand how replication works and how replication is implemented.
Be familiar with reading user requirements and business-need documents. For
example, development project vision or mission statements or business analysis
reports.
Have monitoring and troubleshooting skills.
Have knowledge of the operating system and platform. Specifically, must
understand how hardware can fail, how the operating system integrates with the
database, what the platform or operati