Unit of competency Outline

Date retreived
22/07/2026 9:20 PM 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

Apply query language

Unit of competency
National Code
ICAPRG402A
State Code
D7996
TGA Status
Replaced
DTWD Status
Replaced
Current Release Number
1.00
Current Release Date
18/07/2011
View on TGA
State Implementation and Classification
Approved Date
06/10/2011
Field of Education
020103 - Programming
Original Release Date
06/10/2011
Nominal Hours
60
Description
This unit describes the performance outcomes, skills and knowledge required to retrieve and manipulate information stored in information systems using a query language.
Notes
Elements and Performance Criteria
1. Determine the requirements of developing queries
  • 1.1 Recognise various query-related terminologies
  • 1.2 Identify the type of data source for a chosen query language
  • 1.3 Identify and use necessary tools and environment in building queries
2. Write queries to retrieve and sort values
  • 2.1 Use an expression to retrieve values from a single unit
  • 2.2 Use an expression to combine values from more than one unit
  • 2.3 Use an expression to sort values into certain order
3. Write queries to selectively retrieve values
  • 3.1 Use an expression to filter a sequence based on a predicate or condition
  • 3.2 Use an expression to filter a subset of sequence based on a predicate or condition
  • 3.3 Use an expression to extract a specific value by position
4. Perform calculation in queries
  • 4.1 Use expression to perform calculation on numeric values
  • 4.2 Use expression to perform operation on text values
  • 4.3 Use expression to perform operation on date and time values
The range statement relates to the unit of competency as a whole. It allows for different work environments and situations that may affect performance. Bold italicised wording, if used in the performance criteria, is detailed below. Essential operating conditions that may be present with training and assessment (depending on the work situation, needs of the candidate, accessibility of the item, and local industry and regional contexts) may also be included.

Terminologies may include:
attribute
command
data item
expressions
item type
statement.
Data source may include:
arrays
databases
entities
enumerable classes
objects
text files
eXtensible markup language (XML).
Query language may include:
abstract object query language (AOQL)
XML
Google base query language (GBQL)
Java persistence query language (JPQL)
language integrated query (LINQ)
structured query language (SQL)
xQuery.
Tools may include:
application programming interface (API)
class libraries
database engine
integrated development environment (IDE)
programming language.
Expression may include:
function
operator
statement.
Unit may include:
node
object
result set
table.
The evidence guide provides advice on assessment and must be read in conjunction with the performance criteria, required skills and knowledge, range statement and the Assessment Guidelines for the Training Package.

Overview of assessment

Critical aspects for assessment and evidence required to demonstrate competency in this unit
Evidence of the ability to:
select and use tools in developing, storing and executing queries to extract the appropriate data required for ad hoc reports or to support developers
incorporate calculations using:
control statements
operators
functions.
Context of and specific resources for assessment
Assessment must ensure access to:
tools in:
accessing a data source
developing queries using the chosen query language
specific requirements, including client and functionality
policy and naming standard
resources to aid calculation
appropriate learning and assessment support when required
modified equipment for people with special needs.
Method of assessment
A range of assessment methods should be used to assess practical skills and knowledge. The following examples are appropriate for this unit:
evaluation of candidate’s ability to:
integrate query into larger systems to support application development team
implement programmability objects (such as stored procedures) containing queries stored in an information system to support operational functions
direct observation of candidate using query language to retrieve or manipulate data
verbal or written questioning to assess candidate’s knowledge of the features of the query language.
Guidance information for assessment
Holistic assessment with other units relevant to the industry sector, workplace and job role is recommended, where appropriate.
Assessment processes and techniques must be culturally appropriate, and suitable to the communication skill level, language, literacy and numeracy capacity of the candidate and the work being performed.
Indigenous people and other people from a non-English speaking background may need additional support.
In cases where practical assessment is used it should be combined with targeted questioning to assess required knowledge.
Replaced By
State Code National Code Title Type
AUV53 ICTPRG402 Apply query language Unit of competency