Bring the whole programme together by building one complete application end to end — a Flask web front-end, a SQLite database through SQLAlchemy, and an AI-powered feature that summarises and classifies each record. You will plan, scaffold, model data, build the interface, wire the AI, test with pytest, and ship to GitHub with a README, keeping every secret in an environment variable. This practical capstone consolidates the PCEP, PCAP and PCPP skills into a portfolio project you can show.
Watch the free preview
From idea to plan — the architecture of a full app — free to watch, no account needed.
What you'll learn
- Plan and scaffold a full Flask application with a virtual environment and Git from day one
- Design a SQLAlchemy data model and drive it with create, read, update and delete routes
- Build Jinja2 templates and HTML forms styled with CSS that talk to your Python logic
- Integrate an AI feature that calls an LLM API using a key kept in an environment variable
- Test the app with pytest, add logging and a README, and ship it to GitHub with a tagged release
Syllabus
Planning & Scaffolding the App
From idea to plan — the architecture of a full appFree preview
Scaffolding — venv, structure, Git and secrets
Data Model & Persistence
The data model with SQLAlchemy
CRUD routes — wiring the web to the database
The Interface & the AI Feature
Templates, forms and CSS — the front-end
The AI feature — summarise and classify with an LLM
Testing, Hardening & Shipping
Testing the app with pytest
Hardening and shipping — logging, README and GitHub
Lab — 10 Programming Exercises & Solutions
Programming Exercises 1–5
Programming Exercises 6–10