Unit of competency
Modification History
Release |
Comments |
Release 1 |
This version first released with ICT Information and Communications Technology Training Package Version 6.0. |
Application
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.
Unit Sector
Programming and software development
Elements and Performance Criteria
ELEMENT |
PERFORMANCE CRITERIA |
Elements describe the essential outcomes. |
Performance criteria describe the performance needed to demonstrate achievement of the element. |
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 |
Foundation Skills
This section describes those language, literacy, numeracy and employment skills that are essential to performance but not explicit in the performance criteria.
S KILL |
DESCRIPTION |
Reading |
|
Writing |
|
Initiative and enterprise |
|
Problem solving |
|
Technology |
|
Unit Mapping Information
Supersedes and is equivalent to ICTPRG403 Develop data-driven applications.
Links
Companion Volume Implementation Guide is found on VETNet - https://vetnet.gov.au/Pages/TrainingDocs.aspx?q=a53af4e4-b400-484e-b778-71c9e9d6aff2