Unit of Competency Mapping – Information for Teachers/Assessors – Information for Learners
ICTWEB451 Mapping and Delivery Guide
Apply structured query language in relational databases
Version 1.0
Issue Date: June 2024
Qualification | - |
Unit of Competency | ICTWEB451 - Apply structured query language in relational databases |
---|---|---|---|
Description | |||
Employability Skills | |||
Learning Outcomes and Application | This unit describes the skills and knowledge required to produce structured query language (SQL) statements to work with server-side scripts, enabling web developers to interact with web server databases.The unit applies to individuals in a range of roles who are responsible for creating server-side interaction with dynamic web pages, using SQL as a means of communicating with databases.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. 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. |
||
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: Identify database requirements |
| |||||||
Element: Build and implement SQL in relational databases |
| |||||||
Element: Test and verify SQL results |
|