CSE232: Database system principles and implementation

Last office hours on Thursday 12:00-1:15

The finals have been graded. Unfortunately grades can not be announced on the Web. E-mail to the instructor to find out your grade

Required reading : Handouts

Suggested Reading :

Korth and Silberschatz, Database System Principles

Ullman, Principles of Database and Knowledge Base Systems, Vol I and II

Grading 30% Midterm 70% Final

Exercises on SQL and Query Processing

Solutions for SQL and query processing ( click here for the index drawings mentioned in the solutions of query processing exercises)

Topics and handouts of lectures

Relational model and SQL : Apr 1, Apr 3 , Apr 8 , Apr 10

Database System Architecture : Apr 10

File System Structure : Apr 10

Indexing

Query Processing and Optimization

Recovery : May 18

Concurrency Control : May 20 and May 25