Home  »  Agustus 2024 • Database • E-Learning • Information & Technology   »   E-Learning – Data Warehouse And Data Modeling

E-Learning – Data Warehouse And Data Modeling

Description

Build a solid foundation of data warehousing and modeling with this training. Learn the different modeling approaches like Kimball, Inmon and Data Vault, and how to work with data warehouse architectures, formal data modeling, performance tuning and more. You’ll put theory into practice with hands-on exercises in SQL, and create an entire data warehouse in a mainstream data warehouse of your choice.

Materi

1. Fundamentals in data warehousing and dimensional modelling
2. History of data modeling and modern day approaches
3. Foundations of main cloud data warehouses
4. How to setup staging, mart and reporting layers
5. Apply optimization techniques to improve query performance
6. Fact and Dimensions – the fundamental components of data modeling
7. Star and Snowflake schema designs
8. Slowly changing dimensions
9. Create your first cloud data warehouse in a mainstream data warehouse
10. Learn performance tuning techniques with real-world challenges