5 REAL-WORLD PROJECTS

Learn with Production Applications

1 hands-on practical course (ProductionDB) + 3 production codebases to review + 1 app you build from scratch. Not toy examples—real banking and e-commerce applications.

Why Learn with Real Applications?

Generic SQL exercises don't prepare you for production. With these 5 projects, you'll face real challenges: handling concurrent transactions, designing for scale, implementing security controls, and troubleshooting actual performance issues.

PROJECT 1 — ALL TRACKS — HANDS-ON PRACTICAL

ProductionDB (E-commerce DBA)

Modules 01-07

Your first production project: a complete e-commerce database with real DBA operations.

✓ PostgreSQL architecture & psql

✓ SQL mastery (CTEs, window functions)

✓ Spring Boot + JPA integration

✓ Patroni automatic failover

✓ pgBackRest enterprise backups

✓ Streaming & logical replication

✓ Terraform + AWS RDS deployment

✓ ora2pg (Oracle to PostgreSQL)

PROJECT 2 — ALL TRACKS

BankForge Core (~100 Files)

Modules 08-11

A complete banking application with ~100 production files. Review monitoring, backup, HA, and performance patterns.

✓ Prometheus + Grafana monitoring

✓ Backup & disaster recovery

✓ High availability (Patroni)

✓ EXPLAIN plan analysis

✓ Performance Lab: 6 index types

✓ Admin dashboard & analytics

PROJECT 3 — ALL TRACKS

BankForge-DBA-Operations

Modules 12-15

Hands-on DBA labs with stored procedures, triggers, maintenance automation, and troubleshooting.

✓ CI/CD with GitHub Actions

✓ Security & Row-Level Security

✓ Partitioning & FDW

✓ VACUUM/ANALYZE monitoring

✓ Bloat detection & remediation

✓ Lock analysis & troubleshooting

PROJECT 4 — ALL TRACKS

BankForge-AI (pgvector + ML)

Modules 16-18

AI-powered banking features with pgvector, embeddings, semantic search, and RAG chatbot integration.

✓ pgvector integration

✓ AI-powered banking chatbot

✓ Fraud detection with ML

✓ Transaction similarity search

✓ FAQ embeddings (OpenAI)

✓ Production capstone deployment

PROJECT 5 — TRACK 2 & 3 ONLY

SampleBank v4.5 (YOU BUILD)

YOU BUILD THIS

The crown jewel: you build a complete production-grade banking application from scratch, deploy to AWS, and add enterprise monitoring.

✓ Design complete schema

✓ Spring Boot + PostgreSQL app

✓ Customer, accounts, transactions

✓ Deploy to AWS (Terraform)

✓ Prometheus + Grafana monitoring

✓ CI/CD with GitHub Actions

✓ Multi-tenant architecture

✓ Enterprise security (RLS, audit)

SampleBank Database Schema

customers

        customer_id SERIAL PK

        first_name VARCHAR(50)

        last_name VARCHAR(50)

        email VARCHAR(100) UNIQUE

        pan_number VARCHAR(10)

        kyc_status VARCHAR(20)

        tenant_id INT FK

accounts

        account_id SERIAL PK

        customer_id INT FK

        account_number VARCHAR(20)

        account_type VARCHAR(20)

        balance DECIMAL(15,2)

        status VARCHAR(20)

        opened_at TIMESTAMPTZ

transactions

        transaction_id UUID PK

        account_id INT FK

        transaction_type VARCHAR(20)

        amount DECIMAL(15,2)

        balance_after DECIMAL(15,2)

        status VARCHAR(20)

        created_at TIMESTAMPTZ

Built for Indian Banking Context

✓ UPI payment integration

✓ NEFT/RTGS/IMPS handling

✓ PAN/Aadhaar validation

✓ RBI compliance patterns

✓ GST invoice generation

✓ Multi-city branch data

Build Real Production Software

5 projects you can show employers—not just certificates

Start Building Today