University of Technology Sydney

31253 Database Programming

6cp; 3hpw (2hr lecture, 1hr tutorial)
Requisite(s): 31271 Database Fundamentals OR 31061 Database Principles OR 31474 Database Fundamentals OR 31487 Database Management Systems
Anti-requisite(s): 31099 Distributed Database Programming and Administration
Recommended studies:

it is assumed that students are familiar with basic database concepts; familiarity with the SQL language is mandatory and previous experience with at least one higher-level programming language is required



This subject teaches students how to design, develop and evaluate database programming and administration solutions to meet pre-defined quality characteristics of functionality (suitability, security), usability (operability), efficiency (time behaviour, resource utilisation), and maintainability (changeability, testability). Database programming and administration solutions are implemented using Oracle 11G, SQL*Plus and PL/SQL. Concepts, theories and technologies underlying the methods and techniques are introduced and explained as required. Students apply all that they have learnt to develop a small application to solve a database problem.

Typical availability

Autumn session, City campus

Detailed subject description.

Fee information

Information to assist with determining the applicable fee type can be found at Understanding fees.

Access conditions

Note: The requisite information presented in this subject description covers only academic requisites. Full details of all enforced rules, covering both academic and admission requisites, are available at access conditions and My Student Admin.