Unit of competency Outline

Date retreived
24/07/2026 1:58 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.

Develop data-driven applications

Develop data-driven applications

Unit of competency
National Code
ICTPRG432
State Code
OBT24
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
60
Description
This unit describes the skills and knowledge required to create data-driven applications that access data from a range of sources, including databases, object data sources and extensible mark-up language (XML).It applies to those who work as programmers or database application developers and who are responsible for data-access coding.No licensing, legislative or certification requirements apply to this unit at the time of publication.
Notes
Elements and Performance Criteria
1. Establish task requirements and select data-access layer (DAL)
  • 1.1 Identify data and application requirements according to organisational procedures
  • 1.2 Review function of required DAL in multi-layer application model
  • 1.3 Determine data-access application programming interface (API) according to task requirements
2. Establish connection with data source
  • 2.1 Create and manage connection strings according to task requirements
  • 2.2 Connect data source using different data providers according to organisational procedures
  • 2.3 Handle connection exceptions using code
3. Execute commands and return results from data source
  • 3.1 Query data from data source according to task requirements
  • 3.2 Retrieve and manage results sets from data source
  • 3.3 Manage exceptions when retrieving data
4. Modify and manage data in data source
  • 4.1 Insert, update and delete data according to task requirements
  • 4.2 Confirm data integrity
  • 4.3 Manage exceptions when modifying data
  • 4.4 Research disconnected data management strategy
  • 4.5 Confirm application can manage disconnected data according to organisational procedures
  • 4.6 Document code and database connectivity according to organisational procedures
No information
No information
Replaces
State Code National Code Title Type
AUV67 ICTPRG403 Develop data-driven applications Unit of competency
State Code National Code Title Type
BFF9 ICT40120 Certificate IV in Information Technology Qualification