Home/Projects/Python/Project 2
IntermediatePython project · about 12 hours

REST API with FastAPI and a database

Build a task-tracking API with FastAPI, SQLAlchemy, authentication and tests.

The real-world brief

A small team wants a simple API for tracking tasks that other tools can use.

What you will build

  • CRUD endpoints for tasks and users
  • Token authentication
  • Database models and migrations
  • Tests and a Docker image

Skills you will practise

OOPAPI designDatabasesAuthentication

Tools

PythonFastAPISQLAlchemySQLite or PostgreSQLpytestDocker

Project tasks

The detailed steps, checklists and trainer review open in the SOTT student portal for enrolled students.

1Models Steps in portal
2Endpoints Steps in portal
3Auth Steps in portal
4Test and ship Steps in portal

How companies use Python

Finance: Automating monthly reports. Staff spent two days a month copying data between spreadsheets. Python scripts read the source files, check them and produce the final report automatically. The report takes minutes and has fewer errors.

E-commerce: Price monitoring. The team checked competitor prices by hand. A Python scraper (within site rules) collects prices daily and flags big changes. Pricing decisions are made on fresh data.

IT operations: Server health checks. Engineers logged in to servers one by one each morning. A Python tool checks disk, CPU and services on all servers and sends a summary. Morning checks take minutes instead of an hour.

Questions

Can I add the REST API with FastAPI and a database project to my resume?

Yes. Once your trainer approves it, list it under Projects with the tools you used, one line on the problem it solves and a link to your repository and demo video.

How long does this project take?

About 12 hours of hands-on work, and it fits best after week 8 of the Python course.

Where do I get the step-by-step tasks?

Enrolled students get every task with steps, "done when" checks, the submission form and a trainer review in the SOTT student portal.