Unit of competency Outline

Date retreived
22/07/2026 10:14 AM AWST

Whilst all efforts are made to provide accurate and timely information from the relevant source/documentation, please be aware that the information supplied may not be the most current version. The accuracy of the detail has not been confirmed by the Department and therefore should not be relied upon without first confirming the contents.

Apply query language in relational databases

Apply query language in relational databases

Unit of competency
National Code
ICTPRG431
State Code
OBT25
TGA Status
Current
DTWD Status
Approved
Current Release Number
1.00
Current Release Date
21/07/2020
View on TGA
State Implementation and Classification
Approved Date
15/01/2021
Field of Education
020103 - Programming
Original Release Date
15/01/2021
Nominal Hours
55
Description
This unit describes the skills and knowledge required to retrieve and manipulate information stored in information systems using a query language.It applies to those who are involved in a range of work environments, who are required to extract information from a relational database by creating and running queries.No licensing, legislative or certification requirements apply to this unit at the time of publication.
Notes
Elements and Performance Criteria
1. Determine requirements of developing queries
  • 1.1 Identify terminologies applicable to query language
  • 1.2 Identify and build queries using required tools and environment
2. Write queries to extract required information
  • 2.1 Sort and selectively retrieve values through query writing
  • 2.2 Aggregate records by multiple attributes using an expression
  • 2.3 Sort and filter aggregated records using an expression
  • 2.4 Create queries and retrieve records from multiple tables
  • 2.5 Retrieve records from multiple tables using different expressions and approaches
  • 2.6 Filter records from multiple tables using an expression
  • 2.7 Retrieve records from multiple tables using expressions, set operators and set logic
  • 2.8 Construct and execute sub-queries
3. Perform calculations and use expressions in queries
  • 3.1 Perform a calculation on numeric values and an operation on text values using an expression
  • 3.2 Perform an operation on date and time values using functions
  • 3.3 Aggregate values and obtain required output using an expression
4. Create and manipulate tables
  • 4.1 Identify required columns, data types, keys, relationships, indexes and constraints
  • 4.2 Use required naming conventions for database elements
  • 4.3 Create tables that implement required elements and use check constraints
  • 4.4 Manipulate tables according to specific requirements
5. Create and use views and stored procedures
  • 5.1 Create views according to information requirements
  • 5.2 Retrieve and save data using a view and transactions
  • 5.3 Drop a view from a database
  • 5.4 Retrieve, insert and modify data using created and stored procedures according to information requirements
  • 5.5 Create and execute stored procedures using one or more parameters
  • 5.6 Drop a stored procedure from database
  • 5.7 Create and test database triggers and perform specific required data-related functions
No information
No information
Replaces
State Code National Code Title Type
AUV53 ICTPRG402 Apply query language Unit of competency