databases/
Tables, queries, indexes, transactions, storage engines and caching.
2 results
databases/your-first-sql-query-ask-a-table-of-pets-a-question.md
Your first SQL query: ask a table of pets a question
SQL is the language you use to ask a database questions, and five words get you surprisingly far: SELECT, FROM, WHERE, ORDER BY and LIMIT…
databases/why-databases-split-your-data-into-two-tables-and-link-them-by-id.md
Why databases split your data into two tables (and link them by id)
A database table looks like a spreadsheet: columns for each kind of information, one row per thing. But it comes with rules. Every column…