ICTDBS503 - Create a data warehouse

Unit code: ICTDBS503 | Study level: TAFE
Nominal hours
60
Location
Footscray Nicholson
Prerequisites
(Or equivalent to be determined by unit coordinator)
Co-requisites
(Corequisite units must be studied concurrently with this unit)
Overview
Enquire

Overview

This unit describes the skills and knowledge required to design, develop and implement a data warehouse within an organisation.
It applies to individuals who are senior database staff required to provide data warehouse functionality for their organisation.No licensing, legislative or certification requirements apply to this unit at the time of publication.

Assessment

For Melbourne campuses

Assessment tasks will be designed to reinforce & extend knowledge and skill competence within set & controlled parameters in accordance with each unit’s learning outcomes & performance criteria requirements, including the setting of work based practical application tasks designed to provide evidence of competence outcomes, within periodic and scheduled timelines.

Students will be expected to demonstrate the following required skills:
• prepare the specifications for a data warehouse, from a range of organisational information
• design a data warehouse system that reflects the current, and future, business specifications, and also the business’s knowledge management strategy
• test the data warehouse system
• implement the data warehouse design.

Students will also be expected to demonstrate the following knowledge:
• explain the functions and features of:

  • data warehousing and data mining
  • dimension tables and fact tables
  • various steps and processes, including transformer steps, program steps, structured query language (SQL) steps, and user-defined program steps
  • subject areas, warehouse sources and warehouse targets
  • warehouse agents and agent sites
    • outline the business operating systems related to the data sources
    • describe the decision support systems related to the knowledge management strategies
    • define the parameters for a security plan
    • outline the system’s configuration parameters
    • describe the key features of "Big Data" including:
  • data access speeds and processing
  • the information handled by large corporations
  • distribution, via the cloud, across the database servers.

Required reading

The qualified trainer and assessor will provide teaching and learning materials as required in the form of workbooks produced by the Victoria University and/or via the Victoria University e-learning system.

As part of a course

This unit is studied as part of the following course(s):

Certificate IV in Information Technology
ICT40120 | Certificate iv | Duration:

Refer to the course page for information on how to apply for the course. VU takes care to ensure the accuracy of this unit information, but reserves the right to change or withdraw courses offered at any time. Please check that unit information is current with the Student Contact Centre.

Search for units, majors & minors