University of Technology Sydney

31253 Database Programming

6cp; 3hpw (2hr lecture, 1hr tutorial). Forms of attendance, mode of delivery and assessment requirements in this subject have changed to enable social distancing and reduce the risks of spreading COVID-19 in our community. Consequently, the Subject Outline information for this subject has changed. Details of the changes are published in an addendum to the Subject Outline which is available on UTSOnline/Canvas.
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.