Course overview
The course will equip students with the knowledge and skills required to implement and work with structured data in relational database systems. Through theoretical exploration and practical application, students will learn to capture data accurately, write queries to extract information, and the basics of managing data security. The topics covered will provide students with a solid foundation for real-world data management in business.
- Introduction to Relational Databases
- Database Design and Modelling
- Data Definition Language (DDL) and Data Manipulation Language (DML)
- Queries
- Data Manipulation Language (Part 1)
- Data Manipulation Language (Part 2)
- Views and Common Table Expressions
- Stored Procedures
- Indexes
- Control Data Language
Course learning outcomes
- Explain how data is stored and retrieved from a relational database and the advantages of using the relational model
- Design a relational database given a set of data and usage requirements
- Design and implement database queries to retrieve specified data from a relational database
- Explain how a query interacts with data within a relational database system and the impact design can have on management, retrieval and efficiency
- Demonstrate approaches to securing data access within a database
- Select for efficiency between alternative query options
Availability
Class details
Mawson Lakes
Group 1
Class number 27171
Section FR02
Size 125
Available 119
Notes:
Class number 27172
Section FR01
Size 135
Available 133
Class number 27132
Section PR04
Size 60
Available 60
Class number 27133
Section PR03
Size 60
Available 56
Class number 27134
Section PR02
Size 80
Available 76
Class number 27135
Section PR01
Size 80
Available 80
Notes:
Adelaide City Campus East
Group 1
Class number 27143
Section FR02
Size 270
Available 265
Class number 27144
Section FR01
Size 270
Available 252
Class number 27136
Section PR07
Size 63
Available 52
Class number 27137
Section PR06
Size 63
Available 62
Class number 27138
Section PR05
Size 80
Available 80
Class number 27139
Section PR04
Size 68
Available 68
Class number 27140
Section PR03
Size 70
Available 68
Class number 27141
Section PR02
Size 70
Available 68
Class number 27142
Section PR01
Size 80
Available 77
Class number 28095
Section PR08
Size 46
Available 42
Class details
Mawson Lakes
Group 1
Class number 61907
Section PR01
Size 40
Available 40
Class number 62237
Section FR01
Size 40
Available 40
Adelaide City Campus East
Group 1
Class number 62234
Section PR03
Size 55
Available 54
Class number 62235
Section PR02
Size 55
Available 54
Class number 62236
Section PR01
Size 55
Available 54
Class number 62238
Section FR01
Size 165
Available 162
Fee calculator
To display course fees for 2027, select your status and program below:
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.
If you are studying in a Professional Pathway Psychology, Clinical Psychology or Social Work program, please refer to the Student Contributions amounts published here.
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.