Skip to content
CS 374, Fall 2026
HW5: Analytical Queries
Initializing search
Home
Syllabus
Calendar
Reading
Homework
Project
Labs
Notes
CS 374, Fall 2026
Home
Syllabus
Calendar
Reading
Reading
Week 1: What Is a Database?
Week 2: Joins and Aggregation
Week 3: SQL in Python
Week 4: Entity-Relationship Model
Week 5: Relational Mapping and Normalization
Week 6: Data Types and Test Data
Week 7: No Reading
Week 8: Introduction to SQLModel
Week 9: Outer Joins and Set Operations
Week 10: Subqueries and Window Functions
Week 11: Views and Indexes
Week 12: Web APIs with FastAPI
Week 13: NoSQL Query Languages
Week 14: No Reading
Week 15: No Reading
Homework
Homework
HW1: SQL Queries
HW2: CRUD Operations
HW3: Data Modeling
HW4: Models and Data
HW5: Analytical Queries
HW6: Web APIs
Project
Project
System Description
Core Schema Design
GitHub Workflow
GP1: Requirements
GP2: Schema Design
GP3: Build and Load
GP4: Queries and Views
GP5: Backend API
GP6: Final Presentation
Labs
Labs
SQLite (DB Browser)
Python DB-API
Abstract ER Models
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
HW5: Analytical Queries
Due: Monday, Nov 2nd