PostgreSQL Advanced Administration
This PostgreSQL Advanced Administration course covers database upgrades, database security, table partitioning, and both streaming replication and logical replication of PostgreSQL 10 and PostgreSQL 11 databases.
Exercises and examples are used throughout the course to give practical hands-on experience with the techniques covered.
Who will the Course Benefit?
This PostgreSQL Advanced Administration course is designed for professional database administrators of PostgreSQL 10 and PostgreSQL 11 databases who need to be able to successfully plan and implement the upgrade of a PostgreSQL database. The course covers Streaming Replication in PostgreSQL, how it can be used to achieve automatic failovers and setup a highly available PostgreSQL Database Cluster and the replication of individual objects using Logical Replication. The course also covers how security can be managed in a PostgreSQL database, including encrypted TCP/IP connections and encrypted data, and how to split large tables into smaller physical pieces using Table Partitioning. This course is suitable for users of PostgreSQL 9 databases
--------------------------------------------------
PostgreSQL Advanced Administration
--------------------------------------------------