SQL Server High Availability Training

Level: Advanced
Rating: 4.8/5 4.78/5 Based on 45 Reviews

SQL Server provides a full range of technologies that allow organizations to reduce downtime and maintain high levels of availability. In this SQL Server High Availability training course, you gain experience using SQL Server 2017 AlwaysOn technologies for building a variety of high availability solutions, and learn how to implement failover clustering, log shipping, database mirroring, and peer-to-peer transactional replication.

Key Features of this SQL Server High Availability Training

  • After-course instructor coaching benefit
  • Learning Tree end-of-course exam included

You Will Learn How To:

  • Design a service level agreement that matches business requirements
  • Plan, prepare, and install a SQL Server failover cluster
  • Mirror a database to ensure instant failover
  • Automate deployment with AlwaysOn technologies
  • Ensure business continuity through failover cluster

Certifications/Credits:

CPE 17 Credits

Choose the Training Solution That Best Fits Your Individual Needs or Organizational Goals

LIVE, INSTRUCTOR-LED

In Class & Live, Online Training

  • 3-day instructor-led training course
  • After-course instructor coaching benefit
  • Learning Tree end-of-course exam included
  • Earn 17 NASBA credits (live, in-class training only)
View Course Details & Schedule

Standard $2650

Government $2355

RESERVE SEAT

PRODUCT #141

TRAINING AT YOUR SITE

Team Training

  • Bring this or any training to your organization
  • Full - scale program development
  • Delivered when, where, and how you want it
  • Blended learning models
  • Tailored content
  • Expert team coaching

Customize Your Team Training Experience

CONTACT US

Save More On Training with FlexVouchers – A Unique Training Savings Account

Our FlexVouchers help you lock in your training budgets without having to commit to a traditional 1 voucher = 1 course classroom-only attendance. FlexVouchers expand your purchasing power to modern blended solutions and services that are completely customizable. For details, please call 888-843-8733 or chat live.

In Class & Live, Online Training

Time Zone Legend:
Eastern Time Zone Central Time Zone
Mountain Time Zone Pacific Time Zone

Note: This course runs for 3 Days

  • Feb 26 - 28 9:00 AM - 4:30 PM EST Ottawa / Online (AnyWare) Ottawa / Online (AnyWare) Reserve Your Seat

  • Apr 8 - 10 9:00 AM - 4:30 PM EDT Rockville, MD / Online (AnyWare) Rockville, MD / Online (AnyWare) Reserve Your Seat

  • Aug 19 - 21 9:00 AM - 4:30 PM EDT Ottawa / Online (AnyWare) Ottawa / Online (AnyWare) Reserve Your Seat

Guaranteed to Run

When you see the "Guaranteed to Run" icon next to a course event, you can rest assured that your course event — date, time, location — will run. Guaranteed.

SQL Server High Availability Course Information

  • Course Description

    In this 3-day SQL Server High Availability course, you learn to maintain a large number of constantly available database servers to ensure disaster recovery.

SQL Server High Availability Course Outline

  • High-Availability Fundamentals

    Characterizing high availability

    • The "five nines"
    • Site
    • Instance
    • Database
    • Defining a service level agreement

    Planned vs. unplanned downtime

    • Performing routine maintenance
    • Recovering from disasters
    • Handling hardware failures
  • Installing Windows 2008/2012 Failover Clustering

    Defining components of a cluster

    • Single-instance architecture
    • Multi-instance architecture
    • Shared storage
    • Resource group
    • Heartbeat
    • Quorum

    Preparing for Windows failover clustering

    • Configuring an iSCSI target
    • Managing shared storage
    • Installing the failover clustering feature
  • Establishing SQL Server Failover Clustering

    Planning for SQL Server failover clustering

    • Determining the correct version of Windows Server
    • Upgrading to SQL Server 2012
    • Leveraging virtual machines for clustering

    Creating a SQL Server failover cluster

    • Installing a new failover cluster
    • Adding a new node
    • Failing over to a passive node
  • Employing Log Shipping

    Preparing for a warm standby server

    • Synchronizing logins
    • Creating network shares

    Implementing transaction log shipping

    • Specifying log backup frequency
    • Configuring the log shipping monitor

    Switching to the standby server

    • Redirecting applications
    • Bringing the standby online
  • Configuring Database Mirroring

    Comparing mirroring architectures

    • High availability
    • High protection
    • High performance
    • Full safety vs. safety off

    Getting ready for mirroring

    • Setting the recovery model
    • Selecting the principal, mirror and witness servers

    Mirroring a database

    • Configuring the principal, mirror and witness servers
    • Initiating the mirroring session

    Administering mirroring

    • Enabling and disabling mirroring with scripts
    • Launching the Database Mirroring Monitor (DMM)

    Employing a mirror for reporting

    • Taking a database snapshot
    • Querying a snapshot of the mirror
  • AlwaysOn Availability Groups

    Enhancing the capabilities of database mirroring

    • Database mirroring with multiple databases and multiple mirrors
    • Manually failing over a group of databases

    Clustering and deployment

    • Multi-site clustering across subnets
    • Automating deployment using AlwaysOn PowerShell cmdlets
    • Monitoring the high-availability configuration using the AlwaysOn dashboard
  • Combining High-Availability Technologies

    Selecting the appropriate strategies

    • Determining the pros and cons of each HA technology
    • Failover clustering with a mirror

    Pulling it all together

    • Creating a complete high-availability solution
    • Evaluating the results

Team Training

SQL Server High Availability Training FAQs

  • What is SQL Server High Availability?

    SQL Server High Availability allows 24 hour access to its database if any problem were to arise and you need immediate solutions.

  • What version of SQL Server is this High Availability course applicable to?

    The applicable version for this course is SQL Server 2017.

  • Can I learn SQL Server High Availability online?

    Yes! We know your busy work schedule may prevent you from getting to one of our classrooms which is why we offer convenient online training to meet your needs wherever you want, including online training.

Questions about which training is right for you?

call 888-843-8733
chat Live Chat




100% Satisfaction Guaranteed

Your Training Comes with a 100% Satisfaction Guarantee!*

  • If you are not 100 % satisfied, you pay no tuition!
  • No advance payment required for most products.
  • Tuition can be paid later by invoice - OR - at the time of checkout by credit card.

*Partner-delivered courses may have different terms that apply. Ask for details.

Ottawa / Online (AnyWare)
Rockville, MD / Online (AnyWare)
Ottawa / Online (AnyWare)
Preferred method of contact:
Chat Now

Please Choose a Language

Canada - English

Canada - Français