Courses Catalogue

Data Warehousing

COURSE CODE: ITE 2201
COURSE CREDIT UNIT: 3
ACADEMIC PROGRAMME: Information Technology, B.Sc
COLLEGE/SCHOOL/FACULTY: School of Mathematics and Computing
STATUS: Core
PROGRAMME TYPE: Undergraduate

Course Content and Outline

Detailed Course Content:

Building on the transactional database understanding gained in during the pre-requisite courses, this course will cover topics such as;

1.         Data warehouse concepts: partitioning, granularity, record of source, and metadata                                                                                                                    8 Hours

2.         Building viable decision support environments.                                                8 Hours

3.         Architect development                                                                                8 Hours

4.         Use of operational data stores, and transactional systems                  8 Hours

5.         Data migration and integration                                                                  8 Hours

6.         On-line analytic processing                                                                                   8 Hours

7.         ROLAP vs MOLAP                                                                                      4 Hours

8.         Data mining.                                                                                                 8 Hours

Teaching-learning Methods:

Ø  Interactive lectures

Ø  Class presentations

Ø  Mini Project work.

Teaching-learning Materials:

  • Whiteboard and Markers
  • Flip Charts
  • LCD Projectors
  • CDs, DVDs, and Tapes
  • Laptop