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… 9 min read · 1 Oct 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… 10 min read · 1 Oct