Month 5: Exploring Data Warehousing
Week 1: Basics of Data Warehousing
- Day 1: Introduction to Data Warehousing
- Day 2: Data Warehousing Concepts
- Day 3: Data Warehouse Architecture
- Day 4: Data Marts and Data Lakes
- Day 5: Benefits of Data Warehousing
Week 2: Data Warehousing Design
- Day 1: Designing a Data Warehouse
- Day 2: Data Modeling for Data Warehouses
- Day 3: ETL Process in Data Warehousing
- Day 4: OLAP vs OLTP
- Day 5: Star and Snowflake Schemas
Week 3: Implementing Data Warehouses
- Day 1: Data Warehouse Implementation Process
- Day 2: Data Warehousing Tools
- Day 3: Building a Data Warehouse with SQL Server
- Day 4: Building a Data Warehouse with AWS Redshift
- Day 5: Building a Data Warehouse with Google BigQuery
Week 4: Advanced Topics in Data Warehousing
- Day 1: Real-Time Data Warehousing
- Day 2: Data Warehousing in the Cloud
- Day 3: Security and Privacy in Data Warehousing
- Day 4: Data Warehouse Testing
- Day 5: Future Trends in Data Warehousing
dowhatkennydoes.com 