Recitation sections for CSE 444
- Week 1 (June 24): SQL introduction
Slides,
solutions to extra problems
- Week 2 (July 1): Grouping, updates, and E/R diagrams
Slides
(from section AA,
section AB),
solutions to extra problems worked in class
- Week 3 (July 8): BCNF,
JDBC
Slides
- Week 4 (July 15): Logging and conflict-serializability
Slides
- Week 5 (July 22): Concurrency control
Worksheet,
solution
- Week 6 (July 29): Triggers and access control
Slides,
PostgreSQL example code
- Week 7 (August 5): Relational algebra and query execution
Worksheet,
solution
- Week 8 (August 12): Tools for project 4
Reference material:
preliminaries,
AWS usage
- Week 9 (August 19): Review for final/second midterm
Sample problems,
solutions