CMDBID: 103822 | Course Code: STA-PSQLADVADM | Duration: 2 Days
Not available. Please contact.
Who will the Course Benefit? 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.
The delegate will gain an understanding of:
Plan the Upgrade of a PostgreSQL Database
Upgrade a PostgreSQL Database
Security features Available in PostgreSQL
Encrypted TCP/IP connections
Encrypt sensitive data using pgcrypto
Setup and use Streaming Replication
Setup and use Logical Replication
Setup and use Logical Replication Course Objectives Course Objectives
This training is designed for experienced Database Administrators and Architects who want to learn advanced administration techniques for implementing High Availability and Database Security in PostgreSQL.
The delegate will also learn how to upgrade a PostgreSQL database successfully.
Not available. Please contact.
PostgreSQL Advanced Administration Training Course Course Contents - DAY 1
Administration and Course Materials
Course Structure and Agenda
Delegate and Trainer Introductions
Session 1: DATABASE UPGRADES
Plan an Upgrade
Upgrade using pg_dump
Upgrade using pg_upgrade
Upgrade Streaming Replication and Log Shipping Standby Servers
Post Upgrade Tasks
Session 2: DATABASE SECURITY
Client Authentication Control
User and Role management
Row Level Security
Encrypt Specific Columns with the pgcrypto Module
The Performance Implications of Encryption
Session 3: CONTROL ACCESS TO THE SERVER
Secure TCP/IP Connections with SSL
Secure TCP/IP Connections with SSH Tunnels
PostgreSQL Advanced Administration Training Course Course Contents - DAY 2
Session 4: TABLE PARTITIONING
Overview of Table Partitioning
Create a Partitioned Table
Detach and Attach Partitions
Table Partitioning New Features
Table Partitioning using Inheritance
Session 5: STREAMING REPLICATION
Configure Streaming Replication
Create a Replication User
Stop and Start Replication
Physical Replication Slot Handling
Session 6: LOGICAL REPLICATION
Logical Replication Architecture
Features of Logical Replication
Advantages of Logical Replication
Limitations of Logical Replication
The CREATE PUBLICATION Command
The CREATE SUBSCRIPTION Command
Logical Replication Slot Handling
Our clients have included prestigious national organisations such as Oxford University Press, multi-national private corporations such as JP Morgan and HSBC, as well
as public sector institutions such as the Department of Defence and the Department of Health.