Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
1 Hour(s) 45 Minute(s)
Language
English
Taught by
Rajkumar V
Rating
Course Overview
Certified PostgreSQL ( Postgres ) Database Backup and Recovery Professional
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.
Course Content
- 6 section(s)
- 19 lecture(s)
- Section 1 Introduction
- Section 2 Building the Foundation
- Section 3 Filesystem Level Backup and Restore
- Section 4 Continuous Archival and Point-In-Time Recovery
- Section 5 Physical Backup Approach Vs Logical Backup Approach
- Section 6 What Next ?
What You’ll 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
Skills covered in this course
Reviews
-
DDavor Vesligaj
Was expecting more in-depth info, but as written in description, Fundamentals.
-
MMike C
The course provides some good information on how and when to use physical backups. The examples were simple to follow.
-
JJulio Morales
explains the different backup approaches well.
-
EEdwind 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.
