Unit of Competency Mapping – Information for Teachers/Assessors – Information for Learners
ICTPRG425 Mapping and Delivery Guide
Use structured query language
Version 1.0
Issue Date: March 2024
Qualification | - |
Unit of Competency | ICTPRG425 - Use structured query language |
---|---|---|---|
Description | |||
Employability Skills | |||
Learning Outcomes and Application | This unit describes the skills and knowledge required to use a structured query language (SQL) to define, create, and manipulate database structures, and the associated data in a relational database.It applies to individuals in a wide variety of information and communications technology (ICT) roles, where relational databases and SQL are being used.No licensing, legislative or certification requirements apply to this unit at the time of publication. | ||
Duration and Setting | X weeks, nominally xx hours, delivered in a classroom/online/blended learning setting. Gather evidence to demonstrate consistent performance in conditions that are safe and replicate the workplace. Noise levels, production flow, interruptions and time variances must be typical of those experienced in the programming and software development, and include access to: special purpose tools, equipment and materials industry software packages. Assessors must satisfy NVR/AQTF assessor requirements. |
||
Prerequisites/co-requisites | |||
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: Write a simple SQL statement to retrieve and sort data |
| |||||||
Element: Write an SQL statement that selectively retrieves data |
| |||||||
Element: Write SQL statements that use functions |
| |||||||
Element: Write SQL statements that use aggregation and filtering |
| |||||||
Element: Write SQL statements that retrieve data from multiple tables |
| |||||||
Element: Write and execute SQL sub-queries |
| |||||||
Element: Create and manipulate tables |
| |||||||
Element: Create and use views |
| |||||||
Element: Create and use stored procedures |
|