Backup and Restore Fundamentals in PostgreSQL DB – Level 2

Backup and Restore Fundamentals in PostgreSQL DB – Level 2, available at $29.99, has an average rating of 3.65, with 19 lectures, 2 quizzes, based on 75 reviews, and has 546 subscribers.

You will learn about 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 This course is ideal for individuals who are Database Administrators or Database Developers or Database Testers or Anyone who loves technological aspects It is particularly useful for Database Administrators or Database Developers or Database Testers or Anyone who loves technological aspects.

Enroll now: Backup and Restore Fundamentals in PostgreSQL DB – Level 2

Summary

Title: Backup and Restore Fundamentals in PostgreSQL DB – Level 2

Price: $29.99

Average Rating: 3.65

Number of Lectures: 19

Number of Quizzes: 2

Number of Published Lectures: 19

Number of Published Quizzes: 2

Number of Curriculum Items: 22

Number of Published Curriculum Objects: 22

Original Price: $89.99

Quality Status: approved

Status: Live

What You Will Learn

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

Who Should Attend

Database Administrators
Database Developers
Database Testers
Anyone who loves technological aspects

Target Audiences

Database Administrators
Database Developers
Database Testers
Anyone who loves technological aspects

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.

Course Curriculum

Chapter 1: Introduction

Lecture 1: Section-1-1-Course-Introduction

Chapter 2: Building the Foundation

Lecture 1: Section-2-1-What is backup and restore, in the context of database technology ?

Lecture 2: Section-2-2-Importance of Backup and Restore in a database

Lecture 3: Section-2-3-Different techniques of backup and restore in PostgreSQL database

Lecture 4: Section-2-4-Backup Options in PostgreSQL

Lecture 5: Section-2-5-Environment Setup

Chapter 3: Filesystem Level Backup and Restore

Lecture 1: Section-3-1-Introduction to Filesystem Level Backup and Restore

Lecture 2: Section-3-2-Approach-1 Copy and Paste

Lecture 3: Section-3-3-Approach-2 Rsync

Chapter 4: Continuous Archival and Point-In-Time Recovery

Lecture 1: Section-4-1-Introduction to Continuous Archival and Point in time Recovery

Lecture 2: Section-4-2-What is Continuous Archival ?

Lecture 3: Section-4-3-What is PITR ?

Lecture 4: Section-4-4-How Continuous Archival is used for PITR ?

Lecture 5: Section-4-5-Demo : Continuous Archival and Point in Time Recovery

Lecture 6: Section-4-6-How PITR Works ?

Lecture 7: Section-4-7-Most Challenging but Rewarding Approach

Chapter 5: Physical Backup Approach Vs Logical Backup Approach

Lecture 1: Section-5-1-Pros and Cons of Physical Backups and Logical Backups

Lecture 2: Section-5-2-When to use Physical Backups and When to use Logical Backups

Chapter 6: What Next ?

Lecture 1: Section-6-1-What Next ?

Instructors

Rajkumar V
Data Architect

Rating Distribution

1 stars: 4 votes
2 stars: 6 votes
3 stars: 23 votes
4 stars: 20 votes
5 stars: 21 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

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!

Menu