31253 Database Programming6cp; 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
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.
Autumn session, City campus
Detailed subject description.
Information to assist with determining the applicable fee type can be found at Understanding fees.
- Commonwealth-supported students: view subject fees at Fees Search: Commonwealth-supported
- Postgraduate domestic fee-paying students: fees are charged according to the course enrolled in; refer to Domestic Fees Search: Postgraduate and Research
- International students: fees are charged according to the course enrolled in; refer to International Fees Search
- Subject EFTSL: 0.125