Program Objective

This Diploma in Data Warehousing is "Approved as a vocational program under the Ontario Career Colleges Act, 2005"

The aim of this program is to provide students with a combination of computer and office administration skills and a practical foundation in communications marketing and e-commerce. The program would also provide in-depth knowledge in business analysis and documentation processes. This course will focus on job-oriented technical skills. Learning modelling techniques and how to populate these data models, using Extract, Transform and Load (ELT) Technologies. Learning software integration by using Java language and other technologies. Giving a quick introduction to Big Data, MapReduce algorithm, and Hadoop Distributed File System.

Key Benefits

The aim of this subject is to provide students within depth knowledge of the Data warehousing and how it improves the speed and efficiency of accessing different data sets and makes it easier for corporate decision-makers to derive insights that will guide the business and marketing strategies that set them apart from their competitors. There are many exciting career paths available for students who are interested in working with data warehouses or within the larger field of business intelligence (BI), including data analytics, cyber security, computer networking, or IT management. BI professionals include data architects, database administrators, coders and analysts, among others.

Program Outline - NOC Code and Job Functions

Course Outline:

  • Introduction to Programming

  • Principle of E- Commerce

  • UNIX

  • Business Grammar and Writing

  • Business Communications

  • Database Management Systems

  • Object Oriented Design Methodology

  • System Analysis and Design

  • Introduction to Data Warehousing

  • SQL Fundamental for Data Warehousing

  • ABAP/4 Planning language

  • Introduction to Oracle Database

  • Oracle Warehouse Builder

  • Introduction of Business Intelligence

  • Business Information Warehouse

  • Data Mining

  • Case Study

  • Project - Data Warehousing

Associated National Occupation Classification (NOC) Codes

After pursuing a Diploma in Data Warehousing, the graduates are eligible for positions falling under the following job titles under NOC 2172:

  • Data administrator

  • Data custodian

  • Data dictionary administrator

  • Data warehouse analyst

  • Database administrator (DBA)

  • Database analyst

  • Database architect

  • Technical architect - database

Employment areas and Prospects

Database analysts design, develop and administer data management solutions using database management software. Data administrators develop and implement data administration policy, standards and models. They are employed in information technology consulting firms and in information technology units throughout the private and public sectors.

This group performs some or all of the following duties:

Database analysts

  • Collect and document user requirements

  • Design and develop database architecture for information systems projects

  • Design, construct, modify, integrate, implement and test data models and database management systems

  • Conduct research and provide advice to other informatics professionals regarding the selection, application and implementation of database management tools

  • Operate database management systems to analyze data and perform data mining analysis

  • May lead, co-ordinate or supervise other workers in this group

Database administrators

  • Develop and implement data administration policy, standards and models

  • Research and document data requirements, data collection and administration policy, data access rules and security

  • Develop policies and procedures for network and/or Internet database access and usage and for the backup and recovery of data

  • Conduct research and provide advice to other information systems professionals regarding the collection, availability, security and suitability of data

  • Write scripts related to stored procedures and triggers

  • May lead and co-ordinate teams of data administrators in the development and implementation of data policies, standards and models.

Mode of Training

This program is offered in-class format only.