Database Development for the Cloud
Overview
This unit prepares students to demonstrate knowledge of designing and developing database systems on cloud infrastructure. Students will undertake the basics of create, read, update and delete of database records. This unit will also discuss basic architecture and potential use cases for the setup of database systems for the collection, analysing and presenting data.
Requisites
15-December-2024
15-December-2024
09-May-2025
04-July-2025
05-December-2025
Learning outcomes
Students who successfully complete this unit will be able to:
- Understand essential database requirements to perform data manipulation
- Perform create, read, update and delete tasks to data set
- Analyse requirements and conduct ETL of large datasets in the cloud
- Determine appropriate database management system type for cloud deployment
- Use tools to ensure optimization of dynamic datasets
Teaching methods
Hawthorn
| Type | Hours per week | Number of weeks | Total (number of hours) |
|---|---|---|---|
| Face to Face Contact (Phasing out) Laboratory | 3.00 | 13 week | 39 |
| Face to Face Contact (Phasing out) Laboratory | 3.00 | 13 week | 39 |
| Unspecified Learning Activities (Phasing out) Independent Learning | 3.54 | 13 week | 46 |
| Online Directed Online Learning and Independent Learning | 2.00 | 13 week | 26 |
| TOTAL | 150 |
Assessment
| Type | Task | Weighting | ULO's |
|---|---|---|---|
| Assignment | Group | 40 - 60% | 2,3,4,5 |
| Test | Individual | 30 - 40% | 2,3,5 |
| Test | Individual | 10 - 20% | 1,2 |
Hurdle
As the minimum requirements of assessment to pass a unit and meet all ULOs to a minimum standard, an undergraduate student must have achieved:
- An aggregate mark for the unit of 50% or more, including
- At least 35% of the possible final marks for each Major Assessment Component (any assessment worth 20% or more)
- At least 45% in the final exam
Â
Students who do not achieve at least 35% of the possible final marks for each Major Assessment Component and at least 45% for the final exam (if applicable), will receive a maximum of 44% as the total mark for the unit and will not be eligible for a conceded pass.Â
Â
The Major Assessment Components in this unit are the Online Activities (combined grade), Computer Lab Reports (combined grade) and the Exam.Â
Content
- CRUD for Databases
- Identify appropriate cloud services
- Managing and Executing ETL
-
Prepare cloud services for data scalability
Types of data including structured, semi-structured and unstructured
Data storage types including database, data lakes, data warehouses and data marts Data schema
- Identifying opportunities to create business value through use of BI concepts and tools.
Study resources
Reading materials
A list of reading materials and/or required textbooks will be available in the Unit Outline on Canvas.