About this course
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
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.
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.
Pursue a Verified Certificate to highlight the knowledge and skills you gain $99.00
Official and Verified
Receive an instructor-signed certificate with the institution's logo to verify your achievement and increase your job prospects
Add the certificate to your CV or resume, or post it directly on LinkedIn
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