1

Introduction to Databases and the Need for Backup & Recovery

Description
  • Description: Begin with the fundamentals. Understand what a database is, its purpose, and the different types (relational, NoSQL - a basic overview). Learn why data is critical for organizations. Then, understand the concept of data loss and the vital role of backup and disaster recovery. Discuss common threats like hardware failures, human errors, and natural disasters. - Resources/Activities: - Expected Outcomes: Grasp the core concepts of databases, recognize the potential for data loss, and understand the necessity of backup and recovery strategies.
Available

Learning Objectives

  • Understand the fundamentals
  • Apply practical knowledge
  • Complete hands-on exercises
2

Database Backup Fundamentals

  • Description: Focus on the different types of backups. Explore full, incremental, and differential backups. Understand the advantages and disadvantages of each. Learn about the Recovery Point Objective (RPO) and Recovery Time Objective (RTO) – two crucial metrics. - Resources/Activities: - Expected Outcomes: Comprehend different backup strategies, understand how they affect RPO and RTO, and be able to choose appropriate backup types based on specific needs.
Locked

Learning Objectives

  • Understand the fundamentals
  • Apply practical knowledge
  • Complete hands-on exercises
3

Database Recovery Fundamentals

  • Description: Dive into the recovery process. Learn how to restore from different backup types. Understand the importance of testing recovery procedures. Discuss the differences between point-in-time recovery and full restores. - Resources/Activities: - Expected Outcomes: Understand the database recovery process, the importance of testing, and how to perform a basic restore.
Locked

Learning Objectives

  • Understand the fundamentals
  • Apply practical knowledge
  • Complete hands-on exercises
4

Backup Tools and Technologies – Introduction

  • Description: Get familiar with popular database backup tools and technologies. Explore options like built-in tools (e.g., SQL Server Management Studio for SQL Server, pgAdmin for PostgreSQL, or MySQL Workbench). Briefly touch on the concept of cloud-based backup solutions. - Resources/Activities: - Expected Outcomes: Familiarize with common database management tools and their backup capabilities and understand the general concept of cloud backup.
Locked

Learning Objectives

  • Understand the fundamentals
  • Apply practical knowledge
  • Complete hands-on exercises
5

Planning a Backup Strategy

  • Description: Learn how to create a basic backup strategy. Consider factors like data sensitivity, business requirements (RPO/RTO), storage costs, and frequency of backups. Understand the concept of retention policies. - Resources/Activities: - Expected Outcomes: Know the elements of a good backup strategy, and be able to create a basic schedule taking into account business needs and data sensitivity.
Locked

Learning Objectives

  • Understand the fundamentals
  • Apply practical knowledge
  • Complete hands-on exercises
6

Disaster Recovery Concepts and Planning

  • Description: Introduce disaster recovery (DR). Understand DR planning, including site selection (on-premise vs. cloud), failover mechanisms, and business continuity. - Resources/Activities: - Expected Outcomes: Understand the fundamentals of disaster recovery, and the components needed for a basic plan.
Locked

Learning Objectives

  • Understand the fundamentals
  • Apply practical knowledge
  • Complete hands-on exercises
7

Practice and Review

  • Description: Consolidate your learning. Perform a complete backup and restore of a test database. This hands-on practice reinforces all the previous topics. Review key concepts and terms. - Resources/Activities: - Expected Outcomes: Hands-on experience with backup and restore, and a firm grasp of the fundamental concepts and terms. Confident of starting the learning process in database backup and disaster recovery.
Locked

Learning Objectives

  • Understand the fundamentals
  • Apply practical knowledge
  • Complete hands-on exercises

Share Your Learning Path

Help others discover this learning path