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
New
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
English
Current price: $10 Original price: $100 Discount: 90% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 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
Requirements
  • 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
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 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
01:52:54
+
Introduction to SQL Dump Approach and Related Utilities
7 Lectures 23:56
Section-2-1-Backup Options in PostgreSQL
03:44

Section-2-2-SQL Dump Approach
02:25

Section-2-3-Environment-Setup
08:02

Section-2-4-Introduction to pg_dump
03:04

Section-2-5-Introduction to pg_dumpall
03:19

Section-2-6-Introduction to psql
01:17

Section-2-7-Introduction to pg_restore
02:05

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
01:42

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

Section-3-3-Using .pgpass for auto authentication
02:32

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
04:25

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

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

Section-3-7-Understanding the custom dump format files
01:07


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

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

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

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
01:23

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

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

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

Section-3-16-Handling backups and restoration in tar format
03:29

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

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

Section-3-19-Parallelism with Backup and Restore
06:08

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

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

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

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

Section-3-24-How to dump only tablespaces across databases
00:54

Section-3-25-How to dump only roles across databases
00:56

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

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
03:32
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!