• Length:
    4 Weeks
  • Effort:
    2–3 hours per week
  • Price:

    FREE
    Add a Verified Certificate for $99 USD

  • Institution
  • Subject:
  • Level:
    Intermediate
  • Language:
    English
  • Video Transcript:
    English

Prerequisites

  • Familiarity with database concepts and basic SQL query syntax.
  • A willingness to learn actively and persevere when troubleshooting technical problems is essential.

About this course

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.

What you'll learn

  • How to select a backup strategy to meet recovery time and recovery point objectives
  • How to back up databases and transaction logs
  • How to manage backups
  • How to restore databases
  • How to perform a point-in-time recovery
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.

Meet your instructors

Geoff Allix
Microsoft Certified IT Professional for SQL Server
Content Master
Chris Randall
Senior Content Developer, Microsoft Learning Experiences
Microsoft

Pursue a Verified Certificate to highlight the knowledge and skills you gain $99.00

View a PDF of a sample edX certificate
  • Official and Verified

    Receive an instructor-signed certificate with the institution's logo to verify your achievement and increase your job prospects

  • Easily Shareable

    Add the certificate to your CV or resume, or post it directly on LinkedIn

  • Proven Motivator

    Give yourself an additional incentive to complete the course

  • Support our Mission

    EdX, a non-profit, relies on verified certificates to help fund free education for everyone globally