How Relational Databases Work
Move beyond static spreadsheets to understand how relational databases structure, connect, and retrieve data. Learn to formulate precise queries, design clean relational schemas, and protect data integrity under heavy traffic.
Like Duolingo, but for How Relational Databases Work. Tomo turns the whole topic into a game you play five minutes a day, until it actually sticks.
A short one: 11 levels across 2 sections, about 22 minutes end to end, roughly 4 days at five minutes a day. It moves through Asking Questions and Connecting Data and Integrity, Safety, and Speed. It starts from scratch.
Free forever · No credit card · iPhone & Android
Key ideas in How Relational Databases Work
- SQL is declarative: you describe what data you want rather than prescribing how to get it
- The database engine evaluates available indexes and disk layouts to pick the most efficient retrieval path automatically
- A WHERE clause instructs the database engine to discard non-matching rows before transferring data across the network
- Fetching entire tables into application memory wastes database disk I/O, network bandwidth, and application memory
- SELECT * pulls every single column in the table, including heavy text or binary fields that might not be needed
- Specifying only needed column names reduces network payload size and client memory consumption
- Aggregate functions like COUNT, SUM, and AVG compute summaries directly on the database server
- Calculating totals inside the database returns a single lightweight result instead of transferring thousands or millions of raw rows over the network
- Single-row text formatting or presentation tweaks are generally handled in application code rather than via aggregation
- ORDER BY sorts the rows inside the database engine
- LIMIT stops row processing and transmission once the requested count is reached, saving memory and bandwidth
- In a flat, single-table design, shared details like addresses get repeated on every new transaction row
- Modifying a repeated piece of data in only some rows leads to contradictory, unreliable information across the database
- A relational database avoids this by isolating repeated details into their own separate table
- An entity represents an independent, real-world concept (like a person, place, or event) that holds its own set of facts
- Grouping attributes by their core entity ensures each fact is recorded in only one place
You've tried the other tabs
Thirty open tabs. Four facts you actually kept.
You watched. You nodded. By Sunday it was gone.
One answer, then back to scrolling.
Eight weeks. You meant to finish. You didn't.
Tomo gives How Relational Databases Work the Duolingo treatment: levels, streaks, and quick quizzes that test what you just learned. That game loop is what the tabs above never had, so it's the one you actually finish.
Here's what playing it feels like
A real question from this course. Take your best guess.
Picture sending a query to a massive library. How does the database engine decide how to fetch your records?
Get it right to open this lesson and 10 more in the app.
Where How Relational Databases Work takes you
- 1
Asking Questions and Connecting Data
- Querying: Asking for Outcomes, Not Steps
- Designing Relationships: Beyond the Giant Spreadsheet
- 2
Integrity, Safety, and Speed
- Transactions: Keeping Data Safe Under Pressure
- Indexing: Finding Records Without Full Scans
2 sections · 4 units · 11 levels. Built to play, not to enroll.
Tomo is in ChatGPT
Tomo is also a ChatGPT plugin: the same playable courses, built and played inside your chat.
Add Tomo to ChatGPT- What to ask
- “Make me a Tomo course on black holes.” “Turn this chat into a Tomo course.”
- What you get
- Quick questions with instant feedback, hearts and stars, ready to play in about a minute.
- Where it goes
- No sign-up to start. Connect your Tomo account and your streak carries on in the app.
You pick the voice
How Relational Databases Work is taught in the Storyteller style: every lesson is a story. Want a different feel? In the app you can spin up the same topic in any of Tomo's teaching styles. Same facts, totally different vibe.
More Technology on Tomo
Data Analysis from Excel to SQL
Transform messy raw spreadsheets into automated models, interactive dashboards, and robust database queries. Learn to clean data in Power Query, calculate metrics in DAX, and extract answers with SQL.
Interactive Dashboards with Power BI
Transform static spreadsheets into dynamic, clickable visual reports. Learn how to clean messy data, build multi-table relationships, and write flexible calculations that adapt to user interaction.
The Digital Architect: From Pixels to Packets
Master the invisible systems that power our world. Move beyond basic usage to understand how data travels, how users think, and how complex software stays standing under pressure.
Making Sense of Data
Learn to extract reliable insights from raw numbers, spot hidden patterns, and avoid misleading conclusions. This course gives you the essential mindset and practical tools to analyze data with confidence.
C++: Foundations and Pitfalls
Build a robust mental model of C++ from your first program to complex systems. Uncover the subtle language traps and memory quirks that catch even experienced programmers.
Designing Microservice Architectures
Move beyond the basics of monolithic code to build scalable, decoupled distributed systems. Master service boundaries, distributed data management, and resilience patterns required to run reliable microservices in production.
Start How Relational Databases Work today.
Download Tomo, search How Relational Databases Work, and play your first lesson in under a minute.