PostgreSQL Database Administration Essential Training 2024

PostgreSQL Administration for Oracle DBAs - Quickly Transition to Handle Postgresql

Created by: Ritesh Das
IT Infrasturcture and Database Architect

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

Requirements

• Oracle Database Administration

Target audience

• This Course is designed for Oracle Database Administrators who want to quickly pickup Postgres Administration, Instead of reading bulky books or start with courses from the scratch, This course emphasises only one what is needed from the eyes of an Oracle DBA. We will see how to generate Oracle Style AWR reports in Postgres, Use tools similar to dataguard broker for planned switch over or automatic failover. Throughout the course we will corelate terms that an Oracle DBA is familiar with and what it corresponds to in Postgres. We cover what is different between the two databases. All in All, this course is a comprehensive guide to transition from and Oracle DBA to Postgres DBA.