PostgreSQL Production Labs · June 2026 Batch
Day-by-Day Curriculum Comparison
Every session across all four tracks, mapped side-by-side — so you know exactly what you're getting and when.
T1 · Foundations
T2 · Production Engineering
T3 · Platform Engineering
T4 · Professional Branding
Key
Shared across tracks
Track-exclusive session
Not in this track
| # | Track 1 — Foundations₹15,000 · ~42 sessions | Track 2 — Production Engg₹20,000 · 40 sessions | Track 3 — Platform Engg₹20,000 · 30 days | Track 4 — Professional Branding₹25,000 · ~43 sessions |
|---|---|---|---|---|
| Phase 1 — Linux & OS Foundations · Track 1 Only | ||||
| 01 | OS Installation — Ubuntu & OEL T1 Only | — | — | — |
| 02 | Linux Fundamentals — cp, mv, grep, df, tail, systemctl, wget, dnf, vi T1 Only | — | — | — |
| 03 | Networking Fundamentals — IP Addressing, CIDR, Subnets, DNS, Public vs Private T1 Only | — | — | — |
| 04 | Database Fundamentals — OLTP vs OLAP, SQL Basics, PL/pgSQL Basics T1 Only | — | — | — |
| 05 | Production Environments — DEV, UAT, STAGE, PROD explained T1 Only | — | — | — |
| 06 | OS-Level Monitoring — top, ps, OS logs, iostat, vmstat, sar T1 Only | — | — | — |
| Phase 2 — PostgreSQL Core: Architecture, Config & Security · Shared: T1, T2, T4 | ||||
| 07 | Why PostgreSQL — History, MVCC, WAL, Architecture Overview Shared | Why PostgreSQL Shared | — | Why PostgreSQL Shared |
| 08 | Connection Establishment — The postmaster process Shared | Connection Establishment — postmaster process Shared | — | Connection Establishment Shared |
| 09 | ACID Properties — Transactions, isolation, atomicity in depth Shared | ACID Properties — Transactions, isolation levels Shared | — | ACID Properties Shared |
| 10 | Installation Part 1 — Source Code, RPM, YUM Installations Shared | Installation Part 1 — Source Code, RPM, YUM Shared | — | Installation Part 1 Shared |
| 11 | Installation Part 2 — Extensions, Devel Module Shared | Installation Part 2 — Extensions, Devel Module Shared | — | Installation Part 2 Shared |
| 12 | Installation Part 3 — PostgreSQL on Ubuntu, EDB, Percona Distribution Shared | Installation Part 3 — Ubuntu, EDB, Percona Shared | — | Installation Part 3 Shared |
| 13 | Architecture — The CRUD Workflow end to end Shared | Architecture — CRUD Workflow end to end Shared | — | Architecture — CRUD Workflow Shared |
| 14 | Logger Process — How PostgreSQL logging works Shared | Logger Process Shared | — | Logger Process Shared |
| 15 | Autovacuum Process Part 1 — What it does and why it matters Shared | Autovacuum Part 1 Shared | — | Autovacuum Part 1 Shared |
| 16 | Autovacuum Process Part 2 — Tuning autovacuum parameters Shared | Autovacuum Part 2 — Tuning parameters Shared | — | Autovacuum Part 2 Shared |
| 17 | Autovacuum Process Part 3 — Bloat detection and remediation Shared | Autovacuum Part 3 — Bloat detection Shared | — | Autovacuum Part 3 Shared |
| 18 | Post-Installation Steps — pg_hba.conf, authentication setup Shared | Post-Installation — pg_hba.conf, SCRAM-SHA-256 auth Shared | — | Post-Installation (pg_hba.conf) Shared |
| 19 | Parameter Tuning Part 1 — postgresql.conf memory & performance Shared | Parameter Tuning Part 1 — shared_buffers, work_mem Shared | — | Parameter Tuning Part 1 Shared |
| 20 | Parameter Tuning Part 2 — WAL, checkpoint, planner settings Shared | Parameter Tuning Part 2 — WAL, checkpoint, planner Shared | — | Parameter Tuning Part 2 Shared |
| 21 | psql — Command-line mastery for DBAs Shared | psql — meta-commands, scripting, debugging Shared | — | psql Shared |
| 22 | Datafiles — Physical structure, data directory layout Shared | Datafiles — Physical structure, page internals Shared | — | Datafiles Shared |
| 23 | WAL Files — Write-Ahead Logging internals and management Shared | WAL Files — WAL internals and management Shared | — | WAL Files Shared |
| 24 | User Administration Part 1 — Roles, users, privileges Shared | User Administration Part 1 — Roles, users, object privileges Shared | — | User Administration Part 1 Shared |
| 25 | User Administration Part 2 — RBAC, row-level security Shared | User Administration Part 2 — RBAC, RLS, best practices Shared | — | User Administration Part 2 Shared |
| Phase 3 — Backup, Recovery & Replication · Shared: T1, T2, T4 | ||||
| 26 | Logical Backups — pg_dump, pg_dumpall, restore strategies Shared | Logical Backups — pg_dump, pg_dumpall, restore Shared | — | Logical Backups Shared |
| 27 | Backup and Recovery Part 1 — pg_basebackup, WAL archiving Shared | Backup & Recovery Part 1 — pg_basebackup, WAL archiving Shared | — | Backup & Recovery Part 1 Shared |
| 28 | Backup and Recovery Part 2 — Point-in-Time Recovery (PITR) hands-on Shared | Backup & Recovery Part 2 — PITR hands-on Shared | — | Backup & Recovery Part 2 (PITR) Shared |
| 29 | Replication Part 1 — Streaming replication setup, sync vs async Shared | Replication Part 1 — Streaming replication, sync vs async Shared | — | Replication Part 1 Shared |
| 30 | Replication Part 2 — Monitoring and troubleshooting replication Shared | Replication Part 2 — Monitoring, slots, troubleshooting lag Shared | — | Replication Part 2 Shared |
| 31 | PgPool-II & PgBouncer — Connection pooling and load balancing Shared | PgPool-II & PgBouncer — Pool modes, load balancing Shared | — | PgPool & PgBouncer Shared |
| 32 | Patroni — Automatic failover and HA cluster setup Shared | Patroni — Automatic failover, etcd, HA cluster Shared | — | Patroni Shared |
| 33 | Grafana — Monitoring dashboards for PostgreSQL Shared | Grafana — Monitoring dashboards and alerting Shared | — | Grafana Shared |
| Phase 4 — Cloud, Advanced HA & Performance · T2 Exclusive + T4 Partial | ||||
| 34 | — | AWS Part 1 — Infrastructure Setup, VPC, Security Groups for RDS T2 Only | — | — |
| 35 | — | AWS Part 2 — RDS Administration, Parameter Groups, Snapshots, Multi-AZ T2 Only | — | — |
| 36 | — | AWS Part 3 — Migrations to RDS/Aurora using DMS and ora2pg T2 Only | — | — |
| 37 | — | HA Deep Dive — Patroni Internals, HAProxy, Failover & Switchover T2 Only | — | — |
| 38 | — | Performance Engineering — Query Tuning, Wait Events, Lock Analysis T2 Only | — | Performance Engineering — Query Tuning, Wait Events, Lock Analysis Shared |
| Phase 5 — Advanced Maintenance & Upgrades · Shared: T1, T2, T4 | ||||
| 39 | Upgradation and Logical Replication — pg_upgrade, major version upgrades Shared | Upgradation and Logical Replication — pg_upgrade Shared | — | Upgradation & Logical Replication Shared |
| 40 | PT: pgBadger — Log analysis and query performance reporting Shared | PT: pgBadger — Log analysis, slow query reporting Shared | — | PT: pgBadger Shared |
| 41 | — | PT: Index Strategies & Partitioning — B-tree, GIN, BRIN, partial indexes T2 Only | — | — |
| Phase 6 — DevOps, AI & SRE · T2 Exclusive | ||||
| 42 | — | DevOps for DBA — Git, Jenkins, Terraform Workflows T2 Only | — | — |
| 43 | — | AI for DBA — pgvector, LLM integration, AI-powered database tools T2 Only | — | — |
| 44 | — | SRE for DBA — Reliability engineering, SLOs, incident management T2 Only | — | — |
| 45 | — | Certification Questions & Job Description Discussion — EDB, AWS DB Specialty T2 Only | — | — |
| 46 | — | Conclusion — Recap, next steps, community, what to build next T2 Only | — | — |
| Track 3 — Platform Engineering (Standalone 30-Day Track) | ||||
| T3·1 | — | — | Oracle → PostgreSQL Migration Day 1 — Schema conversion with ora2pg T3 Only | — |
| T3·2 | — | — | Oracle Migration Day 2 — PL/SQL to PL/pgSQL conversion patterns T3 Only | — |
| T3·3 | — | — | Oracle Migration Day 3 — Data migration using AWS DMS T3 Only | — |
| T3·4 | — | — | Oracle Migration Day 4 — Data type mapping and handling exceptions T3 Only | — |
| T3·5 | — | — | Oracle Migration Day 5 — Validation, cutover & post-migration tuning T3 Only | — |
| T3·6 | — | — | AWS Aurora Day 1 — Aurora architecture vs RDS PostgreSQL T3 Only | — |
| T3·7 | — | — | AWS Aurora Day 2 — Cluster setup, parameter groups, endpoints T3 Only | — |
| T3·8 | — | — | AWS Aurora Day 3 — Multi-AZ and read replica configuration T3 Only | — |
| T3·9 | — | — | AWS Aurora Day 4 — Automated backups, PITR, and snapshot restore T3 Only | — |
| T3·10 | — | — | AWS Aurora Day 5 — Performance Insights and monitoring T3 Only | — |
| T3·11 | — | — | Terraform Day 1 — Modules for VPC, subnets, security groups T3 Only | — |
| T3·12 | — | — | Terraform Day 2 — RDS & Aurora provisioning with Terraform T3 Only | — |
| T3·13 | — | — | Terraform Day 3 — Parameter groups, IAM, and secrets management T3 Only | — |
| T3·14 | — | — | End-to-End Project Day 1 — Architecture design and planning T3 Only | — |
| T3·15 | — | — | End-to-End Project Day 2 — Deploy full stack: app + PostgreSQL + cloud T3 Only | — |
| T3·16 | — | — | End-to-End Project Day 3 — Documentation, runbook, and portfolio delivery T3 Only | — |
| T3·17 | — | — | Python for DBAs Day 1 — psycopg2: connecting and querying PostgreSQL T3 Only | — |
| T3·18 | — | — | Python for DBAs Day 2 — Automation scripts: backup, maintenance, alerts T3 Only | — |
| T3·19 | — | — | Grafana Observability Day 1 — Prometheus + Grafana stack for PostgreSQL T3 Only | — |
| T3·20 | — | — | Grafana Observability Day 2 — Alerting rules and on-call notification setup T3 Only | — |
| T3·21 | — | — | Engineering Case Study 1 — Uber MVCC: why they migrated from PostgreSQL T3 Only | — |
| T3·22 | — | — | Engineering Case Study 2 — OpenAI + PgBouncer: scaling connection management T3 Only | — |
| T3·23 | — | — | Engineering Case Study 3 — Real production outages: replication & storage T3 Only | — |
| T3·24 | — | — | Docker Day 1 — Containerizing PostgreSQL with Docker T3 Only | — |
| T3·25 | — | — | Docker Day 2 — Docker Compose, persistent storage, networking & backup T3 Only | — |
| T3·26 | — | — | Kubernetes Day 1 — Deploying PostgreSQL on K8s: StatefulSets & PVCs T3 Only | — |
| T3·27 | — | — | Kubernetes Day 2 — PostgreSQL Operators (Zalando, CloudNativePG) T3 Only | — |
| T3·28 | — | — | Advanced Architecture Day 1 — Multi-region HA design T3 Only | — |
| T3·29 | — | — | Advanced Architecture Day 2 — Connection pooling at scale with PgBouncer T3 Only | — |
| T3·30 | — | — | Advanced Architecture Day 3 — Disaster recovery planning and runbooks T3 Only | — |
| Track 4 — Professional Brand, Deep Internals & Community · T4 Exclusive Sessions | ||||
| T4·31 | — | — | — | LinkedIn Optimization — DBA expert profile that attracts opportunities T4 Only |
| T4·32 | — | — | — | GitHub Profile Optimization — Showcasing technical work, labs & contributions T4 Only |
| T4·33 | — | — | — | Case Study 1 — Uber MVCC: why Uber migrated away from PostgreSQL T4 Only |
| T4·34 | — | — | — | Case Study 2 — OpenAI + PgBouncer: scaling connection management T4 Only |
| T4·35 | — | — | — | Case Study 3 — Real Production Outages: replication failures & storage exhaustion T4 Only |
| T4·36 | — | — | — | MVCC Internals — Tuple versions, dead tuples, visibility rules T4 Only |
| T4·37 | — | — | — | Locking & Concurrency — Lock types, deadlock analysis, pg_locks in production T4 Only |
| T4·38 | — | — | — | WAL Internals — What every byte means, LSN tracking, WAL compression T4 Only |
| T4·39 | — | — | — | Replication Internals — Synchronous commit edge cases & failure analysis T4 Only |
| T4·40 | — | — | — | AI & Agentic Workflows for Database Engineering T4 Only |
| T4·41 | — | — | — | Technical Writing & Presentation Skills — Postmortems, architecture docs, blog posts T4 Only |
| T4·42 | — | — | — | PostgreSQL Source Code Concepts — Reading the codebase, extension APIs T4 Only |
| T4·43 | — | — | — | Open Source & Community Contributions — Contributing to PostgreSQL, extensions & docs T4 Only |
| Career Preparation · Track 1 Exclusive | ||||
| CP·1 | LinkedIn Optimization — DBA-specific profile & visibility T1 Only | — | — | — |
| CP·2 | GitHub Profile Optimization — Showcasing your labs & scripts T1 Only | — | — | — |
| CP·3 | Resume Optimization — DBA resume that gets interviews T1 Only | — | — | — |
| CP·4 | Mock Interviews — Live technical interview practice T1 Only | — | — | — |
| CP·5 | Weekly Real-Time Assignments — Recurring practical assignments T1 Only | — | — | — |
| CP·6 | Knowledge Sharing Sessions (KSS) — Present and teach to solidify learning T1 Only | — | — | — |
| CP·7 | Documentation Review — RFP, SOP, Escalation Matrix real-world docs T1 Only | — | — | — |