Course Code: ITE 5423
Academic Year: 2024-2025
This course is intended for those who wish to maintain and use data warehouses. Before attending this course, students should be familiar with relational database concepts and basic data warehouse theory. The course will look at materialized views; the extract, transform and load (ETL) framework; and loading data from various sources. Several tools will be utilized to work with the data warehouse: SQL*Loader, data pump, and import and export. The benefits of parallelization and query rewrite will also be covered. Materialized views and partitioning will be discussed in detail.