This is a self-learning bootcamp from DataExpert.io about data modelling. The course talk about building cumulative table, SCD table, Graph table, and building Fact table.
🟪 PostgreSQL
Reliable, powerful open-source database engine.
🐳 Docker + Compose
Spin up Postgres + PGAdmin instantly, no manual setup.
Copy the env template:
cp example.env .envThe
.envfile stores credentials used by PostgreSQL and PGAdmin
Start PostgreSQL & PGAdmin in containers:
docker compose up -dCheck containers are running:
docker ps -aWhen you're done with work:
docker compose stop