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 files
M02 SQL Mastery – CTEs, window functions, recursive queries, JSON 📁 5 files
M03 Spring Boot + PostgreSQL – JPA, HikariCP, transactions 📁 4 files
M04-06 SampleBank v1-v3 – Registration, authentication, transactions 📁 35 files
M07 Terraform + AWS RDS – Infrastructure-as-Code deployment 📁 15 files
Phase 2: BankForge Core (~100 Files)
M08 Monitoring & Observability – Prometheus, Grafana, alerting 📁 2,968 files
M09 Backup & Recovery – pg_dump, WAL archiving, PITR 📁 14 files
M10 High Availability – Streaming replication, Patroni, failover 📁 14 files
M11 Performance Tuning – EXPLAIN, indexes, vacuum, memory 📁 41 files
Phase 3: BankForge-DBA-Operations
M12 CI/CD & GitHub Actions – Automated testing, migrations 📁 24 files
M13 Security & Access Control – RLS, SSL/TLS, hardening 📁 22 files
M14 Advanced Features – Partitioning, FDW, logical replication 📁 31 files
M15 Troubleshooting – Lock analysis, bloat, incident response 📁 33 files
Phase 4: BankForge-AI (pgvector + ML)
M16 Capstone: Production Deployment – Full SampleBank launch 📁 79 files
M17* Automation Scripts – 125 production-ready scripts 📁 149 files
M18* 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, auth
Week 5-6 Transactions & Deployment – Fund transfers, Terraform, AWS RDS
Week 7-8 Monitoring & HA – Prometheus/Grafana, Patroni, backup
Week 9-10 Security & Performance – RLS, indexes, query optimization
Week 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 files
M20 Scale to 100K TPS – PgBouncer, Citus, read replicas 📁 23 files
M21 Team Leadership – Runbooks, CAB, on-call, SLOs 📁 47 files
M22 Kubernetes PostgreSQL – 38 labs, Zalando, Helm, Velero 📁 150+ files
M23 FinOps & Cost Reduction – 40%+ savings strategies 📁 14 files
M24 Multi-Tenant SaaS – RLS, tenant isolation, scaling 📁 39 files
M25 Staff-Level System Design – 20 company case studies 📁 22 files
M26 Polyglot Persistence – Redis, Elasticsearch, Kafka 📁 22 files
M27 Career Capstone – Portfolio, interviews, salary 📁 48 files
M36 PostgreSQL Replaces Everything – pg_trgm, pgmq, pg_cron, Apache AGE, BM25 search 📁 25 files
M37 DBA Power Tools & Analytics – HypoPG, pg_duckdb, Debezium CDC, pg_stat_monitor 📁 25 files
M38 MySQL & SQL Server to PostgreSQL – pgloader, sqlserver2pgsql, complete migration labs 📁 22 files
M40 Interview Preparation Mastery – 50+ technical interview questions, 10 system design scenarios, 20 behavioral questions (STAR method), mock interview practice, live troubleshooting exercises 📁 35 files
M41 Soft Skills for DBAs – Stakeholder communication, incident communication, documentation best practices, team collaboration, 8 real-world scenarios 📁 28 files
M42 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 files
M43 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 files
M44 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 files
M45 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
Scroll to Top