• Online, Self-Paced
Course Description

Point-in-time restores and geo replication are features used to protect SQL databases in an Azure implementation. This course introduces these features, as well as other features used for restoring databases and post recovery tasks.

Learning Objectives

SQL Database Data Recovery

  • start the course
  • recognize the factors that could impact recovery time to restore a database
  • recognize how to implement a point-in-time restore
  • demonstrate how to restore a deleted database to the point of deletion
  • demonstrate how to restore a live database to a point in time
  • design a geo-replication topology
  • describe how standard geo-replication works
  • configure active geo-replication
  • implement active-passive compute with coupled failover
  • implement active-passive compute with decoupled failover
  • describe geo-restore features
  • describe best practices for configuring your database after recovery
  • demonstrate how to copy and export databases
  • restore databases using PowerShell

Practice: SQL Database Recovery Features

  • demonstrate how to use SQL database recovery features

Framework Connections

The materials within this course focus on the Knowledge Skills and Abilities (KSAs) identified within the Specialty Areas listed below. Click to view Specialty Area details within the interactive National Cybersecurity Workforce Framework.