Skip to content

CS 374, Fall 2026

GP3: Build and Load

Initializing search

Home
Syllabus
Calendar
Reading
Homework
Project
Labs
Notes

CS 374, Fall 2026

Home
Syllabus
Calendar
Reading
Reading
Homework
Homework
Project
Project
Labs
Labs
Notes
Notes
- Week 1: Introduction
  Week 1: Introduction
  - Aug 27: Course Overview
- Week 2: Basics of SQL
  Week 2: Basics of SQL
  - Sep 01: Relational Model
  - Sep 03: Joins and Aggregation
- Week 3: Python DB-API
  Week 3: Python DB-API
  - Sep 08: SQL in Python
  - Sep 10: DDL and Constraints
- Week 4: Project Kickoff
  Week 4: Project Kickoff
  - Sep 15: Entities and Attributes
  - Sep 17: Relationships and Cardinality
- Week 5: ER/EER Models
  Week 5: ER/EER Models
  - Sep 22: Enhanced ER Model
  - Sep 24: Relational Mapping
- Week 6: PostgreSQL
  Week 6: PostgreSQL
  - Sep 29: PostgreSQL
  - Oct 01: Python Environment
- Week 7: SQLModel
  Week 7: SQLModel
  - Oct 06: Introduction to SQLModel
- Week 8: Exam 1, ORM
  Week 8: Exam 1, ORM
  - Oct 13: Exam 1
  - Oct 15: Querying with SQLModel
- Week 9: Loading Data
  Week 9: Loading Data
  - Oct 20: Loading a Database
  - Oct 22: Outer Joins, Set Operations
- Week 10: Advanced SQL
  Week 10: Advanced SQL
  - Oct 27: Subqueries
  - Oct 29: Window Functions
- Week 11: Views, Indexes
  Week 11: Views, Indexes
  - Nov 03: Views and Indexes
  - Nov 05: Advanced Queries in Python
- Week 12: DB Backends
  Week 12: DB Backends
  - Nov 10: FastAPI and SQLModel
  - Nov 12: Building a Backend
- Week 13: NoSQL Databases
  Week 13: NoSQL Databases
  - Nov 17: MongoDB, Document Model
  - Nov 19: Neo4j, Graph Model
- Week 14: Review, Exam 2
  Week 14: Review, Exam 2
  - Dec 01: Project Peer Review
  - Dec 03: Exam 2
- Week 15: Prototyping
  Week 15: Prototyping
  - Dec 08: Front-End Prototyping
  - Dec 10: Presentation Prep

GP3: Build and Load

Due: Monday, Oct 26th

Made with Material for MkDocs