--- title: "Full Curriculum – All 38 Modules" id: "1393" type: "page" slug: "full-curriculum-all-38-modules" published_at: "2026-02-08T08:47:54+00:00" modified_at: "2026-02-20T16:46:28+00:00" url: "https://labs.postgreshelp.com/full-curriculum-all-38-modules/" markdown_url: "https://labs.postgreshelp.com/full-curriculum-all-38-modules.md" excerpt: "Complete Curriculum 45 Modules • 285+ Labs • 5,100+ Files • 5 Real Projects 18 Track 1 Modules 16 Track […]" --- # Complete Curriculum 45 Modules • 285+ Labs • 5,100+ Files • 5 Real Projects 18 Track 1 Modules 16 Track 2 Build Modules 19 Track 3 Advanced 285+ Labs 5 Projects ## Track 1: Core Operations — Hands-On Labs + Production Codebases (Modules 1-18) 4-6 Weeks • ₹20,000 • Target: Mid-Level DBA (₹18-30 LPA) Phase 1: ProductionDB (E-commerce DBA) M01**PostgreSQL Fundamentals** – Architecture, installation, psql, data types📁 4 filesM02**SQL Mastery** – CTEs, window functions, recursive queries, JSON📁 5 filesM03**Spring Boot + PostgreSQL** – JPA, HikariCP, transactions📁 4 filesM04-06**SampleBank v1-v3** – Registration, authentication, transactions📁 35 filesM07**Terraform + AWS RDS** – Infrastructure-as-Code deployment📁 15 filesPhase 2: BankForge Core (~100 Files) M08**Monitoring & Observability** – Prometheus, Grafana, alerting📁 2,968 filesM09**Backup & Recovery** – pg_dump, WAL archiving, PITR📁 14 filesM10**High Availability** – Streaming replication, Patroni, failover📁 14 filesM11**Performance Tuning** – EXPLAIN, indexes, vacuum, memory📁 41 filesPhase 3: BankForge-DBA-Operations M12**CI/CD & GitHub Actions** – Automated testing, migrations📁 24 filesM13**Security & Access Control** – RLS, SSL/TLS, hardening📁 22 filesM14**Advanced Features** – Partitioning, FDW, logical replication📁 31 filesM15**Troubleshooting** – Lock analysis, bloat, incident response📁 33 filesPhase 4: BankForge-AI (pgvector + ML) M16**Capstone: Production Deployment** – Full SampleBank launch📁 79 filesM17***Automation Scripts** – 125 production-ready scripts📁 149 filesM18***PostgreSQL Internals** – Source code, C extensions📁 19 files MOST POPULAR## Track 2: Production DBRE — BUILD SampleBank (16 Modules) 12 Weeks • ₹35,000 • Includes Track 1 • Target: Senior DBA (₹30-45 LPA) **Phase 1:** All of Track 1 content (18 modules) — ProductionDB practicals + BankForge study Phase 2: BUILD SampleBank From Scratch (Weeks 3-12) You rebuild SampleBank from zero — designing the schema, writing the app, deploying to AWS, and adding enterprise monitoring. Uses same Modules 01-16 but now you’re BUILDING, not studying. Week 3-4**Schema Design & Core App** – Customer registration, accounts, authWeek 5-6**Transactions & Deployment** – Fund transfers, Terraform, AWS RDSWeek 7-8**Monitoring & HA** – Prometheus/Grafana, Patroni, backupWeek 9-10**Security & Performance** – RLS, indexes, query optimizationWeek 11-12**CI/CD & Production Launch** – GitHub Actions, capstone deployment BEST VALUE## Track 3: Staff DBRE Mastery — Advanced Modules (M19-M45) 22 Weeks • ₹55,000 • Includes Track 1 & 2 • Target: Staff Engineer (₹50-65 LPA) **Phase 1 & 2:** All of Track 2 content (study projects + build SampleBank) Phase 3: Advanced Modules (Weeks 13-22) M19**Zero-Downtime Migrations** – Billion-row table changes📁 136 filesM20**Scale to 100K TPS** – PgBouncer, Citus, read replicas📁 23 filesM21**Team Leadership** – Runbooks, CAB, on-call, SLOs📁 47 filesM22**Kubernetes PostgreSQL** – 38 labs, Zalando, Helm, Velero📁 150+ filesM23**FinOps & Cost Reduction** – 40%+ savings strategies📁 14 filesM24**Multi-Tenant SaaS** – RLS, tenant isolation, scaling📁 39 filesM25**Staff-Level System Design** – 20 company case studies📁 22 filesM26**Polyglot Persistence** – Redis, Elasticsearch, Kafka📁 22 filesM27**Career Capstone** – Portfolio, interviews, salary📁 48 filesM36**PostgreSQL Replaces Everything** – pg_trgm, pgmq, pg_cron, Apache AGE, BM25 search📁 25 filesM37**DBA Power Tools & Analytics** – HypoPG, pg_duckdb, Debezium CDC, pg_stat_monitor📁 25 filesM38**MySQL & SQL Server to PostgreSQL** – pgloader, sqlserver2pgsql, complete migration labs📁 22 filesM40**Interview Preparation Mastery** – 50+ technical interview questions, 10 system design scenarios, 20 behavioral questions (STAR method), mock interview practice, live troubleshooting exercises📁 35 filesM41**Soft Skills for DBAs** – Stakeholder communication, incident communication, documentation best practices, team collaboration, 8 real-world scenarios📁 28 filesM42**PostgreSQL Certification Preparation** – EDB Postgres Certification (Associate + Professional), AWS Database Specialty Certification, 100+ practice exam questions, study plans (30/60/90 day), hands-on certification labs📁 42 filesM43**PostgreSQL Real-Time Streaming & CDC** – Change Data Capture (CDC) with Debezium, Kafka Integration & Event Streaming, Logical Decoding & wal2json, Event-Driven Architectures (Event Sourcing, CQRS), Real-Time Analytics Pipelines, 3 Docker-based Labs (Debezium+Kafka, Event-Sourced SampleBank, Real-time Dashboard)📁 38 filesM44**Database-First API Development** – PostgREST Instant REST APIs, Hasura GraphQL Engine & Real-Time Subscriptions, Row-Level Security (RLS) for API Access, JWT Authentication & API Security, API Performance Optimization (7x improvement), 3 Production Labs (PostgREST SampleBank, Hasura Deployment, Performance Tuning)📁 45 filesM45**Database DevOps & CI/CD** – Schema Version Control with Git, Migration Tools (Flyway, Liquibase, Alembic, Atlas), Complete CI/CD Pipelines (GitLab CI, GitHub Actions, Jenkins), Automated Database Testing, Zero-Downtime Deployments, Blue-Green & Canary Strategies, Rollback Automation, 4 Production Labs (AWS CodePipeline, Azure DevOps, Docker+GitLab, SampleBank CI/CD)📁 10 files ## Bonus: 6 Prerequisites (Included Free) Linux, Docker, Git, Networking, SQL Refresher, Cloud Basics All tracks include 6 prerequisite modules to ensure you have the foundation needed: Linux CLI, Docker & containers, Git version control, networking basics, SQL refresher, and cloud platform orientation. ## Ready to Master PostgreSQL? 42 modules. 272+ labs. 5 real projects. Choose your track. [View Pricing & Enroll](#pricing)