A self-paced course built around RetailMart V3 — a production-grade Indian retail database with 16 schemas and 2.7 million rows. No cohort, no calendar — go at your own speed.
Watch the setup videos, install PostgreSQL locally, start at your own pace
Not toy databases. Not contrived examples. You work with a realistic business dataset from day one.
RetailMart V3 — 16 schemas, 55 tables, 2.7M rows. Customers, orders, inventory, HR, marketing, finance, and more.
INR pricing, GST calculations, Indian cities, payroll with PF and professional tax. Context you actually understand.
No live class, no batch schedule. Watch the setup videos, install locally, work through modules at your own speed.
Easy, Medium, Hard, Crazy — every topic ships with worked answers, validated against a real database.
From CREATE TABLE to window functions, CTEs, stored procedures, query optimization, and transaction isolation levels.
Every topic includes the kind of questions you get in data analyst, data engineer, and backend developer interviews.
From absolute beginner to writing complex analytical queries. No calendar — work through each module at your own speed.
Content is being built out module by module — see Status below for what's live now.
Every topic ships with Easy, Medium, Hard, and Crazy practice sets — each with a worked answer, all validated against a real RetailMart V3 instance before it ships.
Setup, onboarding, and a database walkthrough — watch these once, then you're ready for Module 1. No live class, no calendar.
Install PostgreSQL 18, pgAdmin 4, VS Code, Git — video coming soon
What RetailMart is and why it exists — video coming soon
Hands-on tour of the 16 schemas, 55 tables — video coming soon
This is the working example of the site's server-side access-code gate — the check runs on Cloudflare's edge, not in this page's own JavaScript, so it can't be bypassed by reading page source the way a client-side check can.
Honest status, not a promise — this is a from-scratch rebuild, not a copy of an old course. Each module goes from "planned" to "live" as it's actually authored and validated.
Structure locked, lecture content and practice sets in progress
16 schemas, 55 tables, ~2.7M rows — built and ready
The three videos everyone starts with
The finale: build a full analytics layer in SQL on RetailMart V3 — views, materialized views, JSON exports — then deploy it as a live, interactive dashboard. Coming with Module 6.