SQL Server High Availability Training

Level: Advanced

Rating: 4.78/5 Based on 36 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.

Page Sections

You Will Learn How To

Training Solutions

Details & Schedule

FAQs

Related Training

Get Started

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:

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

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

Timezone

Location

Date

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) Reserve Your Seat
Apr 8 - 10 9:00 AM - 4:30 PM EDT Washington, DC / Online (AnyWare) Reserve Your Seat
Aug 19 - 21 9:00 AM - 4:30 PM EDT Ottawa / Online (AnyWare) Reserve Your Seat
Sep 30 - Oct 2 9:00 AM - 4:30 PM EDT Washington, DC / 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