Google Links
Follow the links below to find material targeted to the unit's elements, performance criteria, required skills and knowledge
Required Skills
evaluate interdependencies between data fields
examine and define system requirements for data
review requirements and determine the availability of information
interact with developer to determine data requirement
interact with end user personnel to determine data requirement
liaise with management on report and result matters
read and interpret specifications developed by business and technical experts
address common issues relating to the operation of a computer system
perform basic troubleshooting to diagnose system problems
perform basic datamanagement operations such as insert update and delete operations
perform basic operations of a computer system
computer hardware and components
Evidence Required
Range Statement
Components may include: | memory structurerelational database management system (RDBMS) softwarestored procedurestable structure. |
Database may include: | MS AccessMySQLOraclestructured query language (SQL) server. |
Tools may include: | MySQL WorkbenchOracle Enterprise Manager Database ControlphpMyAdminSQL Server Management Studio. |
Data-management tasks may include: | implement data compressionsimport and export datamaintain indexesmanage collationsmanage data partitions. |
Permissions may include: | impliedobject statement. |
Roles may include: | application database:fixedpublic defined server, such as fixed-server roles. |
Backups may include: | compressed differential file full database online and offline database transaction log. |
Recovery may include: | bulk-logged full simple. |
Optimisation may include: | cache mechanismdata compressionindexing. |