up to 20% off in December - merry xmas! Contact us today 1300 009 924
ICT50515
Diploma of

Database Design and Development

Download cCourse pack Enquire now
Start date
Enrol Anytime
Duration
12 months
Mode
100% online
Units
20 units

Summary

In partnership with
Learn the skills required to be effective in the design and development of ICT database systems. Through a 12-month course of vendor specific, vendor neutral, and trainer-developed materials, students will be taught the fundamentals of business needs analysis, quality assurance, and project management in the field of database design and development.
In partnership with
Nationally recognised
The course materials helped to reinforce and improve my skills on how to better design a database system and develop a better scope document; deliverable, project sign-off, project estimation, and completion.
Ivan Chu
, Business Consultant (Data Analyst)
Read the full testimonial

Detail

Individuals will undertake units in database design, structuring, and maintenance; and will be trained to manage ICT projects, ensuring they meet business requirements and are held to a high standard of quality. The basics of privacy ethics and copyright, along with disaster recovery, technical documentation, and sustainability will also be covered.
  • Course structure

    This course uses a blend of vendor specific, vendor neutral, and trainer-developed materials.

    The course is conducted over a 12 month period; within a self-paced online learning environment. Upskilled uses MyUpskilled to manage the delivery and assessment of your course. This means you can learn at your own pace.
     

    Vendor Courses* Vendor Neutral Courses Upskilled Courses/Workshops
    • MTA: Database – Database Fundamentals 
    • MCSA: SQL Server 2012/2014 – Querying Microsoft SQL Server 2012/2014; and Administering Microsoft SQL Server 2012/2014 Databases; and Implementing a Data Warehouse with Microsoft SQL Server 2012/2014
    • MCSE: Data Management and Analytics – MCSA: SQL Server 2012/2014; and Designing Database Solutions for Microsoft SQL Server
    • ITIL Foundations
    • Project Management
    • Java
    • WHS
    • Privacy Ethics and Copyright
    • Business Needs
    • Testing
    • Disaster Recovery
    • Technical Documentation
    • Sustainability
    • Service Desk Analyst 1 & 2
  • Entry requirements

    There are no formal entry requirements for this qualification. 

    Students will need access to a computer, and the internet, and have basic computing skills. A Language Literacy and Numeracy skills assessment may be required before enrolment can be confirmed.

    Preferred pathways for candidates considering this qualification may include:

    • Demonstrated vocational experience in a range of work environments in database design and development
    • Successful completion of Certificate IV in Information Technology Support, or a qualification equivalent
  • Inclusions
    Upskilled courses include specialised learning materials, and access to:
    • Upskilled’s fully customised online learning platform, MyUpskilled
    • Student Rewards Program
    • Student Support services
    • your trainer via the trainer/student messaging system
    • webinars; both live and recorded sessions
    • video content access via:
  • Recognition of Prior Learning (RPL)
    Work experience or formal qualifications you have may count towards your course. If you have previously undertaken study at a recognised institution or have some relevant work experience, you might gain credit towards specific units in a course; shortening the time you have to study. You can send your application for Credit Transfer or RPL during the enrolment process.
  • Assessment
    Upskilled takes evidence gathered from a variety of sources to deem a student as competent. Assessment processes might include some or all of the following:
    • Recognition of Prior Learning and/or credit transfer
    • summative and formative assignments
    • written reports and/or portfolio assessments
    • scenarios and/or case studies
    • projects
    • written/oral questions
    • regular training and assessment contact will be maintained by Upskilled in conjunction with the participant and their employer (where applicable). Critical dates during the program will be identified for participants to ensure compliance to assessment due dates, and attendance at monthly webinars as required.

Outcomes

Possible job titles relevant to this qualification include:

  • Assistant Database Designer
  • Assistant Database Developer
  • Assistant Database Specialist
Additionally, this qualification could give you several career, vendor and/or further study outcomes. After completing this course, you could explore some of the following outcomes.

Subjects

This qualification consists of the below units of competency. All competencies must be successfully completed to attain the qualification.

The program is broken into 4 logical clusters of training within the broad category of ICT systems: 1/ Core Infrastructure; 2/ Continuity & Security; 3/ Continuous Improvement; and 4/ Service Delivery & Governance.
 
  • ICTDBS502
    Design a database

    This unit describes the skills and knowledge required to establish client needs and technical requirements and to design a database that meets those requirements. It applies to individuals employed as database administrators and designers who are required to design databases.

  • ICTICT418
    Contribute to copyright, ethics and privacy in an ICT environment

    This unit describes the 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 and communications technology (ICT) environment. It applies to ICT personnel who are required to gather information to determine the organisation’s code of ethics, and protect and maintain privacy policies and system security.

  • ICTICT502
    Develop detailed component specifications from project specifications

    This unit describes the skills and knowledge required to analyse requirements of the project specifications in order to produce a set of high-level component specifications. It applies to systems designers who are required to produce component specifications for programmers.

  • ICTPRG425
    Use structured query language

    This unit describes the skills and knowledge required to use a structured query language (SQL) to define, create, and manipulate database structures, and the associated data in a relational database. It applies to individuals in a wide variety of information and communications technology (ICT) roles, where relational databases and SQL are being used.

  • ICTPRG509
    Build using rapid application development

    This unit describes the skills and knowledge required to build using rapid application development (RAD) tools. It applies to individuals who may work as programmers and who are required to develop new systems.

  • ICTSAD501
    Model data objects

    This unit describes the skills and knowledge required to understand business operations, identify entities and data, diagrammatically represent their relationships, and prepare a data model. It applies individuals who have a broad range of analytical, technical and communication skills and who work within broad but established parameters.

  • ICTNWK514
    Model preferred system solutions

    This unit describes the skills and knowledge required to fit a physical model into the design phase of the methodology. It applies to individuals working as system designers who are required to model proposed solutions.

  • ICTSAD502
    Model data processes

    This unit describes the skills and knowledge required to gather process data and business information in order to model data processes within an organisation. It applies to individuals who can apply a broad range of technical knowledge and skills within the context of a complex project.

  • ICTSUS601
    Integrate sustainability in ICT planning and design projects

    This unit describes the skills and knowledge required to integrate sustainability concepts and policies into information and communications technology (ICT) planning and design projects. These projects typically involve upgrades of equipment hardware and software or new installations of next generation networks (NGN) using emerging technologies. It applies to individuals who have high level specialist technical skills and knowledge in optical communications and IT networks using internet protocol (IP) systems.

  • ICTSAS502
    Establish and maintain client user liaison

    This unit describes the skills and knowledge required to establish and maintain client user liaison in an information and communications technology (ICT) environment, post support implementation. This occurs after the business critical functions have been determined. It applies to individuals who are responsible for system and business analysis and administration, and liaising with clients to ensure that their requirements are fully met.

  • ICTSAS505
    Review and update disaster recovery and contingency plans

    This unit describes the skills and knowledge required to analyse the impact of the system on the organisation and carry out risk analysis, disaster recovery and contingency planning. It applies to individuals who apply a wide range of higher level technical skills and systematic problem solving approaches in information and communications technology (ICT) related areas.

  • ICTPRG511
    Monitor and support data conversion to new ICT system

    This unit describes the skills and knowledge required to monitor and support data conversion to a new information and communications technology (ICT) system. It applies to individuals involved in the development process, who are required to convert data to work on new systems.

  • ICTPRG528
    Perform ICT data conversion

    This unit describes the skills and knowledge required to translate information and communications technology (ICT) data from one format to another, by means of a data conversion process. It applies to individuals in support and implementation roles who are required to convert data from one system to another.

  • ICTSAD506
    Produce a feasibility report

    This unit describes the skills and knowledge required to recommend the preferred scenario from a range of feasible options offered to the client. It applies to individuals who are responsible for researching, planning and designing solutions for complex information and communications technology (ICT) projects.

  • ICTICT509
    Gather data to identify business requirements

    This unit describes the skills and knowledge required to identify, analyse and document business requirements. It applies to individuals working as systems analyst developers and project team leaders, and managers responsible for gathering data to identify business requirements.

  • ICTICT511
    Match ICT needs with the strategic direction of the enterprise

    This unit describes the skills and knowledge required to ensure information and communications technology (ICT) services meet current and future internal operational enterprise requirements. It applies to individuals whose responsibilities may include maintaining and supporting critical infrastructure for objectives in small-to-medium sized organisations.

  • ICTPMG501
    Manage ICT projects

    This unit describes the skills and knowledge required to manage the initiation, implementation and completion of reasonably complex information and communications technology (ICT) projects incorporating scope, risk control and financial factors. It applies to individuals who utilise a range of specialised technical and managerial techniques to plan, carry out and evaluate their own work and/or the work of a team.

  • ICTPMG606
    Manage ICT project quality

    This unit describes the skills and knowledge required to implement quality assurance processes using quality control data to ensure continuous improvement for the benefit of current and future information and communications technology (ICT) projects. It applies to individuals who may be required to apply high level business management, quality and technical knowledge and skills to ensure that projects are delivered, evaluated and monitored in accordance with organisational quality management systems and processes.

  • ICTSAD505
    Develop technical requirements for business solutions

    This unit describes the outcomes, skills and knowledge required to develop technical and related requirements that will enable business solutions to be implemented in an organisation. It applies to individuals who are responsible for performing complex technical analysis to complete a range of tasks and provide solutions to complex problems.

  • ICTDBS603
    Determine suitability of database functionality and scalability

    This unit describes the skills and knowledge required to identify the current and future business requirements for a database. It applies to individuals with senior system-operations or line management responsibility.

Show all subjects

Educators

Enquire today

Sounds just like the course you're after? Speak with a career consultant to discover what it's like to study the Diploma of Database Design and Development (ICT50515). Send us an enquiry and we'll get in touch.

Download course pack

Want to know all about this course? Get our course brochure to discover what it's like to study Diploma of Database Design and Development (ICT50515). Submit your details and simply click 'Download'.

Enquire now

Start your next course with Upskilled. Enter your details in the form below.