PostgreSQL for Oracle DBAs
สิ่งที่คุณจะได้เรียนรู้
- 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
ข้อกำหนด
- Oracle Database Administration
คำอธิบาย
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.
หลักสูตรนี้เหมาะกับ
- 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.
วิทยากร
- คะแนนวิทยากร 4.6
- รีวิว 462 รายการ
- ผู้เรีียน 2,188 คน
- หลักสูตร 1 รายการ
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.