Unit of competency Outline

Date retreived
22/07/2026 9:46 PM AWST

Whilst all efforts are made to provide accurate and timely information from the relevant source/documentation, please be aware that the information supplied may not be the most current version. The accuracy of the detail has not been confirmed by the Department and therefore should not be relied upon without first confirming the contents.

Apply structured query language in relational databases

Apply structured query language in relational databases

Unit of competency
National Code
ICTWEB451
State Code
OBS17
TGA Status
Current
DTWD Status
Approved
Current Release Number
1.00
Current Release Date
21/07/2020
View on TGA
State Implementation and Classification
Approved Date
15/01/2021
Field of Education
020103 - Programming
Original Release Date
15/01/2021
Nominal Hours
55
Description
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.
Notes
Elements and Performance Criteria
1. Identify database requirements
  • 1.1 Determine information required from database
  • 1.2 Identify tables holding this information
  • 1.3 Identify primary keys in these tables
  • 1.4 Identify relationships between these tables including foreign keys
2. Build and implement SQL in relational databases
  • 2.1 Identify and build SQL statements according to task requirements
  • 2.2 Create tables in a database using SQL statements
  • 2.3 Create primary and foreign keys required in database table
  • 2.4 Manipulate data in a database using SQL statements
  • 2.5 Query database using SQL statements
  • 2.6 Retrieve information from database using written SQL statements
3. Test and verify SQL results
  • 3.1 Construct test data and test SQL statements according to organisational procedures
  • 3.2 Determine expected results of SQL statements
  • 3.3 Verify result of constructed SQL statements against expected results and document findings
  • 3.4 Confirm task requirements are met and obtain sign-off from required personnel
No information
No information
Replaces
State Code National Code Title Type
AUP96 ICTWEB425 Apply structured query language to extract and manipulate data Unit of competency
AUV63 ICTPRG425 Use structured query language Unit of competency
State Code National Code Title Type
BFF9 ICT40120 Certificate IV in Information Technology Qualification