Base Knowledge
- Database Systems.
- Entity relationship model
- SQL
Teaching Methodologies
- A written exam: 40%
- Individual research assignments (Challenges): 20 %
- Practical work: 40%
Learning Results
When the students complete the course successfully, they should be able to
- Develop knowledge and comprehension skills in the area of Data Warehousing, relying on exposition in the classroom for teaching and research, in the texts performed by students and guided by the teacher.
- Analyze, design, build and administer a data warehouse.
- Develop the ability to apply the knowledge acquired in solving specific problems of life.
- To instill a professional attitude in developing their tasks by knowledge acquired and the ability to understand the scope, applicability and opportunity in specific situations of everyday life.
Program
1. Introduction and Concepts of Data Warehousing
2. Data Warehouse Architecture
3. Multidimensional Analysis and Star Schema
4. Project of Data Warehouses
5. Extraction, Transformation and Loading (ETL)
6. Aggregates and Performance in Data Warehousing
Internship(s)
NAO