This subject introduces students to database programming and administration using the Oracle9i database server as an example. Following a brief overview of the architecture and operation of the Oracle9i database server, database administration tasks are described. Various database programming techniques including database stored procedures, functions, and triggers are then described. The subject contains a substantial practical component with exercises designed to support the various lecture topics.
Autumn semester, City campus