Skip to content
CS 374, Fall 2024
Oct 29: SQL Injection, More Jinja
Initializing search
Home
Syllabus
Calendar
Homework
Labs
Notes
CS 374, Fall 2024
Home
Syllabus
Calendar
Homework
Homework
HW0: Getting Started
HW1: CRUD Operations
Labs
Labs
SQLite (DB Browser)
Python DB-API
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: Referential Integrity
Sep 05: Project Overview, DDL
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: pgAdmin, Joins, Subqueries
Oct 03: GP2 Feedback, Set Ops
Week 8: Data Generation
Week 8: Data Generation
Oct 08: Views, Generating Data
Oct 10: Review Weeks 1--8
Week 9: Fall Break
Week 9: Fall Break
Oct 15: Midterm Exam
Week 10: Web Applications
Week 10: Web Applications
Oct 22: GP3 Feedback, Flask
Oct 24: Web Dev 101, Charts API
Week 11: Query Processing
Week 11: Query Processing
Oct 29: SQL Injection, More Jinja
Oct 31: Indexes, Catalogs, Optimizer
Week 12: Transactions
Week 12: Transactions
Nov 05: GP4 Feedback, Transactions
Nov 07: Procedural SQL, Functions
Week 13: Complex Data
Week 13: Complex Data
Nov 12: Full Text Search
Nov 14: Semi-structured Data
Week 14: NoSQL Databases
Week 14: NoSQL Databases
Nov 19: GP5 Feedback, Big Data
Nov 21: MongoDB, Non-Relational
Week 15: Course Wrap-Up
Week 15: Course Wrap-Up
Dec 03: Review for Final Exam
Dec 05: Project Presentations
Oct 29: SQL Injection, More Jinja
Back to top