Back to Projects
Capstone Project

Project 1: Relational Postgres Schema

Design a relational database and write schema migrations.

Frontend

Vanilla CSS dashboard tables displaying orders.

Backend

Node.js PG client routers query database tables.

Database

PostgreSQL database engines, primary keys, cascading constraints, B-Tree indices.

Implementation Steps

Step 1•45 mins

Relational Table mapping

Start Step
Step 2•45 mins

SQL migration scripts creation

Start Step
Step 3•45 mins

Key constraint definitions

Start Step
Step 4•45 mins

Query Index optimization

Start Step
Step 5•60 mins

Trigger procedures config

Start Step
Step 6•60 mins

Aggregate Calculations DQL

Start Step
Start Project Guide