Release 

Comments 

Release 1

This version first released with ICT Information and Communications Technology Training Package Version 1.0.

ELEMENT 

PERFORMANCE CRITERIA 

Elements describe the essential outcomes.

Performance criteria describe the performance needed to demonstrate achievement of the element.

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

Skill 

Performance Criteria 

Description 

Reading

1.1-1.4, 2.3, 3.3

• Analyses and consolidates information and data from a range of sources, against the defined criteria and requirements, and checks for accuracy and completeness

Writing

2.1, 2.3-2.5, 3.1, 3.2

• Uses clear and specialised technical syntax when creating codes and interrogating databases
• Prepares and produces, diagrammatic models and associated documents, that that convey complex relationships between data

Get the work done

1.1, 1.4, 2.2-2.5, 3.2, 3.3

• Takes responsibility for planning, sequencing and prioritising tasks and own workload, for efficiency and effective outcomes
• Makes routine decisions and implements standard procedures for routine tasks, using formal decision-making processes for more complex and non-routine situations
• Addresses less predictable problems and initiates standard procedures in response to these problems, applying problem-solving processes in determining a solution
• Uses familiar digital technologies and systems to access information, search and enter, data and code, present information, and communicate with others, cognisant of data security and safety

Code and title 

current version 

Code and title 

previous version 

Comments 

Equivalence status 

ICTWEB425 Apply structured query language to extract and manipulate data

ICAWEB425A Apply structured query language to extract and manipulate data

Updated to meet Standards for Training Packages

Equivalent unit

Release 

Comments 

Release 1

This version first released with ICT Information and Communications Technology Training Package Version 1.0.