ITI585 Database Administration Fundamentals 1 (8)

In this subject students will gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another. Students will also learn how to create an operational database and properly manage the various structures in an effective and efficient manner including performance monitoring, database security, user management, and backup/recovery techniques.

Subject Outlines
Current CSU students can view Subject Outlines for recent sessions. Please note that Subject Outlines and assessment tasks are updated each session.

No offerings have been identified for this subject in 2018.

Where differences exist between the Handbook and the SAL, the SAL should be taken as containing the correct subject offering details.

Subject Information

Grading System



One session


School of Computing and Mathematics

Enrolment Restrictions

Only for students enrolled in the following courses:
Master of Database Design and Management
Master of Networking and System Administration
Master of Systems Development
Master of Information Systems Security
Master of Management (IT) - MMgtInfoTech
Graduate Certificate in Management (IT) - GradCertMgtInfoTech



Learning Outcomes

Upon successful completion of this subject, students should:

be able to install and configure the Oracle Database 10g;
be able to create and administer user accounts in the Oracle Database 10g;
be able to backup and Recovery of the Oracle Database 10g;
be able to monitor, troubleshoot, and maintain the Oracle Database 10g; and
be able to configure Oracle Net services for the Oracle Database 10g.


This subject will cover the following topics:

Installing Oracle Database 10g Software.

Create an Oracle Database.

Database interfaces.

Controlling the database.

Storage Structures.

Administering users.

Managing Schema Objects.

Managing Data.


Oracle Database Security.

Oracle Net Services.

Oracle Shared Server.

Performance Monitoring.

Proactive Maintenance: Objectives.

Undo Management.

Monitoring and Resolving Lock Conflicts.

Backup and Recovery Concepts.

Database backups.

Database Recovery.


Current Students

For any enquiries about subject selection or course structure please contact Student Central or or phone on 1800 275 278.

Prospective Students

For further information about Charles Sturt University, or this course offering, please contact info.csu on 1800 275 278 (free call within Australia) or enquire online.

The information contained in the 2018 CSU Handbook was accurate at the date of publication: August 2018. The University reserves the right to vary the information at any time without notice.