|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/postgresql-for-oracle-dbas/
课程评论：没有评论
**课程名称：** PostgreSQL for Oracle DBAs (Oracle DBA 的 PostgreSQL 之旅) **课程概述：** 本课程专为希望快速掌握 PostgreSQL 管理的 Oracle 数据库管理员设计，无需沉浸于冗长的书籍或从零开始学习。课程重点关注 Oracle DBA 所需的关键知识，例如在 PostgreSQL 中生成类似 Oracle AWR 的报告，并利用类似于 Data Guard Broker 的工具实现计划内切换或自动故障转移。 课程内容涵盖了通常在其他 PostgreSQL 课程中较少涉及的主题，包括对 DBA 有用的扩展功能、PostgreSQL 中的 Hints 使用方法，以及如何在不修改应用程序代码的情况下实现 Hints（类似于 SQL Profiles）。 此外，课程还将深入探讨高可用性选项，并演示如何结合 Pgpool 和 Repmgr 等多种高可用性解决方案，在用户无感知的情况下实现读请求在主库和备库之间的自动负载均衡。 课程全程将 Oracle DBA 熟悉的术语与其在 PostgreSQL 中的对应概念进行关联，清晰阐述两种数据库之间的差异。 **课程目标:** 本课程旨在成为 Oracle DBA 过渡到 PostgreSQL DBA 的全面指南。完成后，您将能够轻松地管理 PostgreSQL 数据库，并为深入学习更高级的主题打下坚实基础。 **目标学员:** * PostgreSQL DBA * PostgreSQL 管理员
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.
