ITC200 Database Administration (8)

Abstract

This subject is designed to give students an applied, practical introduction to database administration. Students will gain an understanding of the functioning of a database management system and its relationship to the computing environment in which it runs. Students will learn the concepts, principles, and techniques necessary to carry out such functions as database object creation, storage management and capacity planning, performance tuning, backup and recovery, and security management. The subject will use a standard relational database management system (RDBMS) as a platform for class instruction and assignments.

+ Subject Availability Modes and Location

Session 1
Internal	CSU Study Centre Sydney
Session 2
Internal	Bathurst Campus
Internal	CSU Study Centre Melbourne
Internal	CSU Study Centre Sydney
Distance	Albury-Wodonga Campus
Session 3
Internal	CSU Study Centre Sydney

Continuing students should consult the SAL for current offering details: ITC200
Where differences exist between the Handbook and the SAL, the SAL should be taken as containing the correct subject offering details.

Subject information

Duration	Grading System	School:
One session	HD/FL	School of Computing and Mathematics

Learning Outcomes

Upon successful completion of this subject, students should:
* be able to define the roles, issues, and tasks associated with the database administration function;
* be able to describe the computer system and database management system (DBMS) architecture;
* be able to explain how the DBMS stores and maintains data, executes queries, and performs other data management tasks;
* be able to create a variety of database objects, such as tablespaces, indexes, and user objects;
* be able to plan and implement the physical organisation of a database;
* be able to interpret and use the system catalogue in a variety of database administration tasks;
* be able to gather, interpret, and act on database statistics to monitor database activity and tune for performance;
* be able to plan and execute backup and recovery activities; and
* be able to secure the database and manage users.

Syllabus

The subject will cover the following topics:
* Introduction to the roles, issues, and tasks associated with the database administration function. * The system architecture and its relationship to the DBMS architecture. * The role and use of the data dictionary. * Database physical design and organisation including database object creation. * Transaction processing including lock management and rollback segment management. * Query processing and the role of triggers. * User administration and security procedures. * Compare and contrast major RDBMS software applications. * Database reorganisation, performance monitoring and tuning. * Strategies and techniques for backup and recovery.

Back