Welcome to Data Warehouse Design
Goal:
To adequately prepare the
students to understand the basic concepts of Data warehouse theory, design and
implementation.
Important things should be known after studying this course:
* Explain Data Warehousing
characteristics and requirements.
* Discuss OLTP vs Data
Warehouse and data warehouse architecture
* Apply the logical and
physical design of data warehousing using various Schema design with
Fact table
and Dimension table.
* Apply Extract Transform and
Load (ETL) process using Materialized view.
* Develop OLAP operation,
storage and indexing using partition, data modeling.
* Verify Data
warehouse testing, backup, recovery and Performance Tuning
IT Society blog Team
.png)
Post a Comment