- Home
- Courses
- Курсове с Инструктор
- Microsoft
- 767 – Implementing a SQL Data Warehouse
767 – Implementing a SQL Data Warehouse
- 0 (Registered)
-
(0 Reviews)
Curriculum
- 14 Sections
- 63 Lessons
- 10 Weeks
Expand all sectionsCollapse all sections
- Module 1: Introduction to Data WarehousingThis module describes data warehouse concepts and architecture consideration.3
- Module 2: Planning Data Warehouse InfrastructureThis module describes the main hardware considerations for building a data warehouse.3
- Module 3: Designing and Implementing a Data WarehouseThis module describes how you go about designing and implementing a schema for a data warehouse.5
- Module 4: Columnstore IndexesThis module introduces Columnstore Indexes.4
- Module 5: Implementing an Azure SQL Data WarehouseThis module describes Azure SQL Data Warehouses and how to implement them.6
- Module 6: Creating an ETL SolutionAt the end of this module you will be able to implement data flow in a SSIS package.4
- Module 7: Implementing Control Flow in an SSIS PackageThis module describes implementing control flow in an SSIS package.6
- Module 8: Debugging and Troubleshooting SSIS PackagesThis module describes how to debug and troubleshoot SSIS packages.4
- Module 9: Implementing a Data Extraction SolutionThis module describes how to implement an SSIS solution that supports incremental DW loads and changing data.6
- Module 10: Enforcing Data QualityThis module describes how to implement data cleansing by using Microsoft Data Quality services.5
- Module 11: Using Master Data ServicesThis module describes how to implement master data services to enforce data integrity at source.5
- Module 12: Extending SQL Server Integration Services (SSIS)This module describes how to extend SSIS with custom scripts and components.3
- Module 13: Deploying and Configuring SSIS PackagesThis module describes how to deploy and configure SSIS packages.4
- Module 14: Consuming Data in a Data WarehouseThis module describes how to debug and troubleshoot SSIS packages.5
Analyzing Data with Azure SQL Data Warehouse
Prev