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.
Prerequisites
Not applicable.
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
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 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 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. |
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. |
Sectors
Programming and software development
Employability Skills
This unit contains employability skills.
Licensing 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.