Skip to content
CS 374, Fall 2024
Dec 05: Project Presentations
Initializing search
Home
Syllabus
Calendar
Homework
Project
Labs
Notes
CS 374, Fall 2024
Home
Syllabus
Calendar
Homework
Homework
HW0: Getting Started
HW1: CRUD Operations
HW2: Basic SQL Queries
HW3: Relational Mapping
HW4: Intermediate SQL
HW5: Basic Flask App
Project
Project
GP1: Written Proposal
GP2: Schema Design
GP3: Data and Queries
GP4: Views and Charts
GP5: Working Prototype
Labs
Labs
SQLite (DB Browser)
Python DB-API
Relational Concepts in MySQL
Abstract ER Model
Reading EER Diagrams
EER to Relational Mapping using MySQL Workbench
pgAdmin -- PostgreSQL Tools
Normalization Exercises
Queries on the `tpch` database
Queries on the `air` database
Setting up an SSH tunnel
Writing Queries for MongoDB
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, Similarity
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
Dec 05: Project Presentations
Back to top