Courses

Engineering > Computer Science


Course
Data Warehousing
Lecturer
Juma Emmanul Tandema Valentino
University
Uganda Technology and Management University
Period
Fall 2024
Language
English

Keyword

Syllabus

This course provides a comprehensive introduction to the principles and practices of data warehousing. Students will explore the design, implementation, and management of data warehouses, focusing on the architecture and infrastructure needed to support effective data storage and retrieval. Topics include data modeling, ETL (Extract, Transform, Load) processes, data warehouse architecture, and OLAP (Online Analytical Processing). The course also covers best practices for maintaining data quality and ensuring data security. Through hands-on exercises and real-world case studies, students will gain practical experience in building and managing data warehouses, preparing them for roles in data engineering, business intelligence, and analytics. By the end of the course, students will be equipped to design scalable data warehouse solutions that support informed decision-making in organizations.

No. File Download
1 3.Syllabus.pdf Download

Courses List

No. Course Format File Date
1 Week 1 - Data warehousing concept 2024-12-05
2 Week 2 - Data Warehousing Architecture 2024-12-05
3 Week 3 - Bringing Data into Data Warehouse 2024-12-05
4 Week 4 - Data Warehouse Design 2024-12-05
5 Week 5 - Design Fact and Dimension Tables 2024-12-05
6 Week 6 -Managing Data Warehouse History through slowing changing dimension 2024-12-05
7 Week 7 - Design Your Extract, Transform and Load 2024-12-05
8 Week 8 - Data Warehouse Performance and Optimization 2024-12-05
9 Week 9 - Data Quality and Governance 2024-12-05
10 Week 10 - Data Warehousing Security 2024-12-05
11 Week 11 - Selecting Your Data Warehousing Environment 2024-12-05
12 Week 12 - Advanced Topics in Data Warehousing 2024-12-05
13 Week 13 - Data Warehousing Overview 2024-12-05
14 Week 14 - Data Warehousing Question Bank 2024-12-05

제목