|Introduction to Databases (581328-9), Spring 2004|
This course is intended as a first year course in Computer Science. It assumes basic knowledge on programming (in Java), WWW and HTML. The 'Database design' part of the course assumes knowledge about UML class diagrams (taught in the course Introduction to Appication Analysis and Design).
The course covers the foundationss of relational databases: structure and use of the database, SQL database language and principles of programming database applications (in Java). The following list of topics lists also textbook material that may be used in addition to the lectures and e-learning material. Two alternatives are given. The textbook Ramakrishnan & Gehrke is the current text book of the course Database Management thus if you are considering to continue your database studies, you might consider buying this book. Elmasri & Navathe was the previuos text book of Database Management, and is still valid. It might be easier to get in the student library. The current edition of Elmasri & Navathe is 4th (since September 2003), but the chapters below are the chapters of the 3rd edition.
SQL practicing is carried out with the automated SQLTrainer practice environment.
|© Harri Laine||Updated: 11.3.2004, email: Harri.Laine@cs.helsinki.fi|