Go to Courses and units

Database Management unit (KXO206)

eStudent Enquire

Unit year 2025

View previous years unit information

Quick Help

Location: Shanghai Ocean University

Introduction

This unit takes student database skills beyond an elementary knowledge of the SQL (Structured Query Language) database language to a level where they can undertake significant database systems development using both SQL and Oracle's procedural extension to SQL, PL/SQL. This unit seeks to develop knowledge and skills in: The SQL*Plus programming environment Developing and debugging SQL scripts Developing and debugging PL/SQL scripts Generating formatted reports using the appropriate SQL*Plus environment variables

Summary

Unit name Database Management
Unit code KXO206
Credit points 12.5
College/School Sciences and Engineering
School of Information and Communication Technology
Discipline Information & Communication Technology
Coordinator Doctor Wenli Yang
Available as an elective? No
Delivered By Third Party(ies): Shanghai Ocean University AEIN Institute
Level Intermediate

Sustainable Development Goals

The Unit Coordinator has identified that this unit aligns with the following UN Sustainable Development Goals. We welcome your thoughts and feedback on the alignment of the unit with these goals.

Availability

Location Study period Attendance options Available to
Shanghai Ocean University Shanghai Semester 2 This unit is available through on-campus delivery Available to International Students
  • Key:
  • This unit is available through on-campus delivery On-campus
  • This unit is available through off-campus delivery Off-Campus
  • Available to International Students International students
  • Available to Domestic Students Domestic students
Note

Enrolment in units available at ECA Melbourne, Hong Kong Universal Ed, and Shanghai Ocean University is only available to eligible students studying at those corresponding locations.

Please check that your computer meets the minimum System Requirements if you are attending via Distance/Off-Campus.

Units are offered in attending mode unless otherwise indicated (that is attendance is required at the campus identified). A unit identified as offered by distance, that is there is no requirement for attendance, is identified with a nominal enrolment campus. A unit offered to both attending students and by distance from the same campus is identified as having both modes of study.

Learning Outcomes

  • Apply SQL and related technologies to access and maintain a relational database
  • Use SQL, PL/SQL and related technologies in creating a relational database
  • Explore issues involved in database design, implementation and management

Fee Information

Field of Education Commencing Student Contribution 1,3 Grandfathered Student Contribution 1,3 Approved Pathway Course Student Contribution 2,3 Domestic Full Fee 4
not applicable

1 Please refer to more information on student contribution amounts.
2 Please refer to more information on eligibility and Approved Pathway courses.
3 Please refer to more information on eligibility for HECS-HELP.
4 Please refer to more information on eligibility for FEE-HELP.

If you have any questions in relation to the fees, please contact UniConnect or more information is available on StudyAssist.

Please note: international students should refer to What is an indicative Fee? to get an indicative course cost.

Requisites

Prerequisites

KXO131 or KIT102

Teaching

Teaching Pattern

Teaching is grouped into 13 modules, including weekly lectures, workshops and independent learning activities.  

AssessmentWeekly Quizzes (15%)|Database Maintenance Report (25%)|In-Workshop SQL Test (25%)|Database Creation Report (35%)
TimetableView the lecture timetable | View the full unit timetable

Textbooks

Required

Casteel, J. (2015) Oracle 12c, SQL, Third Edition. Cengage. Boston MA. ISBN: 9781305251038

The University reserves the right to amend or remove courses and unit availabilities, as appropriate.