Community Course

SQL Always On High Availability with SQL 2014

55153AC (Class Pack)
Based on student feedback via 'Metrics that Matter'
SQL Always On High Availability with SQL 2014
This course is designed for database administrators to familiarize them with the concepts in SQL AlwaysOn and High Availability. The course utilizes SQL 2014, but explains the differences from SQL 2012.
Please contact your Learning Partner in order to take this course
Author: BlueBuffaloPress

Course Duration: 2 Days

SATV: Yes

About This Course

This two-day instructor-led course is designed for database administrators to familiarize them with the concepts in SQL AlwaysOn and High Availability. The course utilizes SQL 2014, but explains the differences from SQL 2012.

Audience Profile

This course is intended for SQL DBAs and IT Professionals.

At Course Completion

  • Understand and utilize AlwaysOn and high availability concepts and terminology.
  • Understand edition changes from SQL 2012.
  • Understand failover clusters.
  • Understand log shipping.
  • Understand replication.
  • Understand database mirroring.
  • Understand database snapshots.
  • Understand SQL failover cluster implementation.
  • Understand multi-site clustering.
  • Understand flexible failover policy.
  • Understand and utilize AlwaysOn.
  • Understand node majority.
  • Understand node and disk majority.
  • Understand node and file share majority.
  • Understand no majority.
  • Understand configuration options.
  • Understand and utilize quorums.
  • Understand application failover.
  • Understand availability groups.
  • Understand availability replicas.
  • Understand and utilize AlwaysOn availability groups.
  • Understand active secondary replicas.
  • Understand readable secondary replicas.
  • Understand backups on secondary replicas.
  • Understand and utilize secondary availability group actions.
  • Understand how to monitor AlwaysOn Availability Groups.
  • Understand how to utilize the Dashboard.
  • Understand the tools available for troubleshooting.