Backup and Restore Fundamentals in PostgreSQL DB - Level 2 (Udemy.com)

Certified PostgreSQL ( Postgres ) Database Backup and Recovery Professional

( 10 Reviews )

Created by: Rajkumar V

Produced in 2017

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

Quality Score

Content Quality

Video Quality

Qualified Instructor

Course Pace

Course Depth & Coverage

Overall Score : 84 / 100

Course Description

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.Who this course is for:

Database Administrators
Database Developers
Database Testers
Anyone who loves technological aspects

Time: 2h

Instructor Details

Rajkumar V

4.2 Rating
10 Reviews

My name is Rajkumar and I am so excited to contribute the learning from my industrial experience.
With more than a decade of experience in IT, I have spent the majority of my time dealing with "DATA", that includes data modeling, data profiling, cleansing, data transformation, storage, retrieval, optimization, governance, mining and reporting.
I have played various roles in my career that includes Developer, Data Modeler, Tester, Project Lead, Product Consultant, Data Architect, ETL Specialist, Solution Architect, Release Manager etc.
To sum up, I am absolutely passionate about anything to do with "DATA" and I am looking forward to share my passion and knowledge with you!

Backup and Restore Fundamentals in PostgreSQL DB - Level 1

Backup and Restore Fundamentals in PostgreSQL DB - Level 1 (2017)
3.7 (17 Reviews)

- Provider: Udemy
- Time: 2h

$11.99

Learn Partitioning in PostgreSQL from Scratch

Learn Partitioning in PostgreSQL from Scratch (2016)
3.4 (17 Reviews)

- Provider: Udemy
- Time: 1.5h

$11.99

All courses by Rajkumar V

Reviews

4.2

10 total reviews

5 star 4 star 3 star 2 star 1 star

Write a Review

By Arie Yuster

comprehensive

By Nadeem Akhtar

I have gone through the what will cover in this course, and come to know that its not covering how to automate all the techniques, whereas while registering this course red it will be covering.

By Jorge Amaro Coria

Better than the first course from this series, but remains the poor pronunciation in many videos

By Mwangi Ramson

I got to master (I mean lean and experiment on) PostgreSQL physical archival methods i.e. How to use rsync to copy tablespace and PG data directory to a standby server, point in time recovery using PG's recovery.conf and how to make continuous archival configs on postgresql.conf file. Very helpful and recommendable!

By Chanda Chilambwe

It has been good, will definitely recommend this course

By Rodrigo Almeida

The content is very good and the instructor explanation. However, the accent is a little bit difficult to understand if English is not your native language.

By Shyam Kumar

i have learn many new things . This tutorial is very good and helpful

By Eric Mokaya

The course content is delivered well, but requires an update to cater for version 11 and there's no reason to split logical and physical backups into different courses

By Orlando Tjon

The subject is explained very clear.

By Edwind Contreras

Thanks a god this videos have subtitles because the english pronuntiation is hard to follow, the course is just fine, but need to be more deeper on backup strategies, i not clear yet about if the base backup needs to be made all days or just once and if the wall files have rotation, how i know wich is my backup window to restore, postgreSQL have tools to review the wal files like pg_xlogdump, this tools aren't mentioned.