Google Links

Follow the links below to find material targeted to the unit's elements, performance criteria, required skills and knowledge

Elements and Performance Criteria

1. Determine the requirements of developing queries
   • Recognise various query-related terminologies
   • Identify the type of data source for a chosen query language
   • Identify and use necessary tools and environment in building queries
2. Write queries to retrieve and sort values
   • Use an expression to retrieve values from a single unit
   • Use an expression to combine values from more than one unit
   • Use an expression to sort values into certain order
3. Write queries to selectively retrieve values
   • Use an expression to filter a sequence based on a predicate or condition
   • Use an expression to filter a subset of sequence based on a predicate or condition
   • Use an expression to extract a specific value by position
4. Perform calculation in queries
   • Use expression to perform calculation on numeric values
   • Use expression to perform operation on text values
   • Use expression to perform operation on date and time values

Required Skills

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

problemsolving 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 datamanagement 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 Required

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 candidates 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 candidates 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 nonEnglish 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:	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.

---