Advanced Databases, Warehouses and The Cloud

Course aim

To introduce the theory and practice of databases, data warehouses and data management in the cloud environment. To design and query relational and non relational databases, including data warehouses and cloud databases.

Course content

The relational model and database constraints; Data management and retrieval using SQL; Database conceptual design; Database logical design; Data warehouse architecture and components; Star and snow flake schemas; the Multidimensional model; the Relational model for OLAP; Data warehouse design; Data upload and update; Reporting and analysis; Cloud databases and warehouses; Use of Hadoop and Big Data in Data Warehouses; and Present novel and emerging structures in databases appearing in the real world.

 

Textbook(s)

Jukic, N 2020, Database Systems: Introduction to Databases and Data Warehouses, 2nd edition

Prerequisite(s)

Common to all relevant programs
Subject Area & Catalogue Number	Course Name
INFS 5144	Data Wrangling and Social Media Analytics
INFS 4020	Big Data Concepts

Corequisite(s)

Nil

Teaching method

Component	Duration
INTERNAL, MAWSON LAKES
Seminar	2 hours x 13 weeks
Computer Practical	1 hour x 12 weeks
INTERNAL, CITY WEST
Seminar	2 hours x 13 weeks
Computer Practical	1 hour x 12 weeks
EXTERNAL, MAWSON LAKES, ONLINE
Online	2 hours x 13 weeks

Note: These components may or may not be scheduled in every study period. Please refer to the timetable for further details.

Assessment

Assignment, Critical analysis, Skills demonstration

Fees

EFTSL*: 0.125
Commonwealth Supported program (Band 2)
To determine the fee for this course as part of a Commonwealth Supported program, go to:
How to determine your Commonwealth Supported course fee. (Opens new window)

Fee-paying program for domestic and international students
International students and students undertaking this course as part of a postgraduate fee paying program must refer to the relevant program home page to determine the cost for undertaking this course.

Non-award enrolment
Non-award tuition fees are set by the university. To determine the cost of this course, go to:
How to determine the relevant non award tuition fee. (Opens new window)

Not all courses are available on all of the above bases, and students must check to ensure that they are permitted to enrol in a particular course.

* Equivalent Full Time Study Load. Please note: all EFTSL values are published and calculated at ten decimal places. Values are displayed to three decimal places for ease of interpretation.