Data models and query languages. Database design, building database applications. File structures, indexing, and hashing methods. Query processing and optimization. Transactions, concurrency control and recovery, security and authorization, database performance. Material as covered in CS145 and CS245.
H. Garcia-Molina, J.D. Ullman, and J. Widom
Database Systems: The Complete Book
Prentice-Hall, 2002
All chapters