PostgreSQL training & workshops
The best database environment is one your team understands & can operate confidently. Kangaroot delivers hands-on PostgreSQL workshops built around real scenarios, the tools, parameters & situations your team actually faces in production.
Sessions are tailored to your environment & team level. We come to you.
-
PostgreSQL Fundamentals
The right starting point for teams new to PostgreSQL or coming from a different database background.
- Architecture overview: client/server model, postmaster, background workers, autovacuum, memory structures (shared buffers, work_mem, WAL buffers)
- Installation & configuration: packages vs source, key parameters, directory layout
- SQL basics: data types (numeric, text, JSON, arrays), DDL/DML, constraints (PK, FK, CHECK, UNIQUE)
- Indexes: B-Tree, Hash, GIN, GiST, BRIN; when to use which & index-only scans
- Transactions & MVCC: ACID, snapshot isolation, visibility rules, vacuum basics
- Backup basics: pg_dump, pg_restore, logical vs physical backups
-
PostgreSQL Administration Essentials (1–2 days)
For DBA's & system administrators managing PostgreSQL in production.
- Cluster creation & management
- Roles & permissions
- Tablespaces
- Logging & monitoring
- Basic VACUUM & autovacuum tuning
- WAL concepts
- Extensions: uuid-ossp, pg_stat_statements & others
-
PostgreSQL Administration Advanced (2–3 days)
For experienced administrators ready to go deeper.
- Physical backups: pgBackRest, BaRMAN, PITR
- Replication: streaming replication, synchronous vs asynchronous, slot management
- Partitioning strategies
- Advanced security: SCRAM, SSL/TLS, row-level security
- Server parameter tuning: work_mem, maintenance_work_mem, effective_cache_size & more
-
PostgreSQL Performance Tuning
For teams that need to diagnose & fix performance problems & keep them fixed.
- Understanding the PostgreSQL optimizer: execution plans, cost model, join types, sequential vs index scans
- Index tuning: multi-column, partial, covering indexes; GIN/GiST for full-text search
- Query tuning patterns: anti-joins, EXISTS vs IN, window functions, aggregation strategies
- Memory tuning: work_mem, shared_buffers, effective_cache_size
- Storage tuning: autovacuum tuning, bloat detection, pg_repack
- WAL tuning: wal_level, wal_compression, checkpoint tuning
- Extensions & views: pg_stat_statements, pg_wait_sampling, pg_stat_activity
-
PostgreSQL High Availability & Disaster Recovery
For teams responsible for keeping PostgreSQL running & recoverable.
- Patroni, Etcd, Consul & DCS concepts
- Failover scenarios & switchover procedures
- Multi-node architectures
- DR strategy design & backup architecture
- Monitoring HA clusters: Prometheus, Grafana, Zabbix
-
PostgreSQL Development
For developers building on PostgreSQL; PL/pgSQL & advanced SQL.
- PL/pgSQL: functions & procedures, variables, loops, control structures, exception handling, trigger functions, performance considerations, security definer vs invoker
- Extensions: pgcrypto, pg_anonymize, hstore & others
- Advanced SQL: window functions, CTEs & recursive queries, JSON/JSONB manipulation, full-text search, UPSERT/MERGE patterns (INSERT … ON CONFLICT)
- Data modelling best practices
Frequently Asked Questions
-
Are sessions on-site or remote?
Both options are available. On-site sessions at your location tend to work better for hands-on workshops; we work directly in your environment.
-
Can you tailor the content to our stack?
Yes. Sessions are built around your environment, your tooling & the scenarios your team actually faces. We don't deliver off-the-shelf slide decks.
-
Do you offer certification preparation?
We focus on operational expertise rather than certification tracks. If certification preparation is a goal, let us know & we'll align the content accordingly.
-
Can multiple tracks be combined?
Yes. A common combination is Administration Essentials + Performance Tuning for DBA teams, or Fundamentals + Development for developer teams.