Data Warehousing

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