Unit of competency Outline

Date retreived
22/07/2026 2:59 PM 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.

Configure and maintain databases

Configure and maintain databases

Unit of competency
National Code
ICTPRG438
State Code
OBT18
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
020303 - Database Management
Original Release Date
15/01/2021
Nominal Hours
50
Description
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.
Notes
Elements and Performance Criteria
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
No information
No information
Replaces
State Code National Code Title Type
AUV87 ICTPRG412 Configure and maintain databases Unit of competency
State Code National Code Title Type
BFF9 ICT40120 Certificate IV in Information Technology Qualification