Track
SQL
Review schemas, queries, joins, indexes, transactions, migrations, and data safety.
- 01
Schema keys and constraints
Model table ownership with primary keys, foreign keys, uniqueness, and check constraints.
schemaconstraintskeys - 02
Explicit SELECT columns
Select the columns the caller needs instead of depending on table shape.
selectprojectionapi - 03
Filtering and NULL handling
Use SQL NULL operators and explicit boolean logic so filters match real data.
wherenullfilters - 04
Join cardinality
Review joins for one-to-one, one-to-many, and missing-row behavior before trusting the result.
joinscardinalityduplicates - 05
Aggregation and grouping
Group by the same dimensions you want to report, and make aggregate meaning clear.
aggregategroup byreporting - 06
Index-friendly predicates
Keep indexed columns searchable by avoiding unnecessary functions on the column side.
indexeswhereperformance - 07
Transactions for atomic workflows
Wrap multi-step writes in a transaction so related changes succeed or fail together.
transactionsatomicitywrites - 08
Migration backfills
Split schema changes, backfills, and stricter constraints into safe migration steps.
migrationsbackfillconstraints - 09
Parameterized queries
Bind user input as parameters instead of building SQL strings from untrusted values.
securityinjectionparameters - 10
Stable pagination
Use deterministic ordering and cursor predicates for pages that stay stable as data changes.
paginationorderingcursors
Related tracks
Keep learning inside the same language family.