Skip to content

CS 374, Fall 2024

Project

Initializing search

Home
Syllabus
Calendar
Homework
Project
Labs
Notes

CS 374, Fall 2024

Home
Syllabus
Calendar
Homework
Homework
Project
Project
Labs
Labs
Notes
Notes
- Week 1: Introduction
  Week 1: Introduction
  - Aug 22: Course Overview
- Week 2: Basics of SQL
  Week 2: Basics of SQL
  - Aug 27: Relational Model, DML
  - Aug 29: Running SQL in Python
- Week 3: Key Constraints
  Week 3: Key Constraints
  - Sep 03: MySQL, Constraints, DDL
  - Sep 05: Joins, Project Overview
- Week 4: ER / EER Models
  Week 4: ER / EER Models
  - Sep 10: Entity-Relationship Model
  - Sep 12: Enhanced ER Model (EER)
- Week 5: EER to Relational
  Week 5: EER to Relational
  - Sep 17: EER-Relational Mapping
  - Sep 19: GP1 Feedback, GitHub
- Week 6: Normalization
  Week 6: Normalization
  - Sep 24: Functional Dependencies
  - Sep 26: Normal Forms (3NF, BCNF)
- Week 7: Complex Queries
  Week 7: Complex Queries
  - Oct 01: Inner, Outer, Self Joins
  - Oct 03: GP2 Feedback, Set Ops
- Week 8: Midterm Exam
  Week 8: Midterm Exam
  - Oct 08: Review Weeks 1--7, venv
  - Oct 10: Midterm Exam
- Week 9: Fall Break
  Week 9: Fall Break
  - Oct 15: SQL Views, Group Database
- Week 10: Web Applications
  Week 10: Web Applications
  - Oct 22: Web Dev 101, Flask Setup
  - Oct 24: Jinja Templates, Charts
- Week 11: Query Processing
  Week 11: Query Processing
  - Oct 29: System Catalogs, Debugging
  - Oct 31: GP3 Feedback, SQL Injection
- Week 12: Transactions
  Week 12: Transactions
  - Nov 05: Indexes, Query Optimization
  - Nov 07: Transactions, SQL Functions
- Week 13: NoSQL Databases
  Week 13: NoSQL Databases
  - Nov 12: GP4 Feedback, Big Data
  - Nov 14: MongoDB, Non-Relational
- Week 14: Special Topics
  Week 14: Special Topics
  - Nov 19: GP5 Feedback, HW6 Intro
  - Nov 21: Full-Text Search Queries
- Week 15: Course Wrap-Up
  Week 15: Course Wrap-Up
  - Dec 03: Review for Final Exam
  - Dec 05: Project Presentations

Project

Redirecting…

Made with Material for MkDocs