Course code: MOC 2788« Back

Designing High Availability Database Solutions Using Microsoft SQL Server 2005

This three-day instructor-led 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.

This course has been removed from our portfolio
This section contains overview of retired courses which don’t belong to GOPAS course offer any more or were replaced by new course versions.
For more information about possibility to buy retired courses contact our customer services department ( or business department (

AffiliateDurationCatalogue priceHandbook priceITB
Praha3 19 050 CZK included in course price 30
Brno3 19 050 CZK included in course price 30
Bratislava3 495,00 EUR 189,00 EUR 30

Who is the course for

This course is intended for current professional database administrators who have three or more years of on-the-job experience administering SQL Server database solutions in an enterprise environment.

What we teach you

  • Describe the uses of and ways to execute the Transact-SQL language.
  • Use querying tool.
  • Write SELECT queries to retrieve data.
  • Group and summarize data by using Transact-SQL.
  • Join data from multiple tables.
  • Write queries that retrieve and modify data by using subqueries.
  • Modify data in tables.
  • Query text fields with full-text search.
  • Describe how to create programming objects.
  • Use various techniques when working with complex queries.
  • Required skills

  • 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 operating system can do, and how the interaction between the operating system and the database works.
  • Have knowledge of application architecture. Specifically, must understand how applications identify servers to connect to, how applications can be designed in three layers, what applications can do, the interactions between applications and the database, interactions between the database and the platform or operating system.
  • Know how to use:
  • A monitoring tool
  • Microsoft Visio (to create infrastructure diagrams)
  • Be familiar with SQL Server 2005 features, tools, and technologies.
  • Teaching methods

    Expert instruction with practical examples, computer practice

    Teaching materials

    Microsoft official training student kits (book, CDs)

    Course Outline

    Selecting the Appropriate High-availability Solution

    • Identifying High-availability Requirements and Constraints
    • Analyzing High-availability Requirements and Constraints
    • Determining Appropriate High-availability Solutions

    Designing a Database Clustering Solution

    • Designing a Cluster Topology
    • Designing an Operations Plan
    • Verifying a SQL Server Cluster Configuration
    • Monitoring a SQL Server Cluster

    Designing a Highly Available Database Storage Solution

    • Determining Storage Requirements for SQL Server Databases
    • Determining Storage Requirements for SQL Server Components and Files
    • Designing Storage Solutions for SQL Server Databases
    • Designing a Backup and Restore Strategy

    Designing a Log Shipping Solution

    • Introduction to Designing a Log Shipping Solution
    • Designing Log Shipping Server Roles and Topology
    • Designing a Log Shipping Upgrade Strategy
    • Designing an Operations Plan for Log Shipping

    Designing a Database Mirroring Solution

    • Introduction to Designing a Database Mirroring Solution
    • Designing Database Roles and Topology for Database Mirroring
    • Converting High-availability Solutions to Database Mirroring
    • Designing an Operations Plan for Database Mirroring

    Designing a Highly Available Solution Based on Replication

    • Introduction to Designing a Replication Solution
    • Designing a Replication Solution
    • Designing a Replication Upgrade Strategy
    • Designing an Operations Plan for Replication

    Combining High-availability Technologies

    • Evaluating Weaknesses in Each High-availability Technology
    • Maximizing Availability by Combining High-availability Technologies

    Documenting and Testing a High-availability Strategy

    • Documenting High-availability Solutions
    • Creating a Test Plan for High-availability Solutions

    Previous courses

    no preceding courses

    Next courses

    no following course
    Tištěná příručka MOC 2788

    4950 CZK
    Tištěná příručka MOC 2788

    189 EUR
    The prices are without VAT.