Recitation sections for CSE 444
-
Week 1 (January 6): IISQLSRV and SQL introduction
Slides,
SQL seen in section
-
Week 2 (January 13): SQL practice
Slides,
Table schema
SQL seen in section
-
Week 3 (January 20): E/R diagrams, functional dependencies, BCNF
Slides
-
Week 4 (January 27): JDBC, database updates, and SQL transactions
Slides,
original Java program,
complete program
-
Week 5 (February 3): Logging and conflict-serializability
Slides
-
Week 6 (February 10): Triggers and access control
Slides
Week 6: Extra optimistic concurrency control examples
Worksheet,
Solutions
-
Week 7 (February 17): Relational algebra and query exectuion
Slides,
Worksheet,
Solutions
-
Week 8 (February 24): Tools for project 4
Reference material:
preliminaries,
AWS usage,
Slides
-
Week 10 (March 3): Query Optimization and Pig Latin
Slides
-
Week 11 (March 10): Final exam review
Sample problems,
solutions