intermediate

DE//AGENT currently lists 7 resources under intermediate: 7 tutorials. Everything below is derived from the live registry — counts, capabilities, verification state and security posture come from the curated records, never from marketing copy.

Documented learning objectives across these resources:

• Assemble the series' rules into one checklist you can run on any query — via Capstone — the SQL correctness checklist
• Turn each checklist line into a standing check with an owner — via Capstone — the SQL correctness checklist
• Emit findings with severity, location, rule, and fix — via Capstone — the SQL correctness checklist
• Recognize inflated row counts and double-counted metrics as the fan-out signature — via Incident — the numbers doubled and no alarm fired
• Count duplicates per key and correlate the first duplicate date with a deploy — via Incident — the numbers doubled and no alarm fired
• Rewrite affected partitions instead of the whole table — via Incident — the numbers doubled and no alarm fired
• Spot NULL-unsafe `NOT IN` and `=` predicates and rewrite them with NOT EXISTS — via Production gotchas — NULL traps, implicit casts, silent drift
• Make every cross-type comparison an explicit cast, not an implicit one — via Production gotchas — NULL traps, implicit casts, silent drift

13 more objectives live on the individual resource pages.

These resources map to stages: Python + SQL (5), Warehousing (2). Follow the four-phase roadmap to place this topic inside a progression instead of learning it in isolation.

Every entry, its shape and its trust state — sorted by the registry's composite score. This table is the honest version of a marketing comparison: no sponsored placements, no unverifiable claims.

How scores are computed: source quality score.

Highest composite score first:

1. Capstone — the SQL correctness checklist score 34.15 — intermediate
2. Incident — the numbers doubled and no alarm fired score 34.15 — intermediate
3. Production gotchas — NULL traps, implicit casts, silent drift score 34.15 — intermediate

Scores rank provenance, completeness and trust — read how verification works before adopting anything.

• Capstone — the SQL correctness checklist — Close the series by turning nine lessons into one standing checklist: a grain statement for every SELECT, a cardinality justification for every join, NULL-safe anti-joins, explicit… details
• Incident — the numbers doubled and no alarm fired — Row counts are inflated and metrics double-counted after a retry, a fan-out join or a backfill — the incident signature of a silent fan-out. You work the duplicate-records runbook … details
• Production gotchas — NULL traps, implicit casts, silent drift — The bugs that survive testing compare wrong instead of failing loud: NOT IN over a nullable subquery, a comparison across types left to an implicit cast, and a schema change that s… details
• Read an EXPLAIN plan and pick the one fix — Take the EXPLAIN output of a slow query and read it bottom-up, naming the expensive node before you touch anything. You compare estimated rows to actual rows to catch stale statist… details

Adjacent topics: tutorial (7 shared), review (3 shared), grain (2 shared), dedupe (2 shared).

Study path: the roadmap places this topic in a progression · the scoring model explains the numbers · the trust rule catalog shows every security check these entries passed through.