Diploma of Database Design and Development

This qualification provides skills and knowledge for an individual to be effective in the design and development of ICT database systems. The qualification builds on a base core of design and development competencies with elective choices covering business needs analysis, quality assurance and project management.

Job roles

Possible job titles relevant to this qualification include:

assistant database designer

assistant database developer

assistant database specialist.


Subjects

Total number of units = 20

9 core units plus

11 elective units

The elective units consist of:

up to 11 from the elective units listed below

up to 4 from elsewhere in ICA11 or any other Training Package or accredited course at Diploma or Advanced Diploma level.

The elective units chosen must be relevant to the work outcome and meet local industry needs.

Core units

add topic ICADBS502A Design a database

add topic ICAICT418A Contribute to copyright, ethics and privacy in an IT environment

add topic ICAICT502A Develop detailed component specifications from project specifications

add topic ICANWK514A Model preferred system solutions

add topic ICAPRG425A Use structured query language

add topic ICAPRG509A Build using rapid application development

add topic ICASAD501A Model data objects

add topic ICASAD502A Model data processes

add topic ICTSUS6233A Integrate sustainability in ICT planning and design projects

Elective units

add topic ICADBS504A Integrate database with a website

add topic ICAICT509A Gather data to identify business requirements

add topic ICAICT511A Match IT needs with the strategic direction of the enterprise

add topic ICAICT514A Identify and manage the implementation of current industry-specific technologies

add topic ICAPMG501A Manage IT projects

add topic ICAPMG606A Manage IT project quality

add topic ICAPRG501A Apply advanced object-oriented language skills

add topic ICAPRG503A Debug and monitor applications

add topic ICAPRG504A Deploy an application to a production environment

add topic ICAPRG505A Build advanced user interface

add topic ICAPRG507A Implement security for applications

add topic ICAPRG511A Monitor and support data conversion to new IT system

add topic ICAPRG514A Prepare for software development using rapid application development

add topic ICAPRG515A Review developed software

add topic ICAPRG523A Apply advanced programming skills in another language

add topic ICASAD506A Produce a feasibility report

add topic ICASAS502A Establish and maintain client user liaison

add topic ICASAS505A Review and update disaster recovery and contingency plans

add topic ICAWEB502A Create dynamic web pages

add topic ICTTEN5204A Produce technical solutions from business specifications


Pathways...

    Pathways into the qualification

    after achieving ICA40211 Certificate IV in Information Technology Support, or other relevant qualifications or units equivalent to the core of ICA40211.

    OR

    with demonstrated vocational experience in a range of database design and development areas.

    Pathways from the qualification

    ICA11 Advanced Diploma or Vocational Graduate Certificate qualifications or other higher education sector qualifications.


Entry Requirements

There are no entry requirements for this qualification.


Licensing Information

There is no link between this qualification and licensing, legislative or regulatory requirements. However users should confirm requirements with the relevant federal, state or territory authority. There may be some alignment with industry standard certification competencies.


Employability Skills

The following table contains a summary of the employability skills required by industry for this qualification. The employability skills facets described here are broad industry requirements that may vary depending on qualification packaging options.

Employability skill

Industry/enterprise requirements for this qualification

Communication

articulating complex scenarios in a clear and concise manner relevant to all levels of the organisation

documenting information related to database requirements and solutions

writing and presenting complex technical reports, with supporting documentation

Teamwork

coordinating group and presenting on key project activities

reviewing the database with team members and key stakeholders

Problem-solving

developing controls and contingencies to alleviate security threats

taking corrective action on system implementation breakdowns

Initiative and enterprise

anticipating potential problems and devising solutions

conducting research to determine client business requirements

integrating sustainability in ICT planning and design projects

matching client IT requirements with the strategic direction of the enterprise

Planning and organising

developing project plans

planning for quality controls and contingencies when designing database system

Self-management

managing own time and work priorities against project plan and schedule

taking accountability and responsibility for self and others in achieving work outcomes

Learning

keeping up-to-date with current industry-accepted database, web and programming products

participating in learning and development opportunities

Technology

coordinating implementation of technology needs

assessing the technological capability of various products against architecture requirements and making recommendations on the best IT solution

examining current and future ICT capability against a client’s future requirements and modelling preferred systems solutions