Unit of Competency Mapping – Information for Teachers/Assessors – Information for Learners
ICAPRG425A Mapping and Delivery Guide
Use structured query language
Version 1.0
Issue Date: April 2024
Qualification | - |
Unit of Competency | ICAPRG425A - Use structured query language |
---|---|---|---|
Description | This unit describes the performance outcomes, skills and knowledge required to use a structured query language (SQL) to define, create and manipulate database structures and associated data in a relational database. | ||
Employability Skills | This unit contains employability skills. | ||
Learning Outcomes and Application | This unit applies to a wide variety of information technology (IT) roles where relational databases and SQL are being used. SQL database functions are in place for most organisations and have become integral to internet-based data provision and data retrieval.Examples of job roles where this unit applies would be:IT generalists who work in environments in which relational databases and SQL are part of an overall solutionsystems administrators or network engineers who install and manage systems that run on an SQL serverdevelopers who build applications that use SQLIT professionals who work with third-party applications that are built using SQL databasesdatabase administrators who manage the relational database environmentadvanced users who write queries to extract data from a relational database. | ||
Duration and Setting | X weeks, nominally xx hours, delivered in a classroom/online/blended learning setting. |
||
Prerequisites/co-requisites | Not applicable. | ||
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 |
|