Study guide
EDB PostgreSQL Associate study guide
Read a lesson, then practice the ideas you want to remember.
Lessons
- Server Configuration Parameters — Free Study Guide 2026
- Database Clusters & Cluster Initialization
- Filesystem Layout, Service Control & Startup
- The PostgreSQL Server Process Model — Free Study Guide 2026
- Logical Backups with pg_dump & pg_dumpall
- Physical Base Backups with pg_basebackup
- Restoring Logical Backups — Free Study Guide 2026
- Write-Ahead Logging & Point-in-Time Recovery
- System Catalogs & Information Schema — Free Study Guide 2026
- Client & Server Command-Line Utilities — Free Study Guide 2026
- GUI Administration with pgAdmin — Free Study Guide 2026
- Interactive Command-Line Mastery with psql
- Client Authentication & pg_hba.conf Architec
- Managing Databases, Schemas & Tablespaces
- Roles, Privileges & Object Ownership — Free Study Guide 2026
- EDB PostgreSQL Associate Certification Overv
- The PostgreSQL Relational Model & Architectu
- Study Strategies, Lab Setup & Exam-Day Execu
- Failover, Switchover & High-Availability Des
- Replication Slots & Standby Management — Free Study Guide 2026
- Physical Streaming Replication Architecture
- Synchronous vs. Asynchronous Replication
- Analyzing Query Statistics & Reindexing
- High-Performance Data Loading & Data Movemen
- The PostgreSQL Vacuuming Engine & MVCC Space
- Query Execution Plans & Index Optimization
- Server Logging Configuration & Autovacuum Tu
- Server Memory Sizing & Core Performance Para
- Cumulative Statistics & Activity Monitoring
- Integrity Constraints & Data Validation
- Relational Data Types & Table Design — Free Study Guide 2026
- DML Operations, Transaction Control & MVCC M
- Querying, Joining & Aggregating Data — Free Study Guide 2026