CS 374, Fall 2025

Oct 16: Views and Indexes

CS 374, Fall 2025

Home
Syllabus
Calendar
Homework
Homework
Project
Project
Labs
Labs
Notes
Notes
- Week 1: Introduction
  Week 1: Introduction
  - Aug 21: Course Overview
- Week 2: Basic Queries
  Week 2: Basic Queries
  - Aug 26: Relational Model, SQL Basics
  - Aug 28: Relational Algebra, SQL Joins
- Week 3: Python DB-API
  Week 3: Python DB-API
  - Sep 02: Running SQL in Python
  - Sep 04: SQL DDL, Project Overview
- Week 4: ER/EER Models
  Week 4: ER/EER Models
  - Sep 09: Entity-Relationship Model
  - Sep 11: Enhanced ER Model (EER)
- Week 5: Database Design
  Week 5: Database Design
  - Sep 16: EER Modeling
  - Sep 18: GP1 Feedback, PostgreSQL
- Week 6: EER to Relational
  Week 6: EER to Relational
  - Sep 23: EER-Relational Mapping; DBML
  - Sep 25: GP2 Feedback, Outer Joins
- Week 7: Data Generation
  Week 7: Data Generation
  - Sep 30: SSH Tunnel, venv, Faker
  - Oct 02: GP3 Milestone Meetings
- Week 8: Midterm Exam
  Week 8: Midterm Exam
  - Oct 07: Review for Midterm
  - Oct 09: Midterm Exam
- Week 9: Object-Relational
  Week 9: Object-Relational
  - Oct 14: ORM with SQLAlchemy
  - Oct 16: Views and Indexes
- Week 10: Fall Break
  Week 10: Fall Break
  - Oct 21: Web Dev 101, Flask
- Week 11: Complex Queries
  Week 11: Complex Queries
  - Oct 28: Set Ops, Window Funcs
  - Oct 30: GP4 Milestone Meetings
- Week 12: Web Applications
  Week 12: Web Applications
  - Nov 04: WTForms, Google Charts
  - Nov 06: SQL Injection, Debugging
- Week 13: NoSQL Databases
  Week 13: NoSQL Databases
  - Nov 11: MongoDB, JSON Model
  - Nov 13: Neo4j, Graph Model
- Week 14: Special Topics
  Week 14: Special Topics
  - Nov 18: Functions, Transactions
  - Nov 20: Normalization (3NF, BCNF)
- Week 15: Course Wrap-Up
  Week 15: Course Wrap-Up
  - Dec 02: Final Review, Logistics
  - Dec 04: Project Presentations