USQ Logo
The current and official versions of the course specifications are available on the web at https://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 Health, Engineering and Sciences
School or Department : School of Mathematics, Physics & Computing
Student contribution band : Band 2
Grading basis : Graded
Version produced : 17 May 2022

Requisites

Pre-requisite: CIS2002

Overview

The database is an integral and essential component of the overwhelming majority of information systems. The efficient daily operations of the organization, its business intelligence and long-term sustainability are all significantly dependent upon well managed and optimised databases. The vast majority of commercial applications utilise corporate databases extensively and many software vendors such as Oracle have designed procedural languages specifically to address the complex demands of database processing. It is desirable that students master the fundamentals of a major DBMS product and develop a critical understanding of current database technologies and trends, and their impact upon business. Students should also develop skills that will facilitate a critical understanding of complex business problems pertaining to databases and database management systems. Finally, it is also desirable that students develop practical skills in writing server-side and client-side applications of limited scope using a procedural database language.

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, 2022 On-campus Toowoomba
Semester 2, 2022 Online
Date printed 17 May 2022