intermediate · cohort
Data Access with JDBC and jOOQ
SQL discipline, connection pooling, and type-safe queries for teams allergic to magic ORMs.
5 weeks · 7h/week
JPY 88,000
Informational rate—final fees appear on your enrollment agreement.
Request information Money-back policyProgram narrative
Data access taught as engineering craft. You will write JDBC code with proper resource handling, compare jOOQ generated models with hand-written mappers, and discuss migration strategies for legacy stored procedures. Includes batching labs tuned for nightly settlement windows.
What ships in the box
- Connection pool tuning lab with HikariCP metrics
- Transaction isolation experiments on sample datasets
- jOOQ codegen pipeline with Flyway migrations
- Batch insert competition with honest benchmarking caveats
- SQL style guide you can adopt verbatim
- Stored procedure boundary discussion with JP banking anecdotes anonymized
- Mentor review of your schema change proposal
Outcomes you can describe
- Implement a repository with explicit SQL and tested mappings
- Explain isolation anomalies you simulated in lab
- Propose a migration slice that reduces downtime risk
Lead mentor
Jonas Weber
Backend mentor; built payment adapters across EU and JP regions.
Cohort questions
We critique JPA pitfalls but do not teach Hibernate mastery.
Postgres primary; Oracle quirks mentioned in appendix.
NoSQL data stores, analytics warehouses, or stream processing frameworks.
Experience notes
Batch insert lab exposed an N+1 we had rationalized away—metrics do not lie.