Computer Laboratory > Teaching > Course material 2008–09 > Computer Science Tripos Syllabus and Booklist 2008-2009 > Databases

next up previous contents
Next: Digital Communication I Up: Lent Term 2009: Part Previous: Concepts in Programming Languages   Contents


Databases

Lecturer: Dr T.G. Griffin

No. of lectures: 12

Aims

The overall aim of the course is to cover the fundamentals of database management systems (DBMSs), paying particular attention to relational database systems. The course covers modelling techniques, transferring designs to actual database implementations, SQL, models of query languages, transactions as well as more recent developments, including data warehouses and On-line Analytical Processing (OLAP), and use of XML as a data exchange language. The lectures will make use of the open source DBMS, MySQL.

Lectures

Objectives

At the end of the course students should

Recommended reading

* Date, C.J. (2004). An introduction to database systems. Addison-Wesley (8th ed.).
Elmasri, R. & Navathe, S.B. (2000). Fundamentals of database systems. Addison-Wesley (3rd ed.).
Silberschatz, A., Korth, H.F. & Sudarshan, S. (2002). Database system concepts. McGraw-Hill (4th ed.).
Ullman, J. & Widom, J. (1997). A first course in database systems. Prentice Hall.
Miszczyk, J. and others (1998). Mastering Data Warehousing Functions. (IBM Redbook DB2/400) Chapters 1 & 2 only. http://www.redbooks.ibm.com/abstracts/sg245184.html
Garcia-Molina, H. Data Warehousing and OLAP. Stanford University. http://www.cs.uh.edu/ ceick/6340/dw-olap.ppt
London Metropolitan University, Department of Computing. Data Warehousing and OLAP Technology for Data Mining. http://learning.unl.ac.uk/csp002n/CSP002N_wk2.ppt



next up previous contents
Next: Digital Communication I Up: Lent Term 2009: Part Previous: Concepts in Programming Languages   Contents