DATA WAREHOUSE (2/1 Credits)

Learning Outcomes:

On successful completion of this course, student will be able to: Identify the basic concepts, components, environment, architecture and technologies of data warehouse; Explain the requirements and how to design data warehouse; Analyze collection of data and techniques for processing the data in data warehouse; Analyze the strategy of design and implement data warehouse appropriate to the need.

Topics:

1. Data Warehousing Concepts;
2. Migration to the Architected Environment;
3. Project Collection;
4. The Data Warehouse Environment;
5. Granularity in the Data Warehouse; T
6. he Data Warehouse and the Web;
7. The Data Warehouse Environment;
8. The Data Warehouse and the Web;
9. Data Warehousing Design;
10. OLAP;
11. The Relational and the Multidimensional Models as a Basis for Database Design;
12. The Data Warehouse and the ODS;
13. The Data Warehouse and Technology;
14. External Data and the Data Warehouse;
15. Unstructured Data and the Data Warehouse;
16. The Distributed Data warehouse;
17. Data Warehousing Design;
18. Quiz and The Relational and the Multidimensional Models as a Basis for Database Design;
19. The Data Warehouse and the Web (2).