Zum Inhalt springen
KodeTrail

Camp 1 · Schritt 1 von 13

What is a database?

Why spreadsheets stop scaling, what databases do instead, and where SQL fits in.

8 Min.+50 XPAuf Englisch angezeigt — Übersetzung ist unterwegs

Every app you use — banking, messaging, shopping, streaming — is a thin layer of buttons over a database: software whose entire job is storing data and answering questions about it, fast and safely.

Why not just a spreadsheet?

Spreadsheets are lovely… until they aren't:

ChallengeSpreadsheetDatabase
Millions of rowsgrinds to a haltroutine
Many users writing at onceconflicts and overwriteshandled safely
"Only valid emails in this column"hopeenforced rules
Complex questions across datasetsmanual gymnasticsone query

Where SQL comes in

SQL (Structured Query Language, born 1974) is how humans talk to relational databases — the kind organized into tables. You describe what you want; the database figures out how to get it:

SELECT name FROM trails WHERE lessons > 12;

Read that aloud — it's nearly English. That declarative style is why SQL has outlived fifty years of tech fashion and why it's consistently among the most-used languages in developer surveys. PostgreSQL, MySQL, SQLite, SQL Server, Oracle — different engines, same language.

Checkpoint

What kind of language is SQL?

What's next

The shape of relational data: tables, rows, and columns.