Backup and Restore Fundamentals in PostgreSQL DB - Level 1
4.5 (1 rating)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
25 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Backup and Restore Fundamentals in PostgreSQL DB - Level 1 to your Wishlist.

Add to Wishlist

Backup and Restore Fundamentals in PostgreSQL DB - Level 1

Certified PostgreSQL Database Backup and Recovery Professional
4.5 (1 rating)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
25 students enrolled
Created by Rajkumar V
Last updated 8/2017
Current price: $10 Original price: $100 Discount: 90% off
5 hours left at this price!
30-Day Money-Back Guarantee
  • 2 hours on-demand video
  • 3 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Assignments
  • Certificate of Completion
What Will I Learn?
  • Practical exposure on backup and restore techniques in PostgreSQL Database, when you go through both Level 1 and Level 2 courses
  • The best part is that every concept and techniques explained are supported by a hands on demo session
  • You will also learn and understand how to automate everything that has got to do with backup and restoration tasks.
  • Source codes / scripts for performing backup and restoration tasks
View Curriculum
  • Exposure to any Operating System (OS) and Installation of OS. Good to have exposure on Oracle Virtual Box Manager
  • You would need an operating system of any sort, such as Linux, Windows, Ubuntu or Mac.
  • You would require a Postgres database installed on your machine
  • For practicing hands on demo sessions involving multiple machines, you need to have PostgreSQL DB installed in HOST OS and VM or in multiple VMs

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 4 Sections, more than 35 lectures with Subtitles, 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 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 and automated Backup and Restoration solutions in the projects.

Who is the target audience?
  • Database Administrators
  • Database Developers
  • Database Testers
  • Anyone who loves technological aspects
Students Who Viewed This Course Also Viewed
Curriculum For This Course
38 Lectures
Introduction to SQL Dump Approach and Related Utilities
7 Lectures 23:56
Section-2-1-Backup Options in PostgreSQL

Section-2-2-SQL Dump Approach


Section-2-4-Introduction to pg_dump

Section-2-5-Introduction to pg_dumpall

Section-2-6-Introduction to psql

Section-2-7-Introduction to pg_restore

This assignment is important for every student. This would help you understand, why certain command line options are used in many stages during this course. Also this assignment would help with your work, involving SQL Dump based backup and Restoration approach.
Getting help on PostgreSQL Backup and Restore utilities
1 question
Production UseCases on Backup and Restoration of PostgreSQL Database
26 Lectures 01:15:28
Section-3-1-Backup using pg_dump

Section-3-2-Setting the environment variables related to PostgreSQL Database

Section-3-3-Using .pgpass for auto authentication

This assignment is intended to further enlighten the students on, how to use pgpass file for auto authentication purpose
Assignment on Auto Authentication in PostgreSQL using pgpass
2 questions

Section-3-4-How to initiate backup from remote machine

Section-3-5-Backup a DB and restore in another machine with different DB version

Section-3-6-Backup and Restore a database in custom format

Section-3-7-Understanding the custom dump format files

Section-3-9-Backup and Restore a list of tables

Section-3-10-Backup only the data from the specified list of tables

Section-3-11-Backup only the schema of tables and not their data

This assignment is to test the understanding of the students on demo session - "Backup only the schema of tables and not their data", and how they could modify / adjust the script used in the demo to meet the assignment goal.
Dump Schema structure of an entire Database objects
1 question

Section-3-12-Backup of specified schema from the database

Section-3-13-How to view the contents of a non plain text format backup file

Section-3-14-How to get the version information of various utilities

Section-3-15-How to get more details when the backup utilities are executed

Section-3-16-Handling backups and restoration in tar format

Section-3-17-How to Stop the Restoration when it encounters error

Section-3-18-How to Restore specified objects from custom dump file

Section-3-19-Parallelism with Backup and Restore

Section-3-20-How to dump a database and restore it using another name

Section-3-21-Backup and Restore a DB with different ownership or role

Section-3-22-Exit on Error Vs Single transaction options in pg_restore

Section-3-23-How to dump only global objects using pg_dumpall

Section-3-24-How to dump only tablespaces across databases

Section-3-25-How to dump only roles across databases

Section-3-26-Backup and Restore all databases in the Cluster

Through this assignment, you will get to know, how to restore a particular database, from (or) using a whole database cluster dump made by pg_dumpall utility ?
How to restore a particular database using a dump made by pg_dumpall
1 question

SQL Dump / Logical Backup and Restore Techniques
2 questions

This quiz helps the students to explore and understand the list of PostgreSQL Environment variables that are relevant to Backup and Restoration tasks

Environment Variables
2 questions
Learn Physical Backup and Restoration Techniques
1 Lecture 03:32
Section-4-1-Learn Physical Backup and Restoration Techniques
About the Instructor
Rajkumar V
3.9 Average rating
26 Reviews
195 Students
3 Courses
Data Architect

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!