README.md

Module 099: Capstone Project: Full-Stack Application (FastAPI + DB + Data Pipeline)

• Phase: 11. Capstone
• Duration: 6 hours
• Milestone: Yes

Learning Objectives

• Build a complete full-stack application from scratch
• Implement FastAPI backend with SQLite/SQLAlchemy
• Create a data ingestion pipeline (CSV or API)
• Design RESTful API endpoints
• Build a Jinja2 web UI
• Validate input with Pydantic models
• Handle errors and log application activity

Project Structure

module-099-capstone-project/
├── README.md
├── notebook.ipynb
├── exercises.md
├── solutions.md
├── quiz.md
└── project/
    ├── README.md
    ├── starter_code.py
    └── solution/
        ├── app.py
        ├── models.py
        ├── database.py
        ├── schemas.py
        ├── templates/
        │   ├── base.html
        │   ├── index.html
        │   └── tasks.html
        └── requirements.txt

Prerequisites

All modules 000-098, especially FastAPI, SQLAlchemy, Jinja2, Pydantic, and logging.

Resources

• FastAPI: https://fastapi.tiangolo.com
• SQLAlchemy: https://www.sqlalchemy.org
• Jinja2: https://jinja.palletsprojects.com
• Pydantic: https://docs.pydantic.dev
• Bootstrap for styling (optional)

Next Module

Module 100: Where to Go Next