PostgreSQL 18 · Self-Paced

Master SQL with
Real-World Data

A self-paced course built around RetailMart — a production-grade Indian retail database with 16 schemas and 24 lakh rows. No cohort, no calendar — go at your own speed.

Try SQL in your browser right now, no install. Then set up your own machine and learn at your own pace

Built for Real-World SQL Skills

Not toy databases. Not contrived examples. You work with a realistic business dataset from day one.

Production-Grade Database

RetailMart — 16 schemas, 55 tables, 24 lakh rows. Customers, orders, inventory, HR, marketing, finance, and more.

Indian Business Context

INR pricing, GST calculations, Indian cities, payroll with PF and professional tax. Context you actually understand.

Self-Paced, No Calendar

No live class, no batch schedule. Follow Get Started, set up on your own machine, then work through the modules at your own speed.

4-Tier Practice Sets

Easy, Medium, Hard, Crazy — every topic ships with worked answers, validated against a real database.

Beginner to Advanced

From CREATE TABLE to window functions, CTEs, stored procedures, query optimization, and transaction isolation levels.

Interview Ready

Every topic includes the kind of questions you get in data analyst, data engineer, and backend developer interviews.

core
products
stores
customers
sales
finance
hr
marketing
support
web_events
supply_chain
loyalty
manufacture
payroll
call_center
audit

60 Topics, Interview Prep & Projects, Self-Paced

From absolute beginner to writing complex analytical queries. No calendar — work through each module at your own speed.

MODULE 1
Foundations
MODULE 2
Querying & Aggregation
MODULE 3
Subqueries, CTEs & Database Concepts
MODULE 4
Window Functions & Performance
MODULE 5
Analytics Power Tools & Programmable SQL
MODULE 6
Analyst Patterns
Beyond the 60 topics — not required, not counted as a module
MODULE 7
Interview Preparation
MODULE 8
Projects

Content is being built out module by module — see Status below for what's live now.

400 Questions Per Session

Every live class gets its own practice page on RetailMart: 100 Easy, 100 Medium, 100 Hard and 100 Crazy hard questions in small sets. Write the query, run it on the page, press Check. Each page opens after its class. The older topic-wise bank (11,200 questions, questions only) is a free download on the practice page.

Open practice

Easy
Core syntax from the class, applied directly
Medium
Combined with what you've already learned, real multi-step reasoning
Hard
Interview-grade — efficient, correct under edge cases
Crazy Hard
Staff-engineer level — production scenarios, optimization

Get Started

Five steps to do once, in order. Then you're ready for Module 1. No live class, no calendar.

Not ready to install? Try these first

Want a quick taste first? Try the in-browser playground →

The full RetailMart database, running as real PostgreSQL in your browser. Just a taste: the real practice is on your own machine.

Skip the tour, browse it yourself →

The interactive database explorer: click through real sample rows and a map of how each table connects — works right now, no sign-in

Built Module By Module

Honest status, not a promise. Each module goes from "planned" to "live" as it's actually authored and validated.

Ship a Real Analytics Dashboard

Project 1: build a full analytics layer in SQL on RetailMart — views, materialized views, JSON exports — then deploy it as a live, interactive dashboard. Coming with Module 8.

Download Project (ZIP) — Coming with Module 8