CIS3010 Oracle Development (FOBUS)


Semester 2 (ONC)Toowoomba (EXT)Toowoomba

Semester 6 (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 UConnect. Internet access is also required to use the USQ Oracle server. Students who have not previously completed CIS2002 at USQ will need to study module 1 of the Study Book in some detail in order to gain an understanding of the fundamentals of data modelling and normalisation. Current details of computer requirements can be found at <http://www.usq.edu.au/ict/students/standards/default.htm>.


Synopsis

In this course, students build practical skills in the implementation of commercially oriented databases as well as the development of database queries and client and server-side database applications of limited scope. The course focuses on using data to solve business problems and the extraction of data that will facilitate corporate decision making. 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. The course is aligned with several examinations conducted by Oracle Corporation. The course covers the syllabus (as at 1 August, 2008) of the Oracle Database SQL Certified Expert exam and a significant proportion of the syllabus of the Oracle Certified Associate (OCA) exam (in the PL/SQL Developer stream).