Complete Curriculum
45 Modules • 285+ Labs • 5,100+ Files • 5 Real 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)
| 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 |
| 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 |
| 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 |
| 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 |
Track 2: Production DBRE — BUILD SampleBank (16 Modules)
12 Weeks • ₹35,000 • Includes Track 1 • Target: Senior DBA (₹30-45 LPA)
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 |
Track 3: Staff DBRE Mastery — Advanced Modules (M19-M45)
22 Weeks • ₹55,000 • Includes Track 1 & 2 • Target: Staff Engineer (₹50-65 LPA)
| 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