The toolbox

Reference

Quick reference pages for SQL syntax. Examples use DuckDB SQL, with notes where it differs from Postgres, SQL Server, MySQL, or SQLite.

SELECT syntax
WHERE operators
JOIN types
Aggregate functions
Date functions
String functions
Null handling
CASE expressions
Common SQL errors
Query formatting guide
Safe UPDATE & DELETE checklist

🚧 Reference pages are built out as the curriculum grows.