Welcome to Databases with SQLModel, the fifth module of the course — and the one your Task Manager has been waiting for. Until now, every task lived in an in-memory list that vanished the moment you restarted the server. Real applications need data that lasts. In this module you’ll give your API a genuine database using SQLModel — a library by FastAPI’s own creator that combines Pydantic models with SQL tables, so the models you already know become database rows with almost no new syntax.

You’ll learn to connect a database (SQLite, which needs zero setup) with an engine, sessions, and a clean session dependency; define table models and separate them from your input/output schemas; and perform full CRUD — create and read (with pagination), then update (partial) and delete (with proper 404s). The module ends with a guided project: a persistent Tasks API whose data survives restarts, finally making the Task Manager a real, durable application.

Every example is real, runnable code verified against an actual SQLite database. Start with Lesson 1, where you’ll connect your first database.