Course overview
The aim of this course is to provide the skills to interact with existing large sets that are structured or unstructured. The aim of this course is topics in this course include: concurrency and transaction management; data organisation, hash, indexes, query optimisation, active databases, and procedures; distributed database design, fragmentation, and replication; distributed transaction; data warehouse architecture and components; data warehouse modelling: star and snow flake; analysis: multidimensional Online Analytical Processing (OLAP) and relational OLAP; warehouse design, data uploading, updating and integration.
Course learning outcomes
- Use advanced tools to query and modify structured databases.
- Contrast the different types and uses of specialised databases.
- Design and use a data warehouses, and select appropriate data processing techniques on the data warehouses.
- Design queries to interact with unstructured datasets to retrieve sensible data.
- Compare and use data warehousing architectures.
Availability
Class details
Online
Class number 3077
Section 01OL
Size 500
Available 491
Notes:
Fee calculator
To display course fees, please select your status and program below:
We’re updating this Fee Calculator. It currently shows fees for programs only. Please check the relevant program for full fee details.
Study Abroad student tuition fees are available here.
Only some Postgraduate Coursework programs are available as Commonwealth Supported. Please check your program for specific fee information.
The Student Contribution amount displayed below is for students commencing a new program from 2021 onwards. If you are continuing in a program you commenced prior to 1 January 2021, or are commencing an Honours degree relating to an undergraduate degree you commenced prior to 1 January 2021, you may be charged a different Student Contribution amount from the amount displayed below. Please check the Student Contribution bands for continuing students here. If you are an international student, or a domestic student studying in a full fee paying place, and are continuing study that you commenced in 2025 or earlier, your fees will be available here before enrolments open for 2026.