Assessment Requirements for ICTWEB451 Apply structured query language in relational databases

Release: 1

Assessment Requirements for ICTWEB451 Apply structured query language in relational databases

Modification History

Release	Comments
Release 1	This version first released with ICT Information and Communications Technology Training Package Version 6.0.

Performance Evidence

The candidate must demonstrate the ability to complete the tasks outlined in the elements, performance criteria and foundation skills of this unit, including evidence of the ability to:

apply structured query language (SQL) to a relational database and gather required information according to task requirements.

In the course of the above, the candidate must:

generate queries for one or more tables and provide required data

add, modify, retrieve and delete records from database tables as required test and verify SQL statements.

Knowledge Evidence

The candidate must be able to demonstrate knowledge to complete the tasks outlined in the elements, performance criteria and foundation skills of this unit, including knowledge of:

organisational policies and procedures relating to SQL application including:

identifying SQL requirements from job specifications

testing and verifying SQL results

features and application of primary and foreign keys in database tables, aggregate functions and clause functions required in SQL application

principles of “combining and/or condition” in SQL statements and Boolean operators

IN and BETWEEN conditional operators

mathematical operators

table joins (relationships)

documentation techniques relevant to applying structured query language in relational databases

SQL statement testing methodologies.

Assessment Conditions

Skills in this unit must be demonstrated in a workplace or simulated environment where the conditions are typical of those in a working environment in this industry.

This includes access to:

task specification documentation

structured query language (SQL)

industry standard software packages

an integrated development environment (IDE)

a database server

required hardware, software and its component.

Assessors of this unit must satisfy the requirements for assessors in applicable vocational education and training legislation, frameworks and/or standards.

Links

Companion Volume Implementation Guide is found on VETNet - https://vetnet.gov.au/Pages/TrainingDocs.aspx?q=a53af4e4-b400-484e-b778-71c9e9d6aff2