Certificate IV in Information Technology (Support Database Administration)

Course Overview

This qualification provides the skills and knowledge for an individual to be competent in a variety of information technology support roles including database administration. The qualification has a strong Information Communication Technology (ICT) base of 12 common core units, with the potential for inclusion of a range of broader support, help desk and database units to suit particular needs.

Database Administration Stream

This stream develops skills in the administration of commercial database systems and could provide database support to an organisation. Database
administration employees make sure that the underlying technologies provide users with flexibility in the management, access, retrieval, sharing and
configuration of the large amounts of data held by many ICT systems. There are several vendor courses that could potentially relate to this
qualification.

Location

Brisbane, Gold Coast, Cairns or Townsville and other regional areas throughout Queensland.

Course Duration

This course is structured through competency based training and assessment. Course duration is based on individual training requirements. 24 months for a full-time traineeship is an indication.

Entry Requirements

A range of pre-requisite units that contain the basic fundamentals of ICT knowledge and skills are required for entry into this course.

Career Opportunities

Small to medium enterprises will find the outcomes of this qualification useful at a technical specialist support level. ICT support job roles apply across all industries.

• Computer Technician
• Help Desk
• Information Systems Operator
• Product Support Engineer
• Technical Support Representative
• Customer Support
• Help Desk Analyst
• Network Support Technician
• System Administrator

Certificate Requirements

The award of Certificate IV in Information Technology (Support) Database Administration will be given to students who successfully complete the prescribed units.

Additional Courses

Further training may be sought in units listed in the Information Communications Technology Training Package. Please contact your Courses Now Training Solutions Advisor for additional information.

Articulation

Units of competency from Certificate level IV provide articulation into higher level qualifications. Such articulation is subject to individual evaluation. The Certificate IV in Information Technology (Support) Database Administration stream provides logical entry into higher level qualifications
such as the Diploma of Information Technology (Database Design and Development); or a pathway into Systems Administration, or Project Management.

Enrolments

This course has a rolling intake. Continuous enrolments allow students to commence training at any time.

Delivery Method

This course may be delivered through a combination of online, class, workplace, self-paced and distance learning.
 

Competency Code Title Competency Code Title BSBCMN106A Follow workplace safety procedures  ICAU2013A  Intergrate commercial computing packages  ICAD2012A  Design organisational documents using computing packages 
ICAU2231A  Use computer operating system  ICAU1128A Operate a personal computer  ICAW2001A Work effectively in an IT environment   ICAU2005A Operate computer hardware
ICAW2002A  Communicate in the workplace  ICAU2006A Operate computing packages     

Student must complete all core units (C) and a minimum of 4 elective units (E) 

Course Name Duration Days Competency Code

Content

*Indicates Prerequisite Units

C/E AQF Exp Hrs Create Technical Documentation 1  ICAD4217A Create technical documentation   C IV 20  Automate Processes  1  ICAB4225A  Automate processes  C  IV  40  Professional Development 1  BSBCMN304A Contribute to personal skill development and learning  C  III  30  Establish Client Business Needs  1  ICAA4041A  Determine and confirm client business expectaions and needs  C  IV  40  Develop a Feasibility Report 1  ICAD4043A Develop and present a feasibility report C  IV  30  System & Software Trouble Shooting   1  ICAS4022A Determine and action client computing problems  C  IV  40      ICAT4221A  Locate equipment systems and software faults C  IV  20  System Administration   1  ICAS4127A

Support system software 

(*prerequisite unit: ICAI3020A)

C  IV  20      ICAS3024A  Provide basic system administration  C  IV  20  Manage simple projects  1  PSPPM402B  Manage Simple Projects   C  IV  50  Customer Service   1  ICAW4027A Relate to clients on a business level E  IV  40  Manage System Faults   2 ICAS4107A  

Manage resolution of system faults on a live system  

(*prerequisite units: ICAS3024A, ICAT3025A, ICAT4221A)

C  IV 40     ICAS4109A  

Evaluate system status  

(*prerequisite unit: ICAT3025A)

E  IV  20  Install System Software
  1  ICAI3020A   Install and optimise operating system software   C  IV  20      ICAT3025A   Run standard diagnostic tests  E III 20 Develop Database System Project 2  ICAB4060A 

Identify Physical database requirements 

(*prerequisite unit: ICAA4041A)

C  IV  40      ICAB4170A  Build a database  C  IV  30  Maintain Ethical conduct  1 ICAW4214A Maintain Ethical Conduct  C  IV  20  Database Administration 1  1  ICAS4125A  Monitor and administer a database

(*prerequisite unit: ICAS3024A)  

C  IV  30    1  ICAS4106A  Action and complete change requests  C  IV  40  Database Administration 2  1  ICAS4108A  Complete database backup and recovery  C  IV  30      ICAS4113A  Identify and resolve common database performance problems  C  IV  30      ICAS4114A 

Implement maintenance procedures 

(*prerequisite unit: ICAT3025A)  

C  IV  10  SQL 2  ICAB4136A 

Use structured query language to create database structures and manipulate data.

(*prerequisite unit: ICAB4225A)  

C  IV  60  Client Support Procedure  1  ICAS4033A  Assist with policy development for client support procedures  E  IV  20  Remote Help Desk Support  1  ICAS4134A  Provide first level remote help desk support  E  IV  30  Train Small Groups  1  ICAS4023A  Provide one-to-one instruction  E  IV  20  Use and Enterprise Information System 1  ICTCC121A  Use and enterprise operating system software  E  II  25