Skip to main content
USQ Logo
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

Short Description: Oracle Development
Units : 1
Faculty or Section : Faculty of Health, Engineering and Sciences
School or Department : School of Agric, Comp and Environ Sciences
Student contribution band : Band 2
ASCED code : 020303 - Database Management
Grading basis : Graded
Version produced : 23 May 2019

Requisites

Pre-requisite: CIS2002

Other requisites

Students are required to have access to a personal computer, e-mail capabilities and Internet access to UConnect. 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, 2019 External
Semester 2, 2019 On-campus Toowoomba