Unit of competency Outline

Date retreived
23/07/2026 11:40 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.

Configure and maintain databases

Configure and maintain databases

Unit of competency
National Code
ICTPRG412
State Code
AUV87
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
020303 - Database Management
Original Release Date
16/09/2015
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 individuals 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 the requirements of database administration
  • 1.1 Identify the components of a database instance
  • 1.2 Define and use tools to administer the database
2. Install and configure the database system
  • 2.1 Verify the database software installation prerequisites
  • 2.2 Install the database software and related services
  • 2.3 Configure database instance, components and services
  • 2.4 Perform data management tasks
3. Manage database security and integrity
  • 3.1 Create and administer users
  • 3.2 Create and manage the permissions to perform database operations
  • 3.3 Create and manage roles
4. Optimise and back up database
  • 4.1 Configure the database for backup and recovery operations
  • 4.2 Create and manage database backups
  • 4.3 Restore and perform database recovery
  • 4.4 Tune and perform database optimisation
5. Document the database
  • 5.1 Document the maintenance and tuning work performed on the database
  • 5.2 Document the users added to system
No information
No information
Replaces
State Code National Code Title Type
D8004 ICAPRG412A Configure and maintain databases Unit of competency
Replaced By
State Code National Code Title Type
OBT18 ICTPRG438 Configure and maintain databases Unit of competency