Esquema Detallado del Curso
Module 1: Introduction to Data Warehousing
- Overview of Data Warehousing
- Considerations for a Data Warehouse Solution
Module 2: Planning Data Warehouse Infrastructure
- Considerations for Data Warehouse Infrastructure
- Planning Data Warehouse Hardware
Module 3: Designing and Implementing a Data Warehouse
- Data Warehouse Design Overview
- Designing Dimension Tables
- Designing Fact Tables
- Physical Design for a Data Warehouse
Module 4: Creating an ETL Solution with SSIS
- Introduction to ETL with SSIS
- Exploring Data Sources
- Implementing Data Flow
Module 5: Implementing Control Flow in an SSIS Package
- Introduction to Control Flow
- Creating Dynamic Packages
- Using Containers
- Managing Consistency
Module 6: Debugging and Troubleshooting SSIS Packages
- Debugging an SSIS Package
- Logging SSIS Package Events
- Handling Errors in an SSIS Package
Module 7: Implementing a Data Extraction Solution
- Planning Data Extraction
- Extracting Modified Data
Module 8: Loading Data into a Data Warehouse
- Planning Data Loads
- Using SSIS for Incremental Loads
- Using Transact-SQL Loading Techniques
Module 9: Enforcing Data Quality
- Introduction to Data Quality
- Using Data Quality Services to Cleanse Data
- Using Data Quality Services to Cleanse Data
Module 10: Master Data Services
- Introduction to Master Data Services
- Implementing a Master Data Services Model
- Managing Master Data
- Creating a Master Data Hub
Module 11: Extending SQL Server Integration Services
- Using Scripts in SSIS
- Using Custom Components in SSIS
Module 12: Deploying and Configuring SSIS Packages
- Overview of SSIS Deployment
- Deploying SSIS Projects
- Planning SSIS Package Execution
Module 13: Consuming Data in a Data Warehouse
- Introduction to Business Intelligence
- Enterprise Business Intelligence
- Self-Service BI and Big Data
Labs
- Exploring a Data Warehousing Solution
- Planning Data Warehouse Infrastructure
- Implementing a Data Warehouse
- Implementing Data Flow in an SSIS Package
- Implementing Control Flow in an SSIS Package
- Using Transactions and Checkpoints
- Debugging and Troubleshooting an SSIS Package
- Extracting Modified Data
- Loading a Data Warehouse
- Cleansing Data
- Implementing Master Data Services
- Using Custom Scripts
- Deploying and Configuring SSIS Packages
- Using a Data Warehouse