Back to Program Overview

Module 4: Practicum

Module/Week 2: Database Modeling & Queries

Module 4: Practicum

Programme

Backend Engineering Internship

Module Number

4

Module Title

Database Modeling & Queries Practicum

Duration

3-4 Days

Level

Intermediate to Advanced

Tools Required

PostgreSQL, Prisma or SQL migrations, DB diagrams

Overview

This practicum turns the previous concepts into a complete reviewable deliverable. The goal is not to submit a tiny demo. The goal is to build something that looks, behaves, and reads like early industry work.

Objectives

  • Convert requirements into a working implementation
  • Practice debugging and iteration
  • Document the work for mentor review
  • Prepare reusable assets for the final capstone

Course Content

13 Topics

Hands-on Tasks

  • Schema diagram
  • Migration files
  • Seed data
  • Query examples

Learning Outcomes

  • Build a complete deliverable from a requirement
  • Explain implementation decisions clearly
  • Prepare work for mentor or client review
  • Carry reusable pieces into the final capstone