Diploma of Information Technology (Database Design and Development) 
 

 
Traineeship
National Code
ICA50505 
CRICOS Code: 061415E 
Centre:
Information and Communications Technology
Location:
Nelson Campus
Study Area: Info Tech & Games Development; 
Study Area Sub Category:  
Career Card:
 

Duration

2 years which includes stage 1 Certificate IV in Information Technology (General)

Intake dates

January

What does this course involve?

As you read this information, please note the course is going to be re-accredited. There will be minor changes to the information provided here.

This course provides you with practical training in database administration, as well as database, software development and computer applications programming.

The course will develop your programming skills for Oracle databases, Microsoft Visual Studio and Sun Java.

You will also gain essential communication skills, learn about quality and project management, and translate business needs into technical requirements.

If you successfully complete the Diploma of Information Technology (Database Design and Development) you will have the opportunity to go on and complete the Diploma of Information Technology (Software Development) and Diploma of Information Technology (Website Development) within the same time frame.

Industry standard vendor qualifications in SUN and Oracle are also available as part of this course.

Entrance requirements

Australian Year 12 or equivalent with a pass, however relevant senior employment experience in industry will be considered.

English language proficiency

A minimum IELTS overall score of 5.5 (Academic).
A minimum TOEFL score of 530 for paper examination; 179 for computer based and 71 for Internet based.

Special admission requirements

None

Cost

Year 1: $AUD12,000
Year 2: $AUD11,300

Plus yearly amenities and materials fees.

What employment opportunities will I have?

This course may provide you with employment opportunities as a systems analyst, software developer, database programmer, database administrator, software project manager or software designer/analyst.

What further study options will I have?

Students who successfully complete a Diploma of Information Technology (Database Design and Development) who wish to progress into an Associate Degree in Computer Systems (Networking) or Bachelor of Computer Systems (Networking) will receive credit for five subjects or the equivalent of 1.25 semesters in duration.

Accreditation

This course is Government accredited and has National recognition.

Where will I study?

Nelson Campus

 
Units of Competency

Core
ICAA5046B
Model Preferred System Solutions
30.00 hr

This unit defines the competency required to fit a physical model into the design phase of the methodology. No licensing, legislative, regulatory or certification requirements apply to this unit at the time of publication.

ICAA5050B
Develop Detailed Component Specifications From Project Specifications
40.00 hr

This unit defines the competency required to analyse requirements of the project specifications in order to produce a set of high-level component specifications. No licensing, legislative, regulatory or certification requirements apply to this unit at the time of publication.

ICAA5054B
Validate Quality And Completeness Of System Design Specifications
20.00 hr

This unit defines the competency required to check the system specifications against outcomes and quality standards. System quality may refer to the network system, a program or a project. The following units are linked to form an appropriate cluster: ICAB5071B Review developed software ICAB5074B Monitor the system pilot.

ICAA5139B
Design a Database
50.00 hr

This unit defines the competency required to establish client needs and technical requirements and to design a database that meets those requirements. The following units are linked and form an appropriate cluster: ICAB4170B Build a database ICAA5153B Model data objects ICAA5154B Model data processes No licensing, legislative, regulatory or certification requirements apply to this unit at the time of publication.

ICAA5151B
Gather Data To Identify Business Requirements
30.00 hr

This unit defines the competency required to identify, analyse and document business requirements. The following units are linked and form an appropriate cluster: ICAA5050B Develop detailed component specifications from project specifications ICAA5139B Design a database ICAA5140C Design a server No licensing, legislative, regulatory or certification requirements apply to this unit at the time of publication.

ICAP5039B
Match It Needs With The Strategic Direction Of The Enterprise
20.00 hr

This unit defines the competency required to ensure IT services meet current and future internal operational enterprise requirements. The following units are linked and form an appropriate cluster: ICAP5036B Determine appropriate IT strategies and solutions ICAP6038B Develop strategic and action plans ICAA5151B Gather data to identify business requirements No licensing, legislative, regulatory or certification requirements apply to this unit at the time of publication.

BSBPM505A
Manage Project Quality
40.00 hr

This unit describes the performance outcomes, skills and knowledge required to manage quality within projects. It covers determining quality requirements, implementing quality assurance processes, and using review and evaluation to make quality improvements in current and future projects.

ICAA5153B
Model Data Objects
30.00 hr

This unit defines the competency required to understand business operations, identify entities and data, diagrammatically represent their relationships and prepare a data model. The following unit is linked and forms an appropriate cluster: ICAA5154B Model data processes No licensing, legislative, regulatory or certification requirements apply to this unit at the time of publication.

ICAA5158B
Translate Business Needs Into Technical Requirements
20.00 hr

This unit defines the competency required to identify the needs of a business or business process and quantify those needs into technical requirements that will enable the business or process to meet expectation. No licensing, legislative, regulatory or certification requirements apply to this unit at the time of publication.

ICAB5068B
Build Using Rapid Application Development
40.00 hr

This unit defines the competency required to build using rapid application development (RAD) tools. No licensing, legislative, regulatory or certification requirements apply to this unit at the time of publication.

ICAS5102B
Establish And Maintain Client User Liaison
20.00 hr

This unit defines the competency required to establish and maintain client user liaison in an IT environment, post implementation. This occurs after the business critical functions have been determined. No licensing, legislative, regulatory or certification requirements apply to this unit at the time of publication.

ICAS5202B
Ensure Privacy For Users
20.00 hr

This unit defines the competency required to ensure that personal information of users is handled in a confidential manner. No licensing, legislative, regulatory or certification requirements apply to this unit at the time of publication.

PSPPM502B
Manage Complex Projects
80.00 hr

This unit covers management of projects that may be reasonably complex in terms of scope, degree of risk, political, cultural and social factors that apply, consequences of failure and degree of control of the projects. It includes managing startup, project implementation, project integration and followup activities. Contract management requirements are not included as this aspect is addressed by units of competency within the Competency field of Procurement and Contract Management. In practice, managing complex projects overlaps with other generalist and specialist work activities such as acting ethically, coordinating resource allocation and usage, developing client services, undertaking research and analysis, etc.

Electives
ICAT5081B
Perform Systems Test
30.00 hr

This unit defines the competency required to ensure that the properties of the entire system are tested and proved adequate before handover to the client/user for final acceptance testing. These units are linked and form an appropriate cluster: ICAA5056B Prepare disaster recovery and contingency plans ICAT5084B Perform stress and load testing on integrated platform No licensing, legislative, regulatory or certification requirements apply to this unit at the time of publication.

ICAA5141B
Design Dynamic Websites To Meet Technical Requirements
40.00 hr

This unit defines the competency required to produce a plan that analyses specified technical requirements and then designs, builds and tests a dynamic website so that it meets those technical requirements.

ICAA5146B
Develop Website Information Architecture
30.00 hr

This unit defines the competency required to develop information architecture for a complex website that meets current and future business requirements. The following unit is linked and forms an appropriate cluster: ICAA5144B Determine best fit topology for a local network No licensing, legislative, regulatory or certification requirements apply to this unit at the time of publication.

ICAB5165B
Create Dynamic Web Pages
30.00 hr

This unit defines the competency required to build active or dynamic web pages. No licensing, legislative, regulatory or certification requirements apply to this unit at the time of publication.

ICAB5180B
Integrate Database With a Website
25.00 hr

This unit defines the competency required to ensure database connectivity with a website.

ICAB5223B
Apply Intermediate Object-Oriented Language Skills
50.00 hr

This unit defines the competency required to undertake intermediate level programming tasks using an object-oriented programming language. No licensing, legislative, regulatory or certification requirements apply to this unit at the time of publication.

ICAB5226B
Apply Advanced Object-Oriented Language Skills
80.00 hr

This unit defines the competency required to undertake advanced programming tasks using an object-oriented programming language. No licensing, legislative, regulatory or certification requirements apply to this unit at the time of publication.

ICAB5227B
Apply Advanced Programming Skills In Another Language
80.00 hr

This unit defines the competency required to undertake advanced programming tasks using a selected choice of another programming language. The second language may be an object-oriented language. No licensing, legislative, regulatory or certification requirements apply to this unit at the time of publication.

ICAT5079B
Perform Integration Test
30.00 hr

This unit defines the competency required to ensure that the components of the system operate together to the expected standard. These units are linked and form an appropriate cluster: ICAA5050B Develop detailed component specifications from project specifications No licensing, legislative, regulatory or certification requirements apply to this unit at the time of publication.

ICAT5083B
Develop And Conduct Client Acceptance Test
20.00 hr

This unit defines the competency required to plan and conduct acceptance testing as part of the process whereby clients will determine whether to accept the system. These units are linked and form an appropriate cluster: ICAA5048B Develop configuration management protocols ICAA5056B Prepare disaster recovery and contingency plans ICAT5077B Develop detailed test plan No licensing, legislative, regulatory or certification requirements apply to this unit at the time of publication.

ICAU5208B
Use Site Server Tools For Transaction Management
20.00 hr

This unit defines the competency required to use site server tools to build, host, track and monitor transactions on an e-business site. The following units are linked and form an appropriate cluster: ICAD4198B Develop guidelines for uploading information to a website ICAS5199B Manage business websites and servers ICAS4201B Transfer content to a website using commercial packages ICAS5203B Evaluate and select a web hosting service ICAD4209B Write content for web pages No licensing, legislative, regulatory or certification requirements apply to this unit at the time of publication.

All fees shown are in Australian dollars and do not include living or accommodation expenses. All fees quoted are indicative fees and are correct at the time of publishing. In subsequent calendar years, fees may be subject to a small increase in line with annual Institute fee pricing reviews. This qualification may have prerequisites, co-requisite or bridging units from lower or higher level qualifications. An offer of a place is always subject to places being available. The Institute reserves the right to close applications when the course is full. Where demand for a course is not met the course may be cancelled at short notice. For further clarification please seek advice from the Institute.

Course Enquiries

Local Students
1300 BOX HILL (1300 269 445)

International Students
+61 3 9286 9425