API Layers on Top of SQL Services

Design read models, pagination, and caching boundaries between HTTP APIs and databases.

API Layers on Top of SQL Services

Tuition (informational)

₫6,100,000

Confirm with admissions; see Money-Back Policy for windows.

Logistics

  • Duration — 5 weeks
  • Schedule — Evenings
  • Skill level — Intermediate
  • Certification — Certificate of completion
  • Languages — EN
Tuan Bui

Lead mentor

Tuan Bui

Backend lead who ships bilingual API docs for distributed teams.

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

  1. Ship an OpenAPI fragment describing two read endpoints with explicit pagination.
  2. Demonstrate a before/after query plan improvement tied to an API change.
  3. 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.”
Son — Backend engineer

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.

Request information Back to catalog