MSEL Collection Info

Collection 2788: Designing High-Availability Database Solutions Using Microsoft® SQL Server™ 2005

With this collection of eight 2-hour courses, you gain the knowledge and skills to design high availability database solutions using Microsoft SQL Server 2005. The collection 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 you should think broadly about high availability, which includes thinking about the database itself and about your entire environment, including business needs; regulatory requirements; and network, systems, and database considerations during design. You also learn how to document and test the high availability database solution.

In addition, it is recommended, but not required, that you have completed collection 2778, Writing Queries Using Microsoft SQL Server 2005 Transact-SQL.

This online learning collection is composed of a rich multimedia experience coupled with comprehensive technical labs.

This collection also helps prepare you for certification exam 70-444: PRO: Optimizing and Maintaining a Database Administration Solution by Using Microsoft SQL Server 2005.

Cursos contenidos en esta colección:

- Course 3166: Selecting the Appropriate High-Availability Technology Using MS SQL Server 2005

In this course, you establish and then implement a comprehensive high-availability strategy for SQL Server 2005 by following a four step process: analyzing business requirements, selecting an appropriate strategy, designing and implementing the architecture, and managing the infrastructure.
This course also helps prepare you for certification exam 70-444: PRO: Optimizing and Maintaining a Database Administration Solution by Using Microsoft SQL Server 2005.

Ver contenidos del curso

- Course 3167: Designing a Highly Available Database Storage Solution Using MS SQL Server 2005

In this course, you apply guidelines and considerations for determining the storage requirements for Microsoft SQL Server 2005 databases, components, and supporting external files.

You also apply guidelines for designing storage solutions for SQL Server databases and for designing disaster recovery plan (DRP) strategies to maximize availability.

Finally, you recover damaged and partially damaged databases.

This course also helps prepare you for certification exam 70-444: PRO: Optimizing and Maintaining a Database Administration Solution by Using Microsoft SQL Server 2005.

Ver contenidos del curso

- Course 3168: Designing a Clustering Solution Using MS SQL Server 2005

In this course, you design, manage, and upgrade a Microsoft SQL Server 2005 clustering solution.

This course also helps prepare you for certification exam 70-444: PRO: Optimizing and Maintaining a Database Administration Solution by Using Microsoft SQL Server 2005.

Ver contenidos del curso

- Course 3169: Designing a Log Shipping Solution Using MS SQL Server 2005

In this course, you learn the key features and requirements of a Microsoft SQL Server 2005 log shipping solution. You apply considerations for configuring log shipping server roles and designing a log shipping topology, and the guidelines for designing a log shipping upgrade strategy. Finally, you design an operations plan for log shipping.

This course also helps prepare you for certification exam 70-444: PRO: Optimizing and Maintaining a Database Administration Solution by Using Microsoft SQL Server 2005.

Ver contenidos del curso

- Course 3170: Designing a Database Mirroring Solution Using MS SQL Server 2005

In this course, you design database roles and topologies for database mirroring of Microsoft SQL Server 2005. You convert existing high-availability solutions to database mirroring and design an operations plan to maximize availability. In addition, you manage security events and threats in database mirroring.

This course also helps prepare you for certification exam 70-444: PRO: Optimizing and Maintaining a Database Administration Solution by Using Microsoft SQL Server 2005.

Ver contenidos del curso

- Course 3171: Designing Replication Solutions for High Availability Using MS SQL Server 2005

In this course, you design high-availability solutions based on replication in Microsoft SQL Server 2005.

You apply guidelines and best practices for implementing replication, and for creating an operations plan for your solution. In addition, you design a disaster recovery strategy by using merge replication and transactional replication.

This course also helps prepare you for certification exam 70-444: PRO: Optimizing and Maintaining a Database Administration Solution by Using Microsoft SQL Server 2005.

Ver contenidos del curso

- Course 3172 : Combining High-Availability Technologies Using MS SQL Server 2005

In this course, you evaluate the weaknesses in each high-availability technology for Microsoft SQL Server 2005 including clustering, log shipping, database mirroring, replication, and storage technologies.

You then apply guidelines for maximizing availability by combining existing technologies.

This course also helps prepare you for certification exam 70-444: PRO: Optimizing and Maintaining a Database Administration Solution by Using Microsoft SQL Server 2005.

Ver contenidos del curso

- Course 3173: Documenting and Testing a High-Availability Strategy Using MS SQL Server 2005

In this course, you document a Microsoft SQL Server 2005 high-availability solution.

You apply guidelines for documenting business requirements, failover and failback strategies, performance benchmarks, threats, and a test plan to your selected solution.

This course also helps prepare you for certification exam 70-444: PRO: Optimizing and Maintaining a Database Administration Solution by Using Microsoft SQL Server 2005.

Ver contenidos del curso