Skip to main content
Skip navigation

Diploma of Database Design and Development

Diploma of Database Design and Development

Course Code: ICA50511
Download Brochure

The Diploma of Database Design and Development provides the skills and knowledge individuals require to be effective in the design and development of ICT database systems. The qualification builds on a base core of design and development competencies, and is customised for professional interests via electives covering business needs analysis, quality assurance, and project management.

Description

Course Structure

This program has been created with a blend of vendor specific, vendor neutral, and trainer developed materials. Vendor training is recognised internationally as an industry benchmark for product specific training. Upskilled uses an online Learning Management System to manage the delivery and assessment of learning resources. The program is conducted over a 12 month period through a blended learning approach of teacher-led workshops or webinars, distance education, and online materials.

Vendor Courses Vendor Neutral Courses Upskilled Courses/Workshops
  • Microsoft Academy Visual Studio
  • Microsoft Academy SQL Server
  • Project Management
  • Java
  • OH&S
  • Privacy Ethics and Copyright
  • Business Need
    Testing
  • Disaster Recovery
  • Technical Documentation
  • Sustainability
  • Service Desk Analyst 1 & 2

Pathways into the qualification

Preferred pathways for candidates considering this qualification may include:

  • Demonstrated vocational experience in a range of database design and development areas.

Recognition of Prior Learning (RPL)

Participants often come with experience in one or more ICT competencies, vocationally acquired from a range of sources (both formal and otherwise). Upskilled acknowledges the validity of such experience and encourages candidates to apply for Recognition of Prior Learning where applicable. Upskilled's RPL Calculator is a guide to initial RPL standing, although participants are sometimes entitled to further RPL as enrolment progresses.

 

Assessment

Assessment is summative and formative with set assignments, project work, and questionnaires.

 

Inclusions

Upskilled Information Technology courses include detailed learning materials, assessments, online trainer support, and certification upon successful completion.

 

Resources

This qualification utilises many and varied types of learning materials and assessments. These resources are managed and provided through Upskilled’s Learning Management System, MyUpskilled.  Access to a Microsoft based Personal Computer and an internet connection is required to complete any Upskilled IT qualification that utilises Microsoft Academy Courses (listed above).

Other courses you might interested in:

Unit Outline

Unit Outline

The online e-Learning course addresses the following units of competency from the National ICA11 Information and Communications Technology Training Package. All competencies must be successfully completed to attain the diploma. 

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.

 

Core Units

Unit Codes
Core Units
Cluster
ICAPRG425A Use structured query language Core Infrastructure
ICADBS502A Design a database Core Infrastructure
ICASAD501A Model data objects Continuity & Security
ICASAD502A Model data processes Continuity & Security
ICAPRG509A Build using rapid application development Continuity & Security
ICAICT502A Develop detailed component specifications from project specifications Continuous Improvement
ICANWK514A Model preferred system solutions Continuous Improvement
ICTSUS6233A Integrate sustainability in ICT planning and design projects Continuous Improvement
ICAICT418A Contribute to copyright, ethics and privacy in an IT environment Continuous Improvement

Elective Units

Unit Codes
Elective Units
Cluster
ICADBS603A Determine suitability of database functionality and scalability Core Infrastructure
ICASAS505A Review and update disaster recovery and contingency plans Continuity & Security
ICAPRG511A Monitor and support data conversion Continuity & Security
ICAPRG528A Perform IT data conversion  Continuity & Security
ICASAD505A Develop technical requirements for business solutions Continuous Improvement
ICAICT509A Gather data to identify business requirements Continuous Improvement
ICAICT511A Match IT needs with the strategic direction of the enterprise Continuous Improvement
ICASAD506A Produce a feasibility report Continuous Improvement
ICAPMG501A Manage IT projects Continuous Improvement
ICAPMG606A Manage IT project quality Continuous Improvement
ICASAS502A Establish and maintain client user liaison Service Delivery & Governance

 

Cluster 1 - Core Infrastructure
Infrastructure implementation is the starting point for business seeking to enable their business through utilising IT systems. The workplace skills provided in this cluster cover a broad range of key systems and services. The cluster has both server and workstation platforms at its heart to ensure a holistic knowledge base for Systems Administrators. The depth of knowledge transfer is based on Microsoft SQL Server 2008 and Windows. This cluster delivers outcomes that are broad in systems implementation and are relevant to many platforms like Microsoft, Oracle, Interbase, DB2 and MySQL.

Broad concepts covered

  • Scripting
  • Writing queries
  • Transaction logs
  • Join data from multiple tables
  • Install and configure server software
  • Basic backup and restore principles
  • Storage technologies
  • Import and export of data
  • Database replication
  • Create databases
  • Database integrity using constraints and triggers
  • Stored procedures
  • Transactions and locks
  • Functions
  • Views

Units of Competency for this qualification have a higher relevance in other clusters delivered. As such there are no Units of Competency for Core Infrastructure.

Cluster 2 - Continuity & Security
Systems Administrators must have the skills and knowledge to ensure that business systems are ready, available and capable for the purpose they were designed. The workplace skills provided in this cluster cover a broad range of concepts for business continuity. Identifying key systems and services is paramount to ensure that business can continue to function effectively. This cluster delivers outcomes that are broad and transferable across many different systems such as MS SQL, MySQL, Oracle, Gupta SQL, Interbase, Send Mail, Pegasus mail, Lotus Notes GroupWise and many more running on various platforms.

Broad concepts covered

  • Transaction log shipping
  • Database Mirroring
  • Database consistency checking
  • Defragmentation
  • Database mobility
  • Corporate virus management
  • Secure remote access
  • Monitor databases
  • Modify data in tables
  • Database security
  • Automation of admin tasks
  • Disaster recovery

Cluster 3 - Continuous Improvement
Systems Administrators play a key role in business improvement and must have the skills to offer solutions and alternatives to business managers to address problems and increase productivity and in turn, revenue. This cluster delivers outcomes that are broad in project methodology, systems design, and business needs analysis and are transferrable across multiple industries, systems and platforms.

Broad concepts covered

  • Project lifecycle
  • Identification and definition of Stakeholders
  • Feasibility analysis
  • Project Charters
  • Project team roles
  • Project Scope
  • Risk impact and mitigation
  • Cost and time estimate
  • Communications matrix
  • Quality management
  • Qualitative and quantitative analysis
  • Closeout process
  • Analysis of business need
  • Budget management - top-down - bottom-up
  • Relationship management
  • Project Implementation
  • Scope creep
  • Delivery and signoff
  • Project Debrief
  • Systems Design
  • Systems consolidation - Green IT concepts
  • Systems optimisation
  • Change management

Cluster 4 - Service Delivery & Governance
Being able to communicate with customers at all levels will ensure positive business support outcomes. The workplace skills provided in this cluster cover a broad range of concepts for systems support and maintenance. At the core of this cluster is ITIL, the "de facto standard", of service management. Included are soft skills units that prepare the student for client interaction that focus on communication skills through activities and simulations. Many of the skills learned are applicable across many job roles and industry sectors.

This cluster provides the framework and skills set that are platform and systems independent and vital to ensure that Support staff have the procedures, systems and policies in place to support correct, unbiased decision making in times of extreme stress. These will also extend to preventative maintenance and proactive problem management to reduce system incidents.

Broad concepts covered

  • Active Listening
  • Call handling
  • Service metrics
  • Change Management
  • Problem solving - deductive/inductive
  • Incident and problem management
  • Information gathering
  • Call ownership - perceived and real
  • Quality Assurance
  • Consistency of support
  • Maintenance
  • SLA/OLA/UC management
  • Service Strategy, Design, Transition, operation and continual improvement

Career Outcomes

Career Outcomes

Possible job titles relevant to this qualification include:

  • Assistant Database Designer
  • Assistant Database Developer
  • Assistant Database Specialist

Microsoft Certification Mapping

This qualification covers the Microsoft learning content for the following Certifications:
 
Microsoft Technology Specialist (MCTS)

  • Microsoft SQL Server 2008, Business Intelligence Development and Maintenance (exam 70-448)
  • Microsoft SQL Server 2008, Database Development (exam 70-433)
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.
 

Further Study

Pathways from the qualification:
ICA11 Advanced Diploma, Vocational Graduate Certificate qualifications, or other higher education sector qualifications.

For information about Pathways to University, click here.

Payment

Course Fees and Payment Options

Pay By Weekly Installment (Interest Free) Pay By Monthly Installment (Interest Free) Pay Upfront
$70 per week with a $250 enrolment fee¹ $485 per month with a $495 enrolment fee² Pay upfront $3,500, saving $390 (10% discount)

¹Payments made over a period of 52 consecutive weeks, totalling $3,890
²Payments made over a period of 7 consecutive months, totalling $3,890

 

Government Funding and Incentives

At both state and federal level, government commitment to upskilling the Australian workforce has resulted in a comprehensive framework of funding schemes and incentive opportunities. As a result, many Upskilled participants find that their courses are heavily subsidised*.

*Eligibility for traineeships & User Choice is determined by an Australian Apprenticeship Centre. Further information can be found at www.australianapprenticeships.gov.au



Skills for All Fees (South Australian Residents Only)

For those South Australian's eligible for Skills for All funding there is a subsidised course fee of $950, payable in one of two ways:

  1. A single upfront payment of the course fee attracts a 21% discount, making the cost $750
  2. An upfront fee of $495, and 2 x $227.50 paid per month for six consecutive months, making the total course fee $950

To find out if you're eligible click here

 

Centrelink Financial Support Services

This course is approved for Centrelink financial support services, including  Youth Allowance Austudy and  AbstudyClick here for more info.


Location & Date

Course Filter Whats this?
Filter by
Online
Person
Both Online and in Person
Date Location State Delivery Method  
03/02/2014 N/A N/A Enquire Now
03/02/2014 N/A N/A Enquire Now
03/03/2014 N/A N/A Enquire Now
03/03/2014 N/A N/A Enquire Now
01/04/2014 N/A N/A Enquire Now
01/04/2014 N/A N/A Enquire Now
01/05/2014 N/A N/A Enquire Now
01/05/2014 N/A N/A Enquire Now
02/06/2014 N/A N/A Enquire Now
02/06/2014 N/A N/A Enquire Now

Pagination

Follow us onFacebook Follow us onLinkedIn Follow us onTwitter Follow us onYoutube