Course Title: Use structured query language

Part A: Course Overview

Program: C5300

Course Title: Use structured query language

Portfolio: BUS

Nominal Hours: 60.0

Regardless of the mode of delivery, represent a guide to the relative teaching time and student effort required to successfully achieve a particular competency/module. This may include not only scheduled classes or workplace visits but also the amount of effort required to undertake, evaluate and complete all assessment requirements, including any non-classroom activities.

Course Code




Learning Mode

Teaching Period(s)


City Campus


650T Vocational Business Education

Face-to-Face or Internet or Workplace

Term2 2012,
Term1 2013,
Term2 2013,
Term1 2014,
Term2 2014,
Term1 2015,
Term2 2015

Course Contact: Chandra Nannegari

Course Contact Phone: +61 3 99251657

Course Contact Email:

Course Description

This unit describes the performance outcomes, skills and knowledge required to use a structured query language (SQL) to define, create and manipulate database structures and associated data in a relational database.

This unit is delivered using a blend of classroom based and self-paced learning activities.

Pre-requisite Courses and Assumed Knowledge and Capabilities


National Competency Codes and Titles

National Element Code & Title:

ICAPRG425A Use structured query language


1. Write a simple SQL statement to retrieve and sort data

2. Write an SQL statement that selectively retrieves data

3. Write SQL statements that use functions

4. Write SQL statements that use aggregation and filtering

5. Write SQL statements that retrieve data from multiple tables

6. Write and execute SQL sub-queries

7. Create and manipulate tables

8. Create and use views

9. Create and use stored procedures

Learning Outcomes

Overview of Assessment

Students must demonstrate an understanding of all elements of competency to be deemed competent.

A range of assessment methods are used to assess practical skills and knowledge, for example:
• direct questioning combined with review of portfolios of evidence and third party workplace reports of on-the-job performance by the candidate
• review of authenticated documents from the workplace or training environment
• demonstration of techniques

Students are advised that they are likely to be asked to personally demonstrate their assessment work to their teacher to ensure that the relevant competency standards are being met.