PostgreSQL for Administrators- Bespoke Certificate for Lance Evans

Certificate ID:

806831

Authentication Code:

4008d

Certified Person Name:

Lance Evans

Certified Person Email:

lance.evans@ato.gov.au

Trainer Name:

Michał Kuna

Duration Days:

3

Duration Hours:

21

Course Name:

PostgreSQL for Administrators- Bespoke

Course Date:

28 April 2025 09:00 to 30 April 2025 05:00

Course Outline:

PostgreSQL Administration

Architecture overview
Configuring the Server
Setting up and Managing Users
Setting Permissions & Security
Monitoring
Logs

Performance Optimization

Reducing I/O with HOT
Locking & Concurrency
Evaluating the Design of the Database
Optimizing SQL Queries with EXPLAIN
Inspecting the Workload
Benchmarking and Profiling
Query optimization
Using Indexes Efficiently / index types
Memory management
Extensions

PostgreSQL Replication & Backup & HA

Logical & Physical backups
PITR
Transactional Log archiving
Overview of PostgreSQL Replication
High Availability in PostgreSQL
Streaming Replication (sync / async)
Upgrading PostgreSQL

Certificate Sent:

Certificate Sent