Query Optimization · Self-paced
Query Rewrite Gym
Practice safe rewrites: CTEs vs subqueries, join order hints without hint abuse, and batching patterns that respect isolation.
- Duration
- 5 weeks · self-paced with weekly live recap
- Skill focus
- Intermediate
- Platform lens
- PostgreSQL
- Tuition (informational)
- ₩540,000
Overview
Rewrite Gym is a set of timed challenges with automated diff checks against golden result sets. Coaches review style choices that affect readability as much as performance, because maintainable SQL survives longer than clever hacks.
What is included
- Twenty rewrite challenges with automated checks
- Video debriefs for the five hardest prompts
- Style guide aligned with BlinkBeam reviewer rubric
- Optional pair programming slots
Outcomes
- Ship two production-ready rewrite PRs from the gym prompts
- Explain rewrite trade-offs in a design doc paragraph
- Identify when a rewrite should wait for statistics refresh
Primary coach
Theo Okonkwo
Specializes in turning “it worked in staging” threads into reproducible benchmarks.
FAQ
Language support?
Challenges ship in English; coaches answer Korean or English in office hours.
Are ORMs covered?
We reference ORM-generated SQL but focus on hand-written SQL for clarity.
Known gap?
Graph and recursive CTE tuning is only touched in a bonus appendix.
Experience notes
-
★★★★★ Verified learner — the CTE vs temp table debate finally has guardrails on our team.
Tuition is informational on this static preview. Enrollment teams confirm availability, tax treatment, and any employer procurement paperwork steps. See Returns & Refunds for eligibility framing.