Unit of Competency Mapping – Information for Teachers/Assessors – Information for Learners
ICAPRG402A Mapping and Delivery Guide
Apply query language
Version 1.0
Issue Date: May 2024
Qualification | - |
Unit of Competency | ICAPRG402A - Apply query language |
---|---|---|---|
Description | This unit describes the performance outcomes, skills and knowledge required to retrieve and manipulate information stored in information systems using a query language. | ||
Employability Skills | This unit contains employability skills. | ||
Learning Outcomes and Application | This unit applies to individuals in a range of work environments who are required to extract information from a source, such as database, text file, and eXtensible markup language (XML), by creating and running queries.These individuals may support the job functions of managers and developers. They may work as application support, database support, junior IT administrator, database programmer and data programmer. | ||
Duration and Setting | X weeks, nominally xx hours, delivered in a classroom/online/blended learning setting. |
||
Prerequisites/co-requisites | Not applicable. | ||
Competency Field |
Development and validation strategy and guide for assessors and learners | Student Learning Resources | Handouts Activities |
Slides PPT |
Assessment 1 | Assessment 2 | Assessment 3 | Assessment 4 | |
---|---|---|---|---|---|---|---|---|
Elements of Competency | Performance Criteria | |||||||
Element: Determine the requirements of developing queries |
| |||||||
Element: Write queries to retrieve and sort values |
| |||||||
Element: Write queries to selectively retrieve values |
| |||||||
Element: Perform calculation in queries |
|