COM2007 - Database Management System and Data Warehousing

Year of Study:2
Credit Units: 3
Duration: 45hours
Prerequisites: Nil
Module Description
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.
Learning Outcomes
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.