CIS2004 Database Applications Development with Oracle (FOBUS)


Semester 1 (EXT)Toowoomba

Semester 2 (ONC)Toowoomba (ONC)Wide Bay (EXT)Toowoomba


Units 1.0 (Database Management) Band 2


Pre-requisite: CIS1000 Co-requisite: CIS2002


Synopsis

In this course, students gain an understanding of the practical application of the techniques and theory covered in CIS2002 Students will gain a working knowledge of Oracle SQL and the procedural extension to SQL known as PL/SQL. The course will cover client-side as well as server-side PL/SQL, including stored procedures, functions and triggers. Finally, students extend their theoretical knowledge by studying a small number of selected topics in database theory.