Databases and Data Engineering Fundamentals advances the practical engineering skills needed for the capstone.
- Explain the core ideas and their real-world trade-offs.
- Implement and test a working feature.
- Document choices, limits, and safe operating practices.
Weeks 1-6
| Day | Session |
|---|---|
| Monday | Relational data modelling and SQL |
| Tuesday | SQLite and CRUD |
| Wednesday | Relationships and transactions |
| Thursday | PostgreSQL and SQLAlchemy fundamentals |
| Friday | Database project review |
Complete guided and independent exercises in each lesson. Run code locally and record one edge case.
Student records application backed by SQLite or PostgreSQL. Submit source, README, setup and run steps, evidence of testing, and reflection.
- Runnable feature or project.
- Git history with focused commits.
- Documentation sufficient for a reviewer to reproduce the work.
Conceptual understanding 15%, practical exercises 20%, assignment 20%, GitHub/documentation 10%, mini-project 20%, participation/code review 5%.
See resources.md, project guidelines, and official Python documentation.