Modification History
|
Release |
Comments |
|
Release 1 |
This Unit first released with ICA11 Information and Communications Technology Training Package version 1.0 |
Unit Descriptor
This unit describes the performance outcomes, skills and knowledge required to retrieve and manipulate information stored in information systems using a query language.
Application of the Unit
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.
Licensing/Regulatory Information
No licensing, legislative, regulatory or certification requirements apply to this unit at the time of endorsement but users should confirm requirements with the relevant federal, state or territory authority.
Pre-Requisites
Not applicable.
Employability Skills Information
This unit contains employability skills.
Elements and Performance Criteria Pre-Content
|
Element |
Performance Criteria |
|
Elements describe the essential outcomes of a unit of competency. |
Performance criteria describe the performance needed to demonstrate achievement of the element. Where bold italicised text is used, further information is detailed in the required skills and knowledge section and the range statement. Assessment of performance is to be consistent with the evidence guide. |
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 |
Required Skills and Knowledge
This section describes the skills and knowledge required for this unit.
Required skills
- analytical skills to:
- analyse and comprehend interdependencies between data fields
- examine and define system requirements for data
- review requirements and determine the availability of information
- communication skills to:
- interact with developer to determine data requirement
- interact with end user personnel to determine data requirement
- liaise with management on report and result matters
- literacy skills to:
- produce basic ad hoc report
- read and interpret specifications developed by business and technical experts
- numeracy skills to:
- make basic calculations involving basic arithmetic operations
- make estimates and comparisons involving date and time data
- problem-solving skills to:
- address common problems in operating a computer system
- perform basic debugging, such as defining simple problems, locating source of the problems, and providing solutions to problems
- technical skills to:
- perform basic data-management operations, such as insert, update and delete operations
- perform basic operations of a computer system.
Required knowledge
- broad knowledge of:
- information gathering methods
- data analysis
- data mining
- characteristics of data source
- features of information system
- typical systems and procedures.
Evidence Guide
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:
|
|
Context of and specific resources for assessment |
Assessment must ensure access to:
|
|
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:
|
|
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. |
Range Statement
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: |
|
|
Data source may include: |
|
|
Query language may include: |
|
|
Tools may include: |
|
|
Expression may include: |
|
|
Unit may include: |
|
Unit Sector(s)
Programming and software development
