PostgreSQL for Oracle DBAs (Udemy.com)
PostgreSQL Administration for Oracle DBAs - Quickly Transition to Handle Postgresql
Created by: Ritesh Das
Last updated March 2025
What you will learn
- Quickly Learn Postgresql administration with a background of Oracle Database administration.
- Corelate terminology between Oracle and Postgres
- Administrering Postgres databases while corelating concepts of Oracle database
- Perform activities similar to AWR reports in Postgres, Backup, HA (similar to Dataguard broker )
- Transition to PostgreSQL DBA from Oracle DBA
How it compares
Against the other 1,182 rated Udemy courses in IT & Software on CourseDuck:
- Rating4.5 out of 5higher than 45% of them
- Reviews1,010#392 of 1,183 by number of reviews
- Length7.2 hourslonger than 59% of them
- Last updatedMarch 2025earlier than 53% of them
Course Description
This course is designed for Oracle Database Administrators who want to quickly pick up Postgres Administration, Instead of reading bulky books or starting with courses from scratch.
This course emphasizes only on what is needed from the eyes of an Oracle DBA.
We will see how to generate Oracle Style AWR reports in Postgres and use tools similar to Dataguard broker for planned switchover or automatic failover.
The course covers theoretical and practical demonstration of topics not usually covered in courses - such as useful extensions for DBAs, how to use hints in Postgres, and implementing hints without changing code (Similar to SQL Profiles).
We will look at High Availability options, and combine multiple HA options such as PGPOOL, Repmgr to load balance read requests automatically between Primary and Standby without the end users' knowledge.
Throughout the course, we will correlate terms that an Oracle DBA is familiar with and what it corresponds to in Postgres. We cover what is different between the two databases.
Overall, this course is a comprehensive guide to transition from an Oracle DBA to a Postgres DBA. After this course, you should be able to easily administer Postgres database and it lays the perfect groundwork to dwell deeper into more advanced topics.
The course is for Postgresql DBA, Postgresql Administration.
Instructor Details
- 4.5 Rating
1,010 Reviews
Ritesh Das
I have over 21 years of experience in multiple databases, Kubernetes, and cloud technologies.
I have worked in roles such as IT Systems Architect, Database Architect, Database Manager and Trainer.
Training is my passion, and I have actively contributed to various DBA COE, given seminars at Oracle University, and participated in Hackathon events.
I hold certifications like Certified Kubernetes Administrator, AWS Certified Solution Architect Associate, Oracle Certified RAC Expert, Oracle Certified Professional, Microsoft Certified Professional, A+ Certified.
More IT & Software courses
D3.js Data Visualization Fundamentals - Hands On (2026)
4.9 (3,917 Reviews)
Provider: Udemy
Time: 4.6h
$49.99
Hands-On Training: Streaming Data with Apache Kafka on Azure (2025)
4.9 (103 Reviews)
Provider: Udemy
Time: 3.7h
$10.99
Oracle Grid Infrastructure and RAC using Oracle Database 19c (2026)
4.8 (2,499 Reviews)
Provider: Udemy
Time: 8.7h
$19.99
PowerShell Scripting & Automation: The Complete Hands-On (2026)
4.8 (1,750 Reviews)
Provider: Udemy
Time: 9.6h
$11.99
AWS EC2 Crash Course + Load Balancing with Demos and PDFs (2025)
4.8 (866 Reviews)
Provider: Udemy
Time: 3.7h
$19.99
Reviews
By Ridhwaan Tarajia on 8/28/2026
Yes, as described in the introduction, the course offered an effective comparison with Oracle, allowing Oracle DBAs to relate PostgreSQL concepts to familiar technologies. The content was well structured, informative, and delivered in a professional manner.
By Sandeep Nagpal on 5/13/2026
Its very useful session to learn postgressql for any oracle dba. I would also like to see some more sessions related to postgresql service on azure service which I am currently working on.
By Neelesha K on 4/14/2026
As an Oracle DBA, I found this course excellent. Each topic is clearly compared with Oracle, which makes understanding PostgreSQL much easier. PostgreSQL is truly impressive, and I highly recommend this course to anyone who wants to learn PostgreSQL. Thank You ! Best Regards, Neelesh.
By Gregory Wilson on 3/11/2026
This was a great course. I found 2 places where I felt there was an "incorrect/problem" with a question.. 1 of the questions had 5 choices for an answer. The correct answer (exact same text) appeared twice. I choose one and it was wrong and choose the other and it was correct... again, i believe it was the same text.. but I don't remember the exact question or answer... The 2nd incorrect/problem was... Quiz 5: Quiz on Contents of PGDATA... Question 5: None of the end users are unable to connect to the database, What could be the likely issue ? I think you meant to say... None of the end users are ABLE to connect to the database, What could be the likely issue?
By Narayanareddy Kandukuru on 2/27/2026
This is hands-down the best PostgreSQL course I've taken — and it's especially valuable for those with an Oracle background, as it thoughtfully draws comparisons between the two platforms, making the transition intuitive and relatable. The course far exceeded my expectations, delivering practical, real-world insights that go beyond theory. As someone working in a multi-DBA environment, I found it particularly relevant for Oracle DBAs navigating today's increasingly diverse database landscape. I genuinely hope the instructor continues this series with more advanced open-source database content. One addition that would take it to the next level: interview preparation material for DBAs looking to validate or showcase their PostgreSQL skills.
By Muhammad Asif Khan on 2/9/2026
This course exceeded my expectations and provided excellent practical insights. I hope the instructor releases more advanced open-source database courses. Including interview preparation material would add even more value.
By Daniel Guimarães de Araujo on 1/21/2026
Congratulations on the course! This is truly the best PostgreSQL course I have ever taken. It is even better for those who already have knowkledge of or work with Oracle, as it helps relate and compare the content
By Muthusamy on 1/6/2026
Hello Ritesh Having spent 30 years in oracle, while i was looking for a PGSQL course to learn, found your course very interesting. You have done an excellent job of compiling correct quantity of subject with practical which made the learning journey easier. Thank you for such a good work and expecting many such postgresql courses in detail of pgpool, pgedge, standy's etc. Cheers !!
By Ian Wakley on 12/23/2025
In Quiz 14 Q2 the correct answer is given as pre_upgrade this is a typo and should say pg_upgrade. In Q8 the first 2 options are given twice and choosing the correct answer "SELECT version();" is marked as wrong if you choose the first occurrence but correct if you choose the second occurrence. This quiz needs correcting.
By M Paul on 12/21/2025
excellent and very detailed and easy to understand from new to experienced DBAs of both oracle and Postgres ( non cloud platform ) I suggest include a small chapter to discuss teh cloud offering dn its differentyce from community Postgres etc
Quality Score
No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.
Overall Score : 90 / 100






