Year of Study:	2
Credit Units:	3
Duration:	45hours
Prerequisites:	Nil

This module trains students with practical skills in database management system and introduces several important concepts in data warehousing. First, the module teaches students how to use SQL to interact with a database to retrieve data and perform calculation over a large amount of data. Then, major technologies of data warehousing are discussed, including ETL tools, online analytical processing (OLAP) and visualization, e.g., using dashboard.

Upon completion of this module, students should be able to:

1. understand what database and data warehouse are;


2. formulate SQL queries to interact with a database;


3. explain techniques in data warehousing, e.g., OLAP; and


4. develop business intelligence (BI) applications using common software, e.g., SAS and PowerBI.