Tables, Rows and Columns
A database is a set of tables.
If you've ever used a spreadsheet, you already understand most of a database. A database is just a collection of tables. And a table looks exactly like a spreadsheet, with columns across the top and rows going down.

- You already know spreadsheets
- A database is a set of tables
- Each table looks like a sheet
The books table
Here's one table from Helen's shop, called books. Each column holds one kind of information, like the title, the author, or the price. Each row is one book. So this row says that The Silent Orchard, by Mira Hale, is a mystery that costs fourteen ninety nine. That's all a table is.
| book_id | title | author | genre | price |
|---|---|---|---|---|
| 1 | The Silent Orchard | Mira Hale | Mystery | 14.99 |
| 2 | Code of the River | Tom Avery | Thriller | 12.99 |
| 3 | Stars Over Lagos | Ada Obi | Romance | 9.99 |
| 4 | A Short History of Bread | Lena Fox | History | 19.99 |
Three words to remember
Let's lock in three words. A table is a list of one kind of thing, like books or customers. A column is one piece of information about each thing, like the price. And a row is one single thing, like one book. You'll hear these words in every lesson.
| key | value |
|---|---|
| Table | a list of one kind of thing |
| Column | one piece of information |
| Row | one single thing |
Helen's five tables
Helen's database has five tables. Customers, with five hundred people who've signed up. Books, with the thirty titles she sells. Orders, with one row for every order placed. Order items, which lists the books inside each order. And staff, with the eight people who work there. Over the course, you'll use every one of them.
Summary
A database is a set of tables, and each table has columns and rows. Now let's get SQL running on your computer, so you can follow along.
Key takeaways- Tables hold one kind of thing
- Columns are details
- Rows are single items