ICA40205 Certificate IV in Information Technology (Support) (Database Administration)
Qualification: Certificate IV (AQF)
Training Package: ICA05 Information and Communication Technology
TAFE Course No: 19006
Nominal Hours: 916
This course is for people who wish to pursue a career in private enterprise or government organisations as a database administrator or in a similar role. You will develop the required knowledge and skills to be able to provide database administration and support to an organisation.
You will learn how to identify physical database requirements, build, monitor and administer a database, use SQL to create database structures and manipulate data, manage resolution of system faults and complete database backup and recovery.
Career Opportunities: Data administrator, database administrator associate, database administrator, database sales and marketing specialist, database customer support professional, database customer liaison officer, database help desk specialist, information centre specialist, product support specialist, sales support specialist, sales and marketing specialist.
Articulation: When you finish this course you may be eligible for advanced standing in several other Information Technology courses, including ICA50505 Diploma in Database Design and Development.
Entry Requirements: NSW School Certificate (or equivalent).
| Modules/Units | |
| Core: | |
| BSBCMN106A | Follow workplace safety procedures |
| BSBCMN304A | Contribute to personal skill development and learning |
| ICAA4041A | Determine and confirm client business expectations and needs |
| ICAB4060A | Identify physical database requirements |
| ICAB4136A | Use SQL to create database structures and manipulate data |
| ICAB4170A | Build a database |
| ICAB4225A | Automate processes |
| ICAD2012A | Design organisational documents using computing packages |
| ICAD4043A | Develop and present a feasibility report |
| ICAD4217A | Create technical documentation |
| ICAS3024A | Provide basic system administration |
| ICAS4022A | Determine and action client computing problems |
| ICAS4106A | Action and complete change requests |
| ICAS4107A | Manage resolution of system faults on a live system |
| ICAS4108A | Complete database backup and recovery |
| ICAS4113A | Identify and resolve common database performance problems |
| ICAS4114A | Implement maintenance procedures |
| ICAS4125A | Monitor and administer a database |
| ICAT3025A | Run standard diagnostic tests |
| ICAT4221A | Locate equipment, system and software faults |
| ICAU1128A | Operate a personal computer |
| ICAU2005A | Operate computer hardware |
| ICAU2006A | Operate computing packages |
| ICAU2013A | Integrate commercial computing packages |
| ICAU2231A | Use computer operating system |
| ICAW2001A | Work effectively in an IT environment |
| ICAW2002A | Communicate in the workplace |
| ICAW4214A | Maintain ethical conduct |
| PSPPM402B | Manage simple projects |
| Elective: | |
| 19006A | Technical Tutorial Support |
| 8999A | Tutorial support |
| ICAA4233A | Determine and apply appropriate development methodologies |
| ICAB3018A | Develop macros and templates for clients using standard products |
| ICAB5068A | Build using rapid application development |
| ICAB5165A | Create dynamic pages |
| ICAB5180A | Integrate a database with a website |
| ICAI3020A | Install and optimise operating system software |
| ICAI3101A | Install and manage network protocols |
| ICAI4030A | Install software to networked computers |
| ICAI4097A | Install and configure a network |
| ICAS2014A | Connect hardware peripherals |
| ICAS3031A | Provide advice to clients |
| ICAS3032A | Provide network systems administration |
| ICAS3034A | Determine and action network problem |
| ICAS3120A | Configure and administer a network operating system |
| ICAS4023A | Provide one to one instruction |
| ICAS4033A | Assist with policy development for client support procedures |
| ICAS4109A | Evaluate system status |
| ICAS4124A | Monitor and administer network security |
| ICAS4127A | Support system software |
| ICAS4109A | Evaluate system status |
| ICAS4124A | Monitor and administer network security |
| ICAS4127A | Support system software |
| ICAS4134A | Provide first level remote helpdesk support |
| ICAU1129A | Operate a word processing application |
| ICAU1130A | Operate a spreadsheet application |
| ICAU1131A | Operate database application |
| ICAU1133A | Send & retrieve information using web browsers & email |
| ICAU3028A | Customise packaged software applications for clients |
| ICAU3126A | Use advanced features of computer applications |
| ICAW4026A | Coordinate and maintain work teams |
| ICAW4027A | Relate to clients on a business level |
| ICTCC121A | Use an enterprise information system |
| NSWTICA401A | IT work placement AQF 4 |
| NSWTICA402A | IT portfolio AQF4 |
 |
|
Applying and enrolling:
Semester 2 2008: Places may be available in some units. Contact the campus for details.
Campuses:
Coffs Harbour Education Campus - contact Julie Carr on (02) 6659 3600.
Semester 1 2009: North Coast Institute application form by 31 October 2008. Late applications may be accepted.
Campuses:
Coffs Harbour Education Campus - Distance/online study of 916 hours.
Also available to trainees.
For more information and an over-the-phone interview and assessment prior to enrolment call Linda Alfred on (02) 6659 3600 or email nci.courseinfo@tafensw.edu.au.
Information sheet - Online courses, Coffs Harbour Education Campus, Semester 1 2009 (PDF 101KB)
Great Lakes - Part-time day, 2 days per week flexible delivery with some online study for 36 weeks.
Contact Ken Morrison on (02) 6555 0600 for more information.
