Database Management unit (KXO206)

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 Sumbal Maqsood
Available as an elective?	No
Delivered By	Third Party(ies): Shanghai Ocean University AEIN Institute
Level	Intermediate

Availability

Specific information on 2027 unit availability will be available in August

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

2027 fee information will be available in August.

Requisites

Prerequisites

KXO131 or KIT102

Teaching

Teaching Pattern	Teaching is grouped into 13 modules, including weekly lectures, workshops and independent learning activities.
Assessment	Weekly Quizzes (15%)|Database Maintenance Report (25%)|In-Workshop SQL Test (25%)|Database Creation Report (35%)
Timetable	View 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.