How zheniatrochun/db-intro-course works
This repository is a database-course resource set with a documented Docker-based PostgreSQL and pgAdmin environment. The principal learner workflow is to study lecture materials, complete labs and SQL exercises, then use the database environment for practice. The map includes the documented course stages and environment; because no source excerpts were provided, relationships are limited to those stated in the README.
Main entry points: docker-compose.yml Compose environment · lectures Lectures · labs Laboratories · exercises SQL exercises
Components 11
Course materials
- Lectures
lectures
Hands-on work
- Laboratories
labs - SQL exercises
exercises - Campus schema
scripts/create-campus-tables.sql - SQL examples
scripts
Database environment
- Compose environment
docker-compose.yml - PostgreSQL
- pgAdmin
Quick reference
- Glossary
glossary.md - SQL cheat sheet
sql-cheat-sheet.md
Other components
- Learner
Connections 10
- Learner → Lectures: studies
README.md - Learner → Laboratories: completes
README.md - Learner → SQL exercises: practices SQL
README.md - Learner → Glossary: references
README.md - Learner → SQL cheat sheet: references
README.md - Learner → Compose environment: starts environment
README.md - Compose environment → PostgreSQL: starts service
README.md - Compose environment → pgAdmin: starts service
README.md - Learner → pgAdmin: manages database
README.md - pgAdmin → PostgreSQL: connects to
README.md