SQLearnAcademy

← Learn/Part 1 · Query basics

Module 00

Foundations: thinking in data

Before writing any SQL, it helps to see the world as a set of entities and facts about them. In this module you meet the products table of the GadgetHub store and learn to think in rows and columns.

0 / 8 lessonsStart module

Lessons8 lessons

  1. 01

    Now

    What data is and why we store it in tables

    Your first day at GadgetHub — a small online store the founder opened a year ago, right out of their own apartment. Back then it saw a couple of orders a week, and they kept track of products in a plain text file. Now the store is growing — and there's no finding anything in that file anymore. The founder asks you to sort it out.

    Start
  2. 02Database and DBMS: what's the difference
  3. 03The relational model: tables, rows, columns
  4. 04Your first query: meet the sandbox
  5. 05Data types: why they matter
  6. 06The primary key: how to tell rows apart
  7. 07NULL: when there's no value
  8. 08Recap: how our database will grow along with you