Εισηγητής
Περιγραφή σεμιναρίου
ΑΝΑΛΥΤΙΚΟ ΠΕΡΙΕΧΟΜΕΝΟ 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. • Designing dimension tables • Designing fact tables • Physical Design for a Data Warehouse Module 4: Column store Indexes. • Introduction to Columnstore Indexes • Creating Columnstore Indexes • Working with Columnstore Indexes Module 5: Implementing an Azure SQL Data Warehouse. • Advantages of Azure SQL Data Warehouse • Implementing an Azure SQL Data Warehouse • Developing an Azure SQL Data Warehouse • Migrating to an Azure SQ Data Warehouse • Copying data with the Azure data factory Module 6: Creating an ETL Solution. • Introduction to ETL with SSIS • Exploring Source Data • Implementing Data Flow Module 7: Implementing Control Flow in an SSIS Package • Introduction to Control Flow • Creating Dynamic Packages • Using Containers • Managing consistency Module 8: Debugging and Troubleshooting SSIS Packages • Debugging an SSIS Package • Logging SSIS Package Events • Handling Errors in an SSIS Package Module 9: Implementing a Data Extraction Solution • Introduction to Incremental ETL • Extracting Modified Data • Loading modified data • Temporal Tables Module 10: Enforcing Data Quality • Introduction to Data Quality • Using Data Quality Services to Cleanse Data • Using Data Quality Services to Match Data Module 11: Using Master Data Services • Introduction to Master Data Services • Implementing a Master Data Services Model • Hierarchies and collections • Creating a Master Data Hub Module 12: Extending SQL Server Integration Services (SSIS) • Using scripting in SSIS • Using custom components in SSIS Module 13: Deploying and Configuring SSIS Packages • Overview of SSIS Deployment • Deploying SSIS Projects • Planning SSIS Package Execution Module 14: Consuming Data in a Data Warehouse • Introduction to Business Intelligence • An Introduction to Data Analysis • Introduction to reporting • Analyzing Data with Azure SQL Data Warehouse
Πληροφορίες συμμετοχής
Ημερομηνίες Διεξαγωγής: 27,29,30 Νοεμβρίου & 4,6,7,11,13,15,18 Δεκεμβρίου Ωράριο: 17:00-21:00
Κόστος Συμμετοχής
Φόρμα Εκδήλωσης Ενδιαφέροντος