Blog · Guide
What Is a SQL Table? (Columns, Rows, Keys)
A plain-English look at tables: named columns, one row per record, and why keys matter — with a simple shop example.
The spreadsheet mental model
If you already use Excel or Google Sheets, you’re 80% of the way there. A SQL table is a named grid: columns across the top, rows down the side. Each column has a name and a type of value (text, number, date…). Each row is one thing — one customer, one order, one product.
Why databases use many tables
You don’t paste a customer’s full name onto every order. You store a small id on the order, and keep names in a customers table. That keeps data consistent: change “Maya” once, every related order still points to the same person.
On SQL Practices we use one shop — Northstar Market — with four tables you’ll meet again and again: customers, orders, order_items, products.
Keys in one sentence
A primary key uniquely identifies a row (customer_id). A foreign key is a reference to another table’s key (orders.customer_id → customers.customer_id). JOINs use those links.
Try it yourself
The fastest way to lock this in is a short drill on the same Northstar Market tables.