Back to Program Overview

Module 3: Database Modeling & Queries

Module/Week 2: Database Modeling & Queries

Module 3: Database Modeling & Queries

Programme

Backend Engineering Internship

Module Number

3

Module Title

Database Modeling & Queries

Duration

3-4 Days

Level

Intermediate to Advanced

Tools Required

PostgreSQL, Prisma or SQL migrations, DB diagrams

Overview

Model relational data, write efficient queries, and protect data integrity. This module is designed to feel like a real workplace sprint: you will understand the requirement, learn the technical concepts, inspect examples, build a practical artifact, and prepare your work for review.

Objectives

  • Design normalized schemas
  • Write joins and indexes
  • Use migrations

Course Content

13 Topics

Hands-on Tasks

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

Learning Outcomes

  • Design normalized schemas
  • Write joins and indexes
  • Use migrations