4.05 out of 5
4.05
32 reviews on Udemy

Backup and Restore Fundamentals in PostgreSQL DB – Level 2

Certified PostgreSQL ( Postgres ) Database Backup and Recovery Professional
Instructor:
Rajkumar V
291 students enrolled
English
Practical exposure on backup and restore techniques in PostgreSQL Database
The best part is that every concept and techniques explained are supported by a hands on demo session
Source codes / scripts for performing backup and restoration tasks

Learn the key terminologies, basic concepts, implementation techniques that you will need to carry out the backup and restoration tasks in PostgreSQL database. Every concepts or topics are covered with hands on demo session to provide better clarity.

Many of the key concepts learned in this course can be applied on other databases as well. 

Content and Overview

Through this course, comprising of 6 Sections with multiple lectures and demo sessions, Quiz chapters, Assignments, along with additional resources, you will 

  • Understand what, when and how to carry out backup and restoration tasks.
  • Gain confidence in implementing Backup and Restoration jobs in Production system
  • Know how to write backup and restoration scripts
  • Understand how to automate all the tasks related to backup and restoration tasks

You can test the knowledge gained through the sessions by attending quizzes and every use case mentioned in the course are explained with demo sessions thereby enabling you to practice the newly learned skills. 

I will add more contents to this course as and when possible.

Downloadable Resources

The backup and restoration scripts used are mostly of one liner form and hence you could watch those in the videos and use the same in your project. Whereas in certain demo sessions, complex scripts are used and the same has been attached as resources for you to download.

You can download the source code files / Environment setup instructions used during the demo sessions, to practice at your end.

Learners who complete this course will gain the knowledge and confidence to implement a fully functional Backup and Restoration solutions in the projects.

Introduction

1
Section-1-1-Course-Introduction

Building the Foundation

1
Section-2-1-What is backup and restore, in the context of database technology ?
2
Section-2-2-Importance of Backup and Restore in a database
3
Section-2-3-Different techniques of backup and restore in PostgreSQL database
4
Section-2-4-Backup Options in PostgreSQL
5
Section-2-5-Environment Setup

Filesystem Level Backup and Restore

1
Section-3-1-Introduction to Filesystem Level Backup and Restore
2
Section-3-2-Approach-1 Copy and Paste
3
Filesystem Level Backup and Restore
4
Section-3-3-Approach-2 Rsync

Continuous Archival and Point-In-Time Recovery

1
Section-4-1-Introduction to Continuous Archival and Point in time Recovery
2
Section-4-2-What is Continuous Archival ?
3
Section-4-3-What is PITR ?
4
Section-4-4-How Continuous Archival is used for PITR ?
5
Section-4-5-Demo : Continuous Archival and Point in Time Recovery
6
Section-4-6-How PITR Works ?
7
Section-4-7-Most Challenging but Rewarding Approach
8
Continuous Archival and PITR

Quiz around Continuous Archival and PITR approach

Physical Backup Approach Vs Logical Backup Approach

1
Section-5-1-Pros and Cons of Physical Backups and Logical Backups
2
Section-5-2-When to use Physical Backups and When to use Logical Backups

What Next ?

1
Section-6-1-What Next ?
2
Physical Backup Approach Vs Logical Backup Approach
You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
4.1
4.1 out of 5
32 Ratings

Detailed Rating

Stars 5
10
Stars 4
11
Stars 3
9
Stars 2
1
Stars 1
1
04e65fbdfe8d2cb3736402cd5918a6cd
30-Day Money-Back Guarantee

Includes

2 hours on-demand video
Full lifetime access
Access on mobile and TV
Certificate of Completion