USQ LogoCourse specification
The current and official versions of the course specifications are available on the web at http://www.usq.edu.au/course/specification/current.
Please consult the web for updates that may occur during the year.

CIS3010 Oracle Development

Units : 1
Faculty or Section : Faculty of Business and Law
School or Department : School of Information Systems
Version produced : 21 July 2014

Other requisites

It is highly recommended that students complete CIS2002 or an equivalent course before commencing this course. 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, normalisation and SQL. Current details of computer requirements can be found at http://www.usq.edu.au/current-students/support/computing/hardware.

Synopsis

This course complements CIS2002 and an important focus is the architecture of the Oracle DBMS and procedural database programming in the Oracle environment. Students also extend and develop their critical knowledge of key topics and trends in database theory and practice, often in alignment with the applied coverage of Oracle. Beginning with a rapid review of SQL, the course moves into an extensive coverage of PL/SQL, Oracle's procedural extension to SQL. The course covers client-side as well as server-side PL/SQL, including anonymous blocks, packages, stored procedures, functions and triggers. Students gain extensive practical skills writing PL/SQL applications of limited scope to solve business problems and / or address business requirements. The course operates within a framework that focuses on developing business problem-solving and communication skills, and extensive use is made of business case studies of limited scope. This course and CIS2002 together provide students with extensive hands-on exposure to the Oracle DBMS and cover a significant proportion of the syllabus for the OCP (Oracle Certified Professional) designation. Upon completion of both courses, highly motivated students should be in a position to attempt two of the three papers leading towards the OCP and, depending upon the options chosen, become candidates for the designations of OCA (Oracle Certified Associate) and Oracle Database SQL Expert. In terms of our long-standing membership in the Oracle Academic Initiative, on-campus students are exposed to materials and exercises taken from official Oracle training courses and selected assessments are based upon these presentations.

Course offers

Semester Mode Campus
Semester 2, 2013 External
Semester 2, 2013 On-campus Toowoomba
Semester 6, 2013 External