beginner · cohort
SQL Foundations for Engineers
6 weeks · 5–8 hrs/week
A paced introduction for developers who touch relational data but want fewer surprises in production. You will model small domains, normalize where it matters, and practice migrations with rollback thinking. Mentors annotate three graded assignments with line-level notes.
What ships in this outline
- ANSI SQL patterns with PostgreSQL-flavored examples
- ER sketches translated into tables and keys
- Transactions introduced with explicit isolation vocabulary
- Index awareness without premature optimization
- Query readability checklist used in code review
- Portfolio artifact: schema + seed + sample analytics queries
- Office hours for Japan-friendly time zones
Outcomes
- Ship a two-schema mini app with foreign keys and checks you can defend
- Explain why a query plan changed after an index addition
- Document assumptions your ORM hides from teammates
Lead mentor
Haruto Watanabe
Former data platform lead at a logistics SaaS; PostgreSQL contributor talks in Tokyo.
FAQ
Comfort with any programming language is enough. We start from SELECT and build upward.
Sessions are recorded within 48 hours. Two live workshops per cohort have stronger mentor presence.
We do not cover proprietary warehouse appliances or vendor-specific certifications; those sit in advanced tracks.
Experience notes
“The week-2 join clinic finally made outer joins stick. My capstone ER diagram got rewritten twice — worth it.”
“Clear pacing; the ORM appendix could be longer. Loved the annotated feedback on my migration script.”