README.md

Setup

1. Copy .env.template to .env
2. Setup database connection url
3. Setup thunder client, collection is exported at thunder-collection_course.json

Problem

remove fakeDb and use postgres to store data changing format of response.

Level 1

Statement

use 1 table (courses)

notice that department is denormalized

Hint

Create sql create table script file and manually run it in sql client is not a bad solution

Level 2

Statement

normalize department

Hint

read more on join table to get single query code

Level 3

Statement

Add edit route