🗄️ Database
Where data lives, how it’s modelled, how it’s queried, how it survives failure. The data layer underneath almost every application.
Fundamentals
- Relational vs NoSQL Databases
- ACID Transactions
- Database Indexing
- Normalization (1NF → 3NF) (todo)
- CAP theorem (todo)
- Database.md — legacy reference note
Relational (SQL)
- PostgreSQL (todo)
- MySQL / MariaDB (todo)
- Microsoft SQL Server (todo)
- Oracle (todo)
- SQLite (todo)
- SQL fundamentals (SELECT, JOIN, GROUP BY) (todo)
NoSQL
- Document — MongoDB (todo)
- Key-value — Redis (todo)
- Wide-column — Cassandra (todo)
- Graph — Neo4j (todo)
Cloud-managed
- AWS RDS / Aurora / DynamoDB (todo)
- Azure SQL / Cosmos DB (todo)
Operations
- Backup & restore (todo) → see Backup Fundamentals — RPO and RTO
- Replication — master/replica, multi-master (todo)
- Sharding & partitioning (todo)
- Connection pooling (todo)
- Query optimisation / EXPLAIN (todo)
Data warehousing / analytics
- OLTP vs OLAP (todo)
- Snowflake / BigQuery / Redshift (todo)
- ETL vs ELT (todo)
All Database notes
TABLE WITHOUT ID file.link AS "Note", type AS "Type", tags AS "Tags"
FROM "08 - Database"
WHERE type != "moc"
SORT file.name ASC