Database Administration

INF30010 12.5 Credit Points Hawthorn Available to incoming Study Abroad and Exchange students

Duration

  • One Semester or equivalent  

Contact hours

  • 36 Hours

On-campus unit delivery combines face-to-face and digital learning.

2022 teaching periods

Hawthorn

Higher Ed. Semester 2

Dates:
1 Aug 22 - 30 Oct 22

Results:
6 Dec 22

Last self enrolment:
14 Aug 22

Census:
31 Aug 22

Last withdraw without fail:
16 Sep 22


Prerequisites

150 Credit Points
 
 
Concurrent Pre-requisites :
A unit can be either completed prior to commencing study or taken at the same time.
 

Corequisites

Nil
 

Aims and objectives

Modern databases typically have very large data holdings and are faced with completing huge numbers of transactions. Effective administration is needed to ensure databases function at their optimum against organisational requirements. This unit aims to deliver a set of concepts and tools that can both enable and improve database administration. Students will use these approaches to both setup and assess design and implementation options that improve databases performance. Typical performance problems will be investigated and remedied using appropriate tuning options. The potential of distributed databases, replicated databases, and data warehouses will be explored.
 
Students who complete this unit will be able to
 
1. Apply concepts and techniques for completing key database administration tasks
 
2. Analyse an organisation’s database performance requirements and recommend strategies for improvement
 
3. Individually and collaboratively use database performance tuning tools to optimise database performance
 
4. Evaluate the distribution of databases over multiple servers within an organisation with particular reference to performance improvement