Unit of competency Outline

Date retreived
24/07/2026 7:43 AM 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 to extract and manipulate data

Apply structured query language to extract and manipulate data

Unit of competency
National Code
ICTWEB425
State Code
AUP96
TGA Status
Replaced
DTWD Status
Replaced
Current Release Number
1.00
Current Release Date
25/03/2015
View on TGA
State Implementation and Classification
Approved Date
16/09/2015
Field of Education
020103 - Programming
Original Release Date
16/09/2015
Nominal Hours
60
Description
This unit describes the skills and knowledge required to produce structured query language (SQL) statements to work with server-side scripts, enabling web designers to interact with web server databases.It applies to individuals who are employed as web designers responsible for creating server-side interaction with dynamic web pages, using SQL as a means of communicating with the database.No licensing, legislative or certification requirements apply to this unit at the time of publication.
Notes
Elements and Performance Criteria
1. Identify SQL requirements from the specification documentation
  • 1.1 Determine the information to be used from the database
  • 1.2 Identify the tables that hold this information
  • 1.3 Identify the primary keys in these tables
  • 1.4 Identify the relationships between these tables, including foreign keys
2. Create a relational database
  • 2.1 Create tables in a database, using SQL statements
  • 2.2 Identify the primary and foreign keys for database table
  • 2.3 Manipulate the data in a database, using SQL statements
  • 2.4 Query the database, using SQL statements
  • 2.5 Write SQL statements to retrieve information from the database
3. Test SQL results
  • 3.1 Construct test data to test SQL statements
  • 3.2 Determine the expected results in order to verify SQL statements
  • 3.3 Verify the result of the constructed SQL statements, against the expected results
No information
No information
Replaces
State Code National Code Title Type
D8148 ICAWEB425A Apply structured query language to extract and manipulate data Unit of competency
Replaced By
State Code National Code Title Type
OBS17 ICTWEB451 Apply structured query language in relational databases Unit of competency