Data Engineering Internship 2026
Chapter 9
Commands Reference
Docker
| Command | What it does |
|---|
| docker compose up -d | Start all containers in background |
| docker compose down | Stop and remove all containers |
| docker compose logs -f <service> | Stream logs for a service |
| docker ps | List running containers |
| docker exec -it <container> bash | Open a shell inside a container |
PostgreSQL
| Command | What it does |
|---|
| psql -U postgres -d bootcamp | Connect to the bootcamp database |
| \dt | List all tables (inside psql) |
| \d tablename | Describe a table schema (inside psql) |
| \copy table FROM file.csv CSV HEADER | Import CSV directly into a table |
dbt
| Command | What it does |
|---|
| dbt run | Run all models |
| dbt run --select model_name | Run a single model |
| dbt run --select +model_name | Run a model and all its upstream dependencies |
| dbt test | Run all tests |
| dbt test --select model_name | Run tests for a specific model |
| dbt docs generate && dbt docs serve | Build and open documentation site |
| dbt debug | Check connection and project configuration |
Python / pip
| Command | What it does |
|---|
| python3 -m venv .venv | Create a virtual environment |
| source .venv/bin/activate | Activate the virtual environment |
| pip install -r requirements.txt | Install all dependencies |
| pip freeze > requirements.txt | Save current dependencies to file |
| pytest tests/ | Run all tests in the tests/ folder |