SQL Foundations for Engineers
You work with tables daily but want the mental model behind joins, aggregates, and window frames. This course anchors syntax in execution: how the planner reads your SQL, where costs creep in, and how to refactor toward predictable shapes. Labs use anonymized schemas inspired by logistics and billing workloads common in Japan.
Duration: 5 weeks · 42 hours · Format: Live cohort + mentor async reviews
Price (informational): ￥128,000
Request information
What is included
- Explain plans decoded with a simple checklist
- CTEs versus subqueries: trade-offs you can defend in review
- Window functions for cohort reporting
- Safe migrations for nullable columns and indexes
- Parameterized queries and prepared statement hygiene
- Hands-on labs with automated diff checks
Outcomes
- Ship SQL changes with a written rationale tied to plan cost
- Spot three anti-patterns that inflate buffer reads
- Produce a migration note teammates can replay locally
Lead contact
Haruka Watanabe
Former platform SRE; now curriculum lead for relational tracks.
FAQ
Participant notes
Week two’s join reordering lab finally made nested loops click. I quoted the checklist in our incident retro.
Ken · Backend engineer · 5/5 · survey
Mentor annotated my CTE rewrite line by line. Still terse on window frame boundaries, but the notes are gold.
Client in logistics