Database Programming

UTS

Course Description

  • Course Name

    Database Programming

  • Host University

    UTS

  • Location

    Sydney, Australia

  • Area of Study

    Computer Info Systems, Computer Programming, Computer Science, Information Sciences, Information Technologies

  • Language Level

    Taught In English

  • Prerequisites

    31271 Database Fundamentals OR 31061 Database Principles OR 31474 Database Fundamentals OR 31487 Database Management Systems

    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

  • Course Level Recommendations

    Upper

    ISA offers course level recommendations in an effort to facilitate the determination of course levels by credential evaluators.We advice each institution to have their own credentials evaluator make the final decision regrading course levels.

    Hours & Credits

  • Credit Points

    6
  • Recommended U.S. Semester Credits
    4
  • Recommended U.S. Quarter Units
    6
  • Overview

    Description
    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.
     
    Subject objectives
    Upon successful completion of this subject students should be able to:
     
    1. Be able to describe the benefits of Database Programming
    2. Understand programming constructs available in PL/SQL.
    3. Understand how triggers, stored procedures and stored functions and database packages operate.
    4. Understand the current development methodology in modern database systems
    5. Describe the use of supplied packages in the Oracle database
    6. Have a basic understanding of the roles and responsibilities of a database administrator
    Teaching and learning strategies
    Each week there will be a 2 hour lecture and a 1 hour tutorial/lab. Lab sessions will be used to support the lectures with illustrative examples and exercise.
     
    Content
    Introduction to Database Programming, revision of SQL and an introduction to SQL*Plus, iSQL*Plus and the development tool SQL Developer
    PL/SQL language fundamentals, variables and built in functions
    Database procedures, functions, triggers and packages
    Error and exception handling
    File input/output from the database
    Dynamic SQL.
    Introduction and awareness of performance tuning
    Database administration
    Assessment
    Assessment task 1: Assignment 1
    Objective(s):
    This assessment task addresses the following subject learning objectives:
     
    1 and 2
     
    Weight: 20%
    Criteria linkages:
    Criteria Weight (%) SLOs CILOs
    1
    2
    SLOs: subject learning objectives
    CILOs: course intended learning outcomes
    Assessment task 2: Assignment 2
    Objective(s):
    This assessment task addresses the following subject learning objectives:
     
    4 and 5
     
    Weight: 30%
    Criteria linkages:
    Criteria Weight (%) SLOs CILOs
    4
    5
    SLOs: subject learning objectives
    CILOs: course intended learning outcomes
    Assessment task 3: Final Examination
    Objective(s):
    This assessment task addresses the following subject learning objectives:
     
    1, 2, 3, 4, 5 and 6
     
    Weight: 50%
    Criteria linkages:
    Criteria Weight (%) SLOs CILOs
    1
    2
    3
    4
    5
    6
    SLOs: subject learning objectives
    CILOs: course intended learning outcomes
    Minimum requirements
    Students must attain 50% of the total exam score to qualify for a pass in this subject. Accordingly, exam scores below 50% will result in a fail with a final grade of X.
    Student Attendance:
    The Faculty of Engineering and Information Technology expects that students will attend all scheduled sessions for a Subject in which they are enrolled.

Course Disclaimer

Courses and course hours of instruction are subject to change.

Credits earned vary according to the policies of the students' home institutions. According to ISA policy and possible visa requirements, students must maintain full-time enrollment status, as determined by their home institutions, for the duration of the program.