Skip to content
CS 374, Fall 2025
HW5: Advanced SQL
Initializing search
Home
Syllabus
Calendar
Homework
Project
Labs
Notes
CS 374, Fall 2025
Home
Syllabus
Calendar
Homework
Homework
HW0: Getting Started
HW1: Beginning SQL
HW2: CRUD Operations
HW3: Intermediate SQL
HW4: Models and Data
HW5: Advanced SQL
Project
Project
GP1: Written Proposal
GP2: Conceptual Design
GP3: Relational Mapping
GP4: Admin Interface
GP5: Forms and Charts
GP6: Final Presentation
Labs
Labs
SQLite (DB Browser)
Python DB-API
Abstract ER Models
Reading EER Diagrams
EER Modeling Practice
pgAdmin -- PostgreSQL Tools
EER to Relational Mapping
Queries on the "tpch" Database
Setting Up an SSH Tunnel
Psycopg and Faker
Queries on the "air" Database
Scripts for Project Database
Flask-AppBuilder Tutorial
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: Air Database, Indexes
Week 10: Fall Break
Week 10: Fall Break
Oct 21: Database Scripts; Views
Week 11: Web Applications
Week 11: Web Applications
Oct 28: Intro to Flask-AppBuilder
Oct 30: Web Dev 101, Flask
Week 12: Complex Queries
Week 12: Complex Queries
Nov 04: Set Ops, Window Funcs
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
HW5: Advanced SQL
Due: Monday, Nov 10th
Coming soon…