Application
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.
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. 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 |
Evidence of Performance
Evidence of the ability to:
select and code the data-access layer of multi-layer applications
retrieve and update data from various data sources.
Note: If a specific volume or frequency is not stated, then evidence must be provided at least once.
Evidence of Knowledge
To complete the unit requirements safely and effectively, the individual must:
describe the features of object-oriented design and multi-layer applications
outline relational database management systems
describe object-oriented programming at an intermediate level
outline the principles of a Structured Query Language (SQL).
Assessment Conditions
Gather evidence to demonstrate consistent performance in conditions that are safe and replicate the workplace. Noise levels, production flow, interruptions and time variances must be typical of those experienced in the programming and software development field of work and include access to:
integrated development environment (IDE)
data access application program interfaces (APIs)
database management system software and files
coding standard
specific tools and licences, depending on particular data-access API
different types of data-access methods including data retrieval and storage, back-end coding and disconnect data management
eXtensible markup language (XML) documents.
Assessors must satisfy NVR/AQTF assessor requirements.
Foundation Skills
This section describes language, literacy, numeracy and employment skills incorporated in the performance criteria that are required for competent performance.
Skill | Performance Criteria | Description |
Reading | 1.2, 3.1, 5.1 | Interprets complex technical documents to ensure outcomes are met |
Writing | 2.3, 3.1, 4.1, 4.3, 6.1, 6.2 | Completes workplace documentation accurately and in an appropriate format |
Get the work done | 1.1, 1.2, 2.1, 2.2, 2.3, 3.1, 3.3, 3.4, 4.1, 4.2, 4.3, 5.1, 5.2 | Uses digitally based technologies and systems to design and create complex models and codes Identifies technical or conceptual issues and applies analytical processes to resolve these issues Recognises opportunities to investigate potential new techniques to access data from various resources |
Sectors
Programming and software development