PostgreSQL for Administrators- Bespoke Certificate for Lance Evans
Add to LinkedIn
Certificate ID:
806831
Authentication Code:
4008d
Certified Person Name:
Lance Evans
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