CRUD Queries
The four verbs of touching data.
▶ the lesson · ~35s · narrated · tap for sound
the intro
CRUD is create, read, update, delete — the INSERT, SELECT, UPDATE, DELETE of SQL. The syntax is simple; the discipline is not. Always SELECT before DELETE, batch your writes, and learn GROUP BY properly because every report needs it.
fun fact ✦
The classic resume-destroyer: running DELETE without WHERE. The WHERE clause is your seatbelt.
the docs
quick hits about CRUD Queries
15-second answers · interviews, tips, trivia & hidden gems
🎤 interview
WHERE vs HAVING?
📚 tutorial
Pagination at the database level
🔧 useful
The safe way to DELETE
💎 deep
Upsert in one statement
🧠 trivia
NULL is not equal to NULL
🔧 useful
One query of 100 rows beats 100 queries