Reps

Learn it well enough to read it

Short exercises you run on your own machine with bgym — on one technology, or on two of them meeting, which is usually where the surprises are. The goal is fluency to read and judge what a machine wrote for you, not to write every line by hand.

How the CLI works →

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 counted on its own. The projects page counts projects, and the two are deliberately never added together.