Where Data Lives: Databases Explained

Taught by Pip

Welcome aboard

Ahoy — Pip here, your lighthouse keeper. If you've ever kept a list in a spreadsheet, you already understand more about databases than you think. A database is just a tidier, sturdier place to keep your stuff — one built to hold a lot of it and to find any single piece in a blink.

In these eight short lessons we'll start where you already live, in rows and columns, and walk gently toward the ideas that make databases powerful: tables that don't repeat themselves, keys that name each thing exactly, relationships that link them, and a plain request called a query that fetches just what you asked for.

No code to memorize, no jargon for its own sake. Just a clear map of where your data lives and how it's found. Let's cast off. 🔦

1. A Spreadsheet Is Already a Database Free previewA spreadsheet and a database are cousins — one thing per row, one fact per column. Meet the strains the rest of this course will fix.
2. Tables, Rows, and Columns 🔒The three words that hold up every database — what a table, a row, and a column each are, in plain English.
3. The Trouble With Repeating Yourself 🔒When the same fact lives in many places, it goes wrong in all but one. Here's the headache databases are built to cure.
4. Keys — Giving Everything a Name 🔒A key is the unique tag that names one row and no other. It's how a database tells two look-alikes apart, every time.
5. Relationships — How Tables Connect 🔒Tables stay separate yet work as one by pointing at each other with keys. That pointing is what we call a relationship.
6. What a Query Really Is 🔒A query is a precise request, not a scroll-and-search — pick a table, set a condition, choose the columns. You already do it in email every day.
7. How It Finds Things So Fast 🔒Databases answer in a blink, even with millions of rows, using the same trick as the index at the back of a book.
8. Putting the Whole Picture Together 🔒Tables, keys, relationships, queries, indexes — how the pieces fit, and when a real database beats a trusty spreadsheet.