Semester 1 (EXT)TWMBA
Semester 2 (EXT)TWMBA (ONC)TWMBA (ONC)WIBAY

Units 1.00 (Database Management) Band 2

Pre-requisite: CIS 2002 and CIS 1001

This course reviews and extends the relational database theory introduced in previous courses. Students gain an understanding of the practical considerations of the theory and in particular the application of the theory using Oracle tools. Students will extend their knowledge of SQL to cover Oracle's SQL dialect and will gain a working knowledge of Oracle's procedural extension to SQL known as PL/SQL. The course will cover client-side as well as server-side PL/SQL, the latter component focusing on stored procedures and triggers. Students extend the knowledge and skills gained in Database Design to create small database systems. Finally, students choose between selected topics in database theory or an introduction to Oracle's GUI tools Forms and Reports. The Oracle RDBMS and components of the Oracle toolset are used extensively in this course.

Check the course specification database for further information.