---
title: "PostgreSQL Samplebank project"
id: "1471"
type: "page"
slug: "postgresql-samplebank-project"
published_at: "2026-02-08T10:19:03+00:00"
modified_at: "2026-02-08T10:21:43+00:00"
url: "https://labs.postgreshelp.com/postgresql-samplebank-project/"
markdown_url: "https://labs.postgreshelp.com/postgresql-samplebank-project.md"
excerpt: "5 REAL-WORLD PROJECTS Learn with Production Applications 1 hands-on practical course (ProductionDB) + 3 production codebases to review + 1 […]"
---

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](#enroll)