database_development_courses

Diploma of Database Design & Development/Diploma of Systems Analysis & Design

ICT50515/ICT50815

This double diploma made up of two nationally recognised courses will give you the skills to analyse business requirements, undertake modelling of solutions, create specifications and design and develop databases and IT systems.

Have a question about this course?

At a glance

Study mode

laptop
Online

Provider

OTEN – Open Training & Education Network (RTO 90004)
Career Opportunities
Recognition

Nationally recognised - meets Australian Qualifications Framework standards.
Meets membership requirements for Australian Computer Society as a Provisional Associate (AACS Prov).

Prerequisites

Certificate IV in relevant IT field OR 2 years in an IT role.

Location

Online

Course length
Self-paced (e.g. 17 hrs a week = finish in 1 year, 9 hrs a week = finish in 2 years). Complete within 2 years.
Study mode

Online


Online

Study from anywhere, when it suits you best and graduate with the identical qualification as an on-campus student.

Blended

Study part of the course online. Combine your online learning with classes or practical sessions on-campus at a college or university.

In-class

Attend classes on-campus at a university, TAFE or college and interact face-to-face with teachers and fellow students.

Assessment
Online quizzes, written assignments & practical assessments
Start date

Enrol anytime.

Provider
OTEN – Open Training & Education Network (RTO 90004)

TAFE NSW - OTEN - Open Training and Education Network (RTO 90004) is the largest online TAFE provider in Australia.

You can study OTEN’s accredited online TAFE courses at your own pace, and start anytime.

OTEN’s flexible courses are developed in consultation with relevant industry groups – to ensure you build the skills that are valued by employers.

TAFE NSW - Open Training & Education Network (RTO 90004) trading as Open Training & Education Network

Price

The course price can vary depending on a few factors, including whether you are an Australian resident or your chosen payment option. To find out more, contact the course provider.

Prerequisites

  • Certificate IV in Information Technology Support (specialising in Database Support) (preferred); OR
  • Certificate IV in Systems Analysis and Design; OR
  • 2 years full-time experience in an IT role, at the level of Certificate IV in Information Technology or above in the area of database administration; OR
  • Certificate IV in Information Technology in the areas of information systems development or systems support; OR
  • 2 years full-time experience in an IT role, at the level of Certificate IV in Information Technology or above in the areas of information systems development or systems support

If you pay for the course using a VET FEE-HELP government loan, you need to:

  • provide a Year 12 Senior Secondary Certificate of Education (from an Australian agency), OR
  • successfully complete a Language Literacy & Numeracy (LLN) test.

What you'll learn

You'll develop the knowledge and skills to:

  • Conduct systems analysis
  • Design and develop databases
  • Meet IT needs for businesses
  • Develop detailed test plans
  • Model data objects
  • Produce technical solutions
  • Use structured query language

Resources required

You will need reliable internet access with at least 2GB of data per month. An Apple computer is not suitable for this course.

Course structure

22 units

Core units

  1. ICTICT418 - Contribute to copyright, ethics & privacy in an IT environment


    This unit describes the performance outcomes, skills and knowledge required to maintain professional and ethical conduct as well as to ensure that personal information of stakeholders is handled in a confidential and professional manner when dealing with stakeholders in an information technology (IT) environment.

  2. ICTICT401 - Determine & confirm client business requirements


    This unit describes the performance outcomes, skills and knowledge required to determine client business requirements and verify the accuracy of the information gathered.

  3. ICTICT509 - Gather data to identify business requirements


    This unit describes the performance outcomes, skills and knowledge required to identify, analyse and document business requirements.

  4. ICTICT510 - Determine appropriate ICT strategies & solutions


    This unit describes the performance outcomes, skills and knowledge required to determine the best IT solution during the initial planning phase. It involves defining the basic goals of the solution and providing the basis for a high-level project work plan.

  5. ICTPRG425 - Use structured query language


    This unit describes the performance outcomes, skills and knowledge required to use a structured query language (SQL) to define, create and manipulate database structures and associated data in a relational database.

  6. ICTSAD506 - Produce a feasibility report


    This unit describes the performance outcomes, skills and knowledge required to recommend the preferred scenario from a range of feasible options offered to the client.

  7. ICTSUS6233A - Integrate sustainability in ICT planning & design projects


    This unit describes the performance outcomes, skills and knowledge required to integrate sustainability concepts and policies into ICT planning and design projects. It involves accessing industry information and applying legislative and occupational health and safety (OHS) guidelines.

  8. BSBADM502 - Manage meetings


    In this unit, you will develop the knowledge and skills required to manage a range of meetings including overseeing the meeting preparation processes, chairing meetings, organising the minutes and reporting meeting outcomes. Specifically you will:

    • prepare for meetings
    • conduct meetings
    • follow up meetings
  9. ICTICT511 - Match ICT needs with the strategic direction of the enterprise


    This unit describes the performance outcomes, skills and knowledge required to ensure information technology (IT) services meet current and future internal operational enterprise requirements.

  10. ICTNWK514 - Model preferred system solutions


    This unit describes the performance outcomes, skills and knowledge required to fit a physical model into the design phase of the methodology.

  11. ICTSAD501 - Model data objects


    This unit describes the performance outcomes, skills and knowledge required to understand business operations, identify entities and data, diagrammatically represent their relationships and prepare a data model.

  12. ICTSAD502 - Model data processes


    This unit describes the performance outcomes, skills and knowledge required to gather process data and business information in order to model data processes within an organisation.

  13. ICTDBS502 - Design a database


    This unit describes the performance outcomes, skills and knowledge required to establish client needs and technical requirements and to design a database that meets those requirements.

  14. ICTICT502 - Develop detailed component specifications from project specifications


    This unit describes the performance outcomes, skills and knowledge required to analyse requirements of the project specifications in order to produce a set of high-level component specifications.

  15. ICTPRG514 - Prepare for software development using rapid application development


    This unit describes the performance outcomes, skills and knowledge required to carry out rapid application development (RAD), in the context of preparing for software development.

  16. ICTTEN5204A - Produce technical solutions from business specifications


    This unit describes the performance outcomes, skills and knowledge required to compile and evaluate the business specifications from a client and to produce business solutions for consideration.

  17. ICTSAS513 - Develop detailed test plans


    This unit describes the performance outcomes, skills and knowledge required to plan for testing by collating documentation of conditions and expected results sufficient to allow for thorough system testing.

  18. ICTICT403 - Apply software development methodologies


    This unit describes the performance outcomes, skills and knowledge required to apply traditional and non-traditional systems development methodologies.

  19. ICTICT514 - Identify & manage the implementation of current industry-specific technologies


    This unit describes the performance outcomes, skills and knowledge required to identify and manage the implementation of specific industry technologies to meet identified industry standards. This unit covers the skills required to demonstrate and constantly review work processes that ensure that the quality of the business process is maintained at the highest level possible through the appropriate application of industry-specific technologies.

  20. ICTPRG509 - Build using rapid application development


    This unit describes the performance outcomes, skills and knowledge required to build using rapid application development (RAD) tools.

  21. ICTSAS502 - Establish & maintain client user liaison


    This unit describes the performance outcomes, skills and knowledge required to establish and maintain client user liaison in an information technology (IT) environment, post support implementation. This occurs after the business critical functions have been determined.

  22. ICTSAS505 - Review and update disaster recovery and contingency plans


    This unit describes the performance outcomes, skills and knowledge required to analyse the impact of the system on the organisation and carry out risk analysis, disaster recovery and contingency planning.

Support and delivery

Studying online explained

When you study online with OTEN, you can:

  • Study from anywhere, when it suits you best.
  • Graduate with the identical qualification as an on-campus student.
  • Get comprehensive support from teachers via phone and email.
  • Access course materials online.
  • Interact with teachers and fellow students via platforms like virtual classrooms, forums and video calls.

OTEN's online courses can also be referred to as distance education. Some hard-copy course materials and assessments may be accessed or submitted via post.

Recognition

After graduation, you'll be eligible for membership of the Australian Computer Society at the grade of Provisional Associate (AACS Prov). With an additional two years of experience in IT, you'll be eligible for upgrade to Associate (AACS). 

Have a question about this course?

Our Learning Consultants can:
  • icon enquiry 1Provide guidance on courses
  • icon enquiry 2Give advice on job outcomes
  • icon-enquiry-connectproviderConnect you with the relevant education provider

Free call 1800 675 282

9am - 5.30pm AEDT Monday - Friday