Skip to content

CS 374, Fall 2024

Oct 01: pgAdmin, Joins, Subqueries

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 01: pgAdmin, Joins, Subqueries