Audience: Computer Science student, understands basic Python and SOLO loops
2. API Design
Learn how web APIs work, design clean and stable interfaces, and implement state persistence using FastAPI and SQLite.
Mario Guerra
Author & Technical Leader
Course Outline
Module 0
Orientation: API Design
Understand what web APIs are, and plan the structure of the Task Organizer API.
Module 102: API-First
The Request-Response Loop
Demystify HTTP communication by building a running web server in Python.
architect, critique, revise, code
Module 202: API-First
The Language of the Web
Learn how to structure data payloads and return semantic HTTP status codes.
architect, critique, revise, code
Module 302: API-First
Interface-First Design & CORS
Define Pydantic schemas, stub out API routes, and configure CORS middleware.
architect, critique, revise, code
Module 403: Security-First
State & Relational Persistence (SQLite)
Implement database storage using raw SQL queries and prevent SQL injection attacks.
architect, critique, revise, code
Module 505: Test-Driven
Testing Web APIs (API TDD)
Write integration tests using TestClient and assert status codes for happy and error paths.
test
At a Glance
Version1.0
Pillars Taught6 Core Pillars
Hands-on ProjectPython CLI Study Tracker
Workflow IntegrationsVS Code + Copilot Agent Mode + Codex