Web Development / Cohort
API Layers on Top of SQL Services
Design read models, pagination, and caching boundaries between HTTP APIs and databases.
Overview
Backend developers learn to keep SQL efficient behind stable JSON contracts. Labs use Node and Go snippets, but concepts transfer to other stacks common in Vietnam outsourcing shops.
What is included
- Pagination strategies with keyset vs. offset trade-offs
- Caching lab with stale-while-revalidate discussion
- OpenAPI sketch reviews with teaching assistants
- Load test harness interpreting p95 latencies
- Error taxonomy workshop
- Observability spans naming drill
- Pair exercise documenting N+1 pitfalls
Outcomes you can show
- Ship an OpenAPI fragment describing two read endpoints with explicit pagination.
- Demonstrate a before/after query plan improvement tied to an API change.
- Author an error catalog aligned with support teams.
Experience notes
“Keyset pagination lab finally broke my OFFSET habit—Tuan’s review of my OpenAPI draft caught a nullable field mismatch.”
FAQ
Language stack locked?
Examples rotate between Node and Go; you may adapt exercises to your preferred language.
Frontend required?
No UI work is graded; focus remains on API/SQL boundaries.
Limitations?
We do not deploy to your employer infrastructure; use sandbox projects.