YoVDO

Recovering Data in Azure and SQL Server

Offered By: Microsoft via edX

Tags

Microsoft Azure Courses DevOps Courses Database Administration Courses Azure SQL Database Courses

Course Description

Overview

Is your data protected against disaster? Database administrators, regardless of platform need to be ready, whether working with SQL Server 2016, SQL Server v.Next on Linux, or Azure SQL Databases.

In this course, which is part of the SQL Server Database Administration series, you’ll explore the various recovery models you can set up.

Learn about your choices for system backup and gain an understanding of how to back up and recover SQL Server 2016, SQL Server v.Next on Linux, and Azure SQL Databases. Then you’ll actually do a backup. Plus, get practical tips on how to restore a SQL Server database.

This computer science course introduces features and technologies for recovering data. Topics include: SQL Server Recovery Models, Backup of SQL Server Databases, and Restoring SQL Server Databases.


Syllabus

Module 1: SQL Server Recovery Models
This module introduces the recovery models in SQL Server, which define the use of the transactions log and determine backup and recovery options available in SQL databases
 
Module 2: Backup of SQL Server Databases
This module covers backup types and options, and describes options for managing backups.
 
Module 3: Restoring SQL Server Databases
This module covers restore processes and sequencing, and options such as geo-redundancy in Azure.
 
Final Exam
After the final module you will take final exam, which accounts for 30% of your grade and will be combined with the homework assignments in each module to determine your overall score. You must achieve an overall score of 70% or higher to pass this course and earn a certificate.


Taught by

Chris Randall and Geoff Allix

Tags

Related Courses

Database Administration and SQL Language Basics
A Cloud Guru
PostgreSQL Administration Deep Dive
A Cloud Guru
Administering an AlloyDB Database
Google via Google Cloud Skills Boost
Advanced Data Modeling
Meta via Coursera
Amazon Aurora MySQL - Migration (Korean)
Amazon Web Services via AWS Skill Builder