Node: v22.1.0

Install Docker for Windows

docker pull postgres:17.0
docker pull node:22.9.0-slim
docker pull mcr.microsoft.com/mssql/server:2019-CU13-ubuntu-20.04

Configure leaderboard URI in sql-front/config.ts.

git clone https://github.com/itenium-be/sql-training
cd sql-training
docker compose up -d --build
# Frontend: http://localhost:5173
# Swagger: http://localhost:8080

Only start progress & adjust sql-back/.env and set PG_HOST="localhost".

cd sql-back
npm run dev

cd ../sql-front
npm run dev

Starter exercises "World" & "Teachers".

See compose.yaml and sql-back/.env.
You can use a tool like pgAdmin to query the data directly.

• Server: localhost
• Port: 5175
• User: admin
• Password: password

Exercises "Worldcup".

• Server: localhost
• Port: 5174
• User: sa
• Password: password123!

The game just executes your SQL. So if you tried a TRUNCATE table, but you want to continue playing after 😃

docker compose down -v
docker compose up -d --build

The sql-front/src/config.ts contains the leaderboard URI, of which only one should be running 😀

cd sql-leaderboard
cp .env.template .env
docker compose up -d
npm run dev

GET: http://localhost:8000/game/mode?apiKey=secret&mode=running

# Back to init mode:
GET: http://localhost:8000/game/mode?apiKey=secret&mode=init

Allow people to see all solutions at the endgame:

GET: http://localhost:8000/game/mode?apiKey=secret&mode=end

Goal scored at the latest minute that won the game.

In the goals table, score0 and score1 are NULL, our intern forgot to write the code to set these fields. They should be the game score at that point including the goal just scored. Write the UPDATE statement.

• SQL Murder Mystery - Can you find out whodunnit?
• datalemur.com - Ace the SQL & Data Science Interview
• sql-practice.com
• sqlzoo - Learn SQL in stages (Countries & Teacher datasets came from this one!)