Unit of competency
Modification History
Release |
Comments |
Release 1 |
This version first released with ICT Information and Communications Technology Training Package Version 1.0. |
Application
This unit describes the skills and knowledge required to retrieve and manipulate information stored in information systems, using a query language.
It applies to individuals in a range of work environments, who are required to extract information from a source such as a database, a text file, or an extensible markup language (XML), by creating and running queries.
No licensing, legislative or certification requirements apply to this unit at the time of publication.
Unit Sector
Programming and software development
Elements and Performance Criteria
ELEMENT |
PERFORMANCE CRITERIA |
Elements describe the essential outcomes. |
Performance criteria describe the performance needed to demonstrate achievement of the element. |
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 the 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 a certain order |
3. Write queries to selectively retrieve values |
3.1 Use an expression to filter a sequence, based on a predicate or a condition 3.2 Use an expression to filter the subset of a sequence, based on a predicate or a condition 3.3 Use an expression to extract a specific value by position |
4. Perform a calculation in queries |
4.1 Use an expression to perform a calculation on numeric values 4.2 Use an expression to perform an operation on text values 4.3 Use an expression to perform an operation on date and time values |
Foundation Skills
This section describes language, literacy, numeracy and employment skills incorporated in the performance criteria that are required for competent performance.
Skill |
Performance Criteria |
Description |
Reading |
1.1, 1.2, 1.3 |
|
Writing |
2.1-4.3 |
|
Numeracy |
2.1, 2.2, 2.3, 3.1, 3.2, 3.3, 4.1, 4.2, 4.3 |
|
Get the work done |
1.3, 2.1, 2.2, 2.3, 3.1, 3.2, 3.3, 4.1, 4.2, 4.3 |
|
Unit Mapping Information
Code and title current version |
Code and title previous version |
Comments |
Equivalence status |
ICTPRG402 Apply query language |
ICAPRG402A Apply query language |
Updated to meet Standards for Training Packages |
Equivalent unit |
Links
Companion Volume implementation guides are found in VETNet - https://vetnet.gov.au/Pages/TrainingDocs.aspx?q=a53af4e4-b400-484e-b778-71c9e9d6aff2