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.

CIS2002 Database Design and Implementation

Short Description: Database Design & Implementa'n
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 : 26 April 2019

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 focuses on the design and implementation of relational databases and includes extensive exposure to Oracle SQL. Practical methodologies for data analysis, data modelling and database design are examined, coupled with study of the relational database model. The course builds applied skills in data modelling, normalisation, database design and the creation and management of database objects using Oracle SQL. 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 CIS3010 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.

Course offers

Semester Mode Campus
Semester 1, 2019 On-campus Springfield
Semester 1, 2019 On-campus Toowoomba
Semester 1, 2019 Online
Semester 3, 2019 Online