SQL Server 2016 High Availability and Disaster Recovery Online Training

Taught by

UPDATED: March 2, 2021

Intermediate

Virtual Labs

This Microsoft SQL Server 2016 High Availability and Disaster Recovery training covers how to provide consistent, high-speed access to data. Topics include Log Shipping, Windows Clustering, Availability Groups, and failover management. This SQL course deal for database admins looking to ensure business continuity and minimal downtime.

Start a free week

Subscription options

$59.00

Access all premium content with a free week!

Quizzes
CyberVista® IT practice exams
Coaching
IT learner community

Start a free week

See training reviews

What you'll learn

Providing essential business continuity solutions for company data
Allowing work to continue in the event of outages or unforeseen calamity
Configuring and monitoring Log Shipping
Configuring Windows clustering and availability groups
Managing failover

FAQs

What will you learn in this high availability and disaster recovery training?

You'll learn three specific approaches to keeping data available in extreme conditions: failover cluster instances, always-on availability groups and log shipping – all in SQL Server 2016. SQL Server 2016 isn't the most up-to-date version any longer, but that makes niche knowledge of it even more valuable.

Why should you take this SQL Server 2016 course in HA and disaster recovery?

You should take this course in high availability and disaster recovery because those are two of the most time-sensitive and urgent needs any database administrator has. But you should especially take it if you work with SQL Server 2016, since few people have a mastery of its particularities.

Is this SQL Server 2016 course associated with a certification?

No, this SQL Server 2016 course isn't associated with a certification because Microsoft retired all of its certifications related to it. Microsoft is more focused on role-based certifications with their cloud-based service packages, so there's no longer a valid certification related to this HA/DR course.

Are there any certifications you should be thinking about after taking this high availability and disaster recovery course?

The only certification that relates (slightly) to the material on this course is the Azure Database Administrator Associate. If what excites you about this course is the SQL Server 2016 material, you're out of luck. But if it's the specialized database administration, that's the certification to consider.

Who should take this SQL Server 2016 HA and disaster recovery training?

Anyone responsible for keeping data moving reliably under the worst or most stressful circumstances should consider this course – especially if that data passes through a SQL Server 2016 instance. You should take this if you need to know the particulars of keeping SQL Server data available and stable.

Who is this for?

This SQL Server 2016 High Availability and Disaster Recovery training is considered associate-level Microsoft training, which means it was designed for systems administrators. This SQL Server 2016 skills course is valuable for new IT professionals with at least a year of experience with server HA and DR administration and experienced systems administrators looking to validate their Microsoft skills.

What our learners say

Awesome, Top notch, I am super excited and thankful for CBT Nuggets. I am starting to get addicted to CBT Nuggets. I hope that there's no cure!!!
Mike M. | CBTN Learner
When learning a new technology, people sometimes build a wall that complicates the learning process because of the unknown. I like tearing down that wall — and having people fall in love with that technology.
Lalo Nunez | CBT Nuggets trainer since 2020
CBT Nuggets fits into my day-to-day amazingly.
John M. | IT Manager

Study plan

Download the free SQL Server 2016 High Availability and Disaster Recovery Online Training study plan to complete this course in about 2 hours.

Download study plan