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.

first_name city age Maya Austin 29 Luis Chicago 41
Columns = named fields. Rows = one record each.

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.

See a table in practice

Related guides