Unit of competency Outline

Date retreived
22/07/2026 6: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
ICTPRG403
State Code
AUV67
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 create data-driven applications that access data from a range of sources, such as databases, object data sources or eXtensible markup language (XML).It applies to individuals who may 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. Select data-access layer (DAL)
  • 1.1 Review function of DAL in multi-layer application model
  • 1.2 Determine data-access application programming interface (API) for connecting to various data sources
2. Establish connection with data source
  • 2.1 Create and manage connection strings
  • 2.2 Connect to data source by using different data providers
  • 2.3 Create code to handle connection exceptions
3. Execute commands and return results from data source
  • 3.1 Query data from data source
  • 3.2 Retrieve data from data source as result sets
  • 3.3 Manage result sets
  • 3.4 Manage exceptions when retrieving data
4. Modify data in data source
  • 4.1 Insert, update or delete data
  • 4.2 Manage data integrity
  • 4.3 Manage exceptions when modifying data
5. Manage disconnected data
  • 5.1 Research disconnected data management strategy
  • 5.2 Ensure that application can deal with disconnected data
6. Document data-access layer
  • 6.1 Document code
  • 6.2 Document database connectivity
No information
No information
Replaces
State Code National Code Title Type
D7997 ICAPRG403A Develop data-driven applications Unit of competency
Replaced By
State Code National Code Title Type
OBT24 ICTPRG432 Develop data-driven applications Unit of competency