CIS3010 Oracle Development (FOBUS)

Semester 2 (ONC)Toowoomba (ONC)Fraser Cst (EXT)Toowoomba

Units 1.0 (Database Management) Band 2

Students are required to have access to a personal computer, e-mail capabilities and Internet access to USQConnect. Current details of computer requirements can be found at http://www.usq.edu.au/handbook/current/busgeninfo.html

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.