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 install a database, manage data, data access and data security and improve database performance.
It applies to those who are responsible for the maintenance and coordination of database operations. They usually work in an organisation providing daily services as database administrators, database developers, database coordinators, or application developers.
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. Determine requirements and install database system |
1.1 Identify required database and components and user needs 1.2 Define and use database administrative tools according to database requirements 1.3 Verify database software installation prerequisites 1.4 Install database software and related services according to organisational procedures 1.5 Configure database instance, components and services according to user needs |
2. Manage database security and integrity |
2.1 Create and administer users according to task requirements 2.2 Create and manage permissions and roles 2.3 Configure database including backup and recovery operations 2.4 Create and manage database backups 2.5 Restore and perform database recovery 2.6 Tune and perform database optimisation |
3. Document and review database |
3.1 Document maintenance and tuning work performed on database 3.2 Document users added to system 3.3 Review database and confirm required users have access |
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 |
|
Problem solving |
|
Self-management |
|
Technology |
|
Unit Mapping Information
Supersedes and is equivalent to ICTPRG412 Configure and maintain databases.
Links
Companion Volume Implementation Guide is found on VETNet - https://vetnet.gov.au/Pages/TrainingDocs.aspx?q=a53af4e4-b400-484e-b778-71c9e9d6aff2