Skip to content

CS 374, Spring 2024

Mar 07: Midterm Exam

Initializing search

Home
Syllabus
Calendar
Homework
Labs
Notes

CS 374, Spring 2024

Home
Syllabus
Calendar
Homework
Homework
Labs
Labs
Notes
Notes
- Week 1: Introduction
  Week 1: Introduction
  - Jan 16: Getting Started
  - Jan 18: Course Overview
- Week 2: ER / EER Models
  Week 2: ER / EER Models
  - Jan 23: ER Models
  - Jan 25: EER Models
- Week 3: Relational Model
  Week 3: Relational Model
  - Jan 30: EER Wrap-Up
  - Feb 01: Intro to SQLite
- Week 4: EER to Relational
  Week 4: EER to Relational
  - Feb 06: Assessment Day
  - Feb 08: Relational Mapping
- Week 5: DDL and DML
  Week 5: DDL and DML
  - Feb 13: Creating Tables
  - Feb 15: Modifying Data
- Week 6: SQL: Basics
  Week 6: SQL: Basics
  - Feb 20: GROUP BY, Aggregation
  - Feb 22: JOINS, DISTINCT, psql
- Week 7: SQL: Complex
  Week 7: SQL: Complex
  - Feb 27: Subqueries, Set Operations
  - Feb 29: Query Optimization
- Week 8: Midterm Exam
  Week 8: Midterm Exam
  - Mar 05: Review Weeks 1–7
  - Mar 07: Midterm Exam
- Week 9: Normalization
  Week 9: Normalization
  - Mar 19: Functional Dependencies
  - Mar 21: Normal Forms (3NF and BCNF)
- Week 10: Data Storage
  Week 10: Data Storage
  - Mar 26: GP1 Feedback, GitHub
  - Mar 28: Storage, GP2 Scripts
- Week 11: Web Applications
  Week 11: Web Applications
  - Apr 02: GP2 Feedback, Flask
  - Apr 04: Creating Data, DB-API
- Week 12: DB Programming
  Week 12: DB Programming
  - Apr 09: SQL Functions, Table Charts
  - Apr 11: SQL Injection, Debugging
- Week 13: Transactions
  Week 13: Transactions
  - Apr 16: GP4 Feedback, Transactions
  - Apr 18: Transactions in Python/Flask
- Week 14: NoSQL Databases
  Week 14: NoSQL Databases
  - Apr 23: GP5 Feedback, Big Data
  - Apr 25: MongoDB, Non-Relational
- Week 15: Course Wrap-Up
  Week 15: Course Wrap-Up
  - Apr 30: Project Presentations
  - May 02: Review for Final Exam

Mar 07: Midterm Exam

Made with Material for MkDocs