Structured Data

Undergraduate | 2026

Course page banner
Mode icon
Mode
Mode
Your studies will be on-campus, and may include some online delivery
On campus
area/catalogue icon
Area/Catalogue
COMP 1003
Course ID icon
Course ID
200071
Campus icon
Campus
Mawson Lakes, Adelaide City Campus East
Level of study
Level of study
Undergraduate
Unit value icon
Unit value
6
Course owner
Course owner
Computer Science &InfoTech
Course level icon
Course level
1
Work Integrated Learning course
Work Integrated Learning course
No
Study abroad and student exchange icon
Inbound study abroad and exchange
Inbound study abroad and exchange
The fee you pay will depend on the number and type of courses you study.
Yes
University-wide elective icon
University-wide elective course
Yes
Single course enrollment
Single course enrolment
Yes
alt
Note:
Course data is interim and subject to change

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

Prerequisite(s)

N/A

Corequisite(s)

N/A

Antirequisite(s)

N/A