Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Backup and Restore Fundamentals in PostgreSQL DB - Level 1
Rating: 3.8 out of 5(113 ratings)
649 students

Backup and Restore Fundamentals in PostgreSQL DB - Level 1

Certified PostgreSQL ( Postgres ) Database Backup and Recovery Professional
Created byRajkumar V
Last updated 8/2017
English

What you'll 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

Course content

4 sections38 lectures1h 52m total length
  • Section-1-1-Course-Introduction5:16
  • Section-1-2-What is backup and restore, in the context of database technology ?1:49
  • Section-1-3-Importance of Backup and Restore in a database1:38
  • Section-1-4-Different techniques of backup and restore in Postgresql database1:15

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

  • Database Administrators
  • Database Developers
  • Database Testers
  • Anyone who loves technological aspects