IntermediateBackend Developer Fundamentals Workshop project · about 4 hours

Database-backed API

Connect the API to a database with models and queries.

The real-world brief

The notes API loses all data every time the server restarts.

What you will build

  • A notes table
  • API using the database
  • Migrations
  • Seed data

Skills you will practise

DatabasesORMsMigrationsData modelling

Tools

SQLite or PostgreSQLAn ORM (Prisma, SQLAlchemy)Migrations

Project tasks

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

1Model Steps in portal
2Connect Steps in portal
3Seed Steps in portal
4Document Steps in portal

How companies use Backend Developer Fundamentals Workshop

Small business: Online at last. A local shop had no website. A simple responsive site with contact form and map. New customers find the shop online.

Startup: From idea to working app. A founder needed a demo for investors. A small web app with sign-up and a database. The demo helped raise funding.

Education: Online forms instead of paper. Admissions used paper forms. A web form saving to a database with an admin page. Processing time fell.

Questions

Can I add the Database-backed API 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 4 hours of hands-on work.

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.