Backup and Restore Fundamentals in PostgreSQL DB – Level 1

Backup and Restore Fundamentals in PostgreSQL DB – Level 1, available at $39.99, has an average rating of 4.05, with 38 lectures, 2 quizzes, based on 109 reviews, and has 640 subscribers.

You will learn about 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 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 1

Summary

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

Price: $39.99

Average Rating: 4.05

Number of Lectures: 38

Number of Quizzes: 2

Number of Published Lectures: 38

Number of Published Quizzes: 2

Number of Curriculum Items: 44

Number of Published Curriculum Objects: 44

Original Price: $89.99

Quality Status: approved

Status: Live

What You Will 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

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 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.

Course Curriculum

Chapter 1: Introduction

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

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

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

Lecture 4: Section-1-4-Different techniques of backup and restore in Postgresql database

Chapter 2: Introduction to SQL Dump Approach and Related Utilities

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

Lecture 2: Section-2-2-SQL Dump Approach

Lecture 3: Section-2-3-Environment-Setup

Lecture 4: Section-2-4-Introduction to pg_dump

Lecture 5: Section-2-5-Introduction to pg_dumpall

Lecture 6: Section-2-6-Introduction to psql

Lecture 7: Section-2-7-Introduction to pg_restore

Chapter 3: Production UseCases on Backup and Restoration of PostgreSQL Database

Lecture 1: Section-3-1-Backup using pg_dump

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

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

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

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

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

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

Lecture 8: Section-3-8-Backup and Restoration of specific table

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

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

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

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

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

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

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

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

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

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

Lecture 19: Section-3-19-Parallelism with Backup and Restore

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

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

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

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

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

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

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

Chapter 4: Learn Physical Backup and Restoration Techniques

Lecture 1: Section-4-1-Learn Physical Backup and Restoration Techniques

Instructors

Rajkumar V
Data Architect

Rating Distribution

1 stars: 9 votes
2 stars: 7 votes
3 stars: 26 votes
4 stars: 42 votes
5 stars: 25 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