ITC200 Database Administration (8)
CSU Discipline Area: Computing (COMPU)
Duration: One session
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 Locations
| Session 1 | |
|---|---|
| Internal | CSU Study Centre Sydney | Session 2 |
| Internal | Bathurst |
| Internal | CSU Study Centre Melbourne |
| Internal | CSU Study Centre Sydney |
| Distance | Albury-Wodonga |
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.
Assumed Knowledge:
Objectives:
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.
The information contained in the 2013 CSU Handbook was accurate at the date of publication: 24 April 2013. The University reserves the right to vary the information at any time without notice.