Online training - access your course anytime, anywhere! Call us on 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
Work from home
Units
20 units

Summary

In collaboration with

Summary

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.
Download a free course pack
The best element of my job is the variety of industries that I get to work in. Every engagement brings new challenges.
Industry Q&A: Information Technology with John Havill
, Director
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 standard course is conducted over a 12 month period; within a self-paced online learning environment. 

Upskilled will gather information about your previous experience and skills, weekly study commitment and online learning experience to provide you with an projected duration for your course based on your individual circumstance. 

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 – Querying Microsoft SQL Server; and Administering Microsoft SQL Server Databases; and Implementing a Data Warehouse with Microsoft SQL Server
  • MCSE: Data Management and Analytics – MCSA: SQL Server; 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 specific entry requirements for this qualification.

Target audience for this program are individuals who express and interest in gaining higher knowledge in Database Design or existing ICT staff who wish to further develop, or formalise their skills by gaining a ICT50318 - Diploma of Database Design and Development.  

As a guide, entrants to this program may:

  • have 1-2 years of experience with ICT products
  • hold a certificate III or IV in a similar discipline
  • hold a premier vendor certification
  • ​complete an interview process with a designated Upskilled representative to ascertain suitability to the program and to review your current skills and experience, as this may allow you to move through the course more quickly
 

This program would also suit participants wishing to gain entry to higher level ICT discipline qualifications or employment at level 3 Support or Database Design.

To ensure participants are able to seamlessly access our online learning platform and video content, they will require access to a modern computer with high-speed internet. Participants will also need to possess basic computing skills, and may be required to complete a Language Literacy and Numeracy skills assessment before enrolment can be confirmed.

Inclusions
Upskilled courses include specialised learning materials, and access to:
  • Upskilled’s fully customised online learning platform, MyUpskilled
  • 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 / Credit Transfer
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

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.

Career outcomes
University pathways

This course might include a pathway to university, which are subject to change. Please speak to one of our Education Consultants for more information.

Vendor certification
This qualification covers the Microsoft learning content for the following Certifications:
  • MTA: Database Fundamentals
  • MCSA: SQL Server 
  • MCSE: Data Platform
  • ITIL Foundations

All recommended learning materials for these certifications are provided in this Upskilled Diploma, Microsoft Learning also recommends that you have hands-on experience with the product along with studying these materials.

* Vendor Certifications are current at the time of publishing but are subject to change as these are managed by external organisations to Upskilled.

Subjects

This qualification consists of the below units of competency. All competencies must be successfully completed to attain the qualification.
 
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

Enquire today

Sounds just like the course you're after? Speak with a career consultant to discover what it's like to study the ICT50515 - Diploma of Database Design and Development . 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 ICT50515 - Diploma of Database Design and Development . Submit your details and simply click 'Download'.

Enquire now

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

Processing