Day 1 of 45 · SQL Masterclass · Free
Day 1: SQL Foundations
Create the core ShopKart customer, order, product, and payment tables and solve 30 foundation queries against them.
About 60 minutes of learning and 90 minutes of practice. It runs in your browser, with no install.
What you will be able to do
- Explain physical relational storage: tables, rows, columns, primary keys, and foreign keys.
- Predict the exact logical execution order of SQL clauses from FROM through LIMIT.
- Write filtered and transformed SELECT queries handling three-valued NULL logic safely.
What the day covers
SELECT, WHERE, ORDER BY, DISTINCT, LIMIT, aliases, NULL, CASE, CAST, basic functions, why the database executes clauses in a fixed logical order.
What you build
customers, orders, products, and payments tables. Solve 30 queries against them.
Questions you should be able to answer afterwards
- In what logical order does a database execute the clauses of a standard SELECT query?
- Why does `WHERE column = NULL` always evaluate to UNKNOWN/false in SQL?
- What is the difference between a natural key and a primary key?
Practice this day's skills
Each page shows the idea moving, then lists problems from easiest.
Days 1 to 7 are free. Days 8 to 45 need a pass; the plan page lists what each day covers, and the glossary defines each term.