Database design
Design tables that stay correct, keep queries fast as data grows, change data safely, and choose the right kind of database.
- Database design basics: tables, keys and relationships, with a real example5 min read
- SQL joins explained with real examples: INNER, LEFT and the traps to avoid6 min read
- Database indexes explained: how to make slow queries fast5 min read
- Database transactions explained: ACID, rollbacks and race conditions4 min read
- SQL vs NoSQL: how to choose a database for your project4 min read