Perform new course search

Search Filter

Corporate Database Application and Management PG (7862.3)

Level: Postgraduate Level
Credit Points: 3
HECS Bands: 2
Faculty: Faculty of Education, Science, Technology & Maths
Discipline: Academic Program Area - Maths & Technology

Availability

    Syllabus

    In this unit you will study key concepts about relational and hierarchical databases and their functionality in a mainframe environment, specifically DB2. You will gain knowledge and practical skills in designing, creating and using efficient and secure enterprise-level databases, including the use of SQL to manipulate databases and their content, and accessing databases in an application. You will learn about access control and how to monitor and manage databases for optimum performance. You will consider ethical issues about data quality, data management and privacy.

    Learning Outcomes

    DESCRIPTION:

    1. Understanding of relational databases and their functionality, architecture and anatomy of DB2 for z/OS, activities of database administration and define, manipulate and control DB2 for z/OS objects.

    2. Understanding of how to interface DB2 to programs to access DB2 for z/OS.

    3. Understanding XML, the importance of XML and XML Tables in DB2 for z/OS.

    4. Develop SQL to define, manipulate, and control objects on DB2 for z/OS.

    5. Develop DB2 Stored Procedures / Triggers to access and manipulate data on DB2 for z/OS.

    6. Develop SQL/XML to define, manipulate and convert between relational and XML.

    7. Use Commands, Utilities and Tools to administer databases on DB2 for z/OS.

    Contact Hours

    52 hours per semester.

    Prerequisites

    Mainframe Systems 1 G.


    Print this page
    ApplyEnquire
    Why choose UC

    Perform new course search

    Search Filter

    Frequently Asked Questions