🗃️Relational Database
Also known as RDBMS, SQL Database, Relational Database Management System
A database that keeps data in linked tables. You talk to it in SQL.
Think of it like
Think of it like a set of class lists that point to each other. A pupil's number links them all.
Example
Jack's shop stores customers, orders and products in three tables. One SQL query joins them to show who bought what.
Why it matters
Most business data lives in relational databases. They have been the safe default for over 40 years.
Definition
Common mistake
Key takeaways
- 1Linked tables. Keys tie the tables together.
- 2Spoken in SQL. One language for every question.
- 3Rules kept. The database checks each change.