#sql
SQL Query Writer — Correct, Readable and Indexed
Write a SQL query from a plain-English question and your schema, with an explanation of how it works, the edge cases it handles, and what would keep it fast at scale.
Nigel Yoshida
Database Schema Design — Tables, Keys and Migrations
Design a database schema from your requirements: tables, columns and types, keys and constraints, indexes for your real queries, and a migration plan that flags steps that could lock a table or lose data.
Nigel Yoshida