Reps

Short exercises on one technology

Each rep set is a numbered list on one technology, or on two used together, and you do it on your own machine, in your editor and terminal. The reps train you to read and judge code you didn't write.

All · 6 PostgreSQL · 5 C# · 1

9 reps Warm-up

SQL · Querying

Read a schema you did not write and get the rows out of it: filters, joins, subqueries, sets and aggregates, with the NULLs and orphans that bite.

PostgreSQL

Start →

9 reps Intermediate

SQL · Designing and writing

Turn requirements into tables, constraints and keys, then insert, load, update and delete without leaving the data in a state you did not mean.

PostgreSQL

Start →

6 reps Intermediate

SQL · Viewing

Read and judge views: aggregated, layered, partitioned, and the ones that hand a role exactly what it may see and nothing more.

PostgreSQL

Start →

8 reps Advanced

SQL · Optimizing

Read a query plan and say why it is slow; add the index that changes it, and see what two concurrent sessions do to a balance.

PostgreSQL

Start →

6 reps Advanced

SQL · Scaling and security

Read roles, injections, prepared statements, a replica that lags and a shard that runs hot, and say which one your system has.

PostgreSQL

Start →

Rep progress is tracked separately from projects.