Skip to content

Latest commit

 

History

History

week-07-databases-data-engineering

Folders and files

README.md

Week 07: Databases and Data Engineering Fundamentals

Weekly theme

Databases and Data Engineering Fundamentals advances the practical engineering skills needed for the capstone.

Learning objectives

  • Explain the core ideas and their real-world trade-offs.
  • Implement and test a working feature.
  • Document choices, limits, and safe operating practices.

Prerequisites

Weeks 1-6

Monday-Friday schedule

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

Practical exercises

Complete guided and independent exercises in each lesson. Run code locally and record one edge case.

Assignment

Student records application backed by SQLite or PostgreSQL. Submit source, README, setup and run steps, evidence of testing, and reflection.

Expected deliverables

  • Runnable feature or project.
  • Git history with focused commits.
  • Documentation sufficient for a reviewer to reproduce the work.

Assessment criteria

Conceptual understanding 15%, practical exercises 20%, assignment 20%, GitHub/documentation 10%, mini-project 20%, participation/code review 5%.

Learning resources

See resources.md, project guidelines, and official Python documentation.