E-1320878

Implementing a Microsoft SQL 2016 Data Warehouse • E-learning

Tananyag hossza
25 óra 18 perc
Elérhető képzési nyelvek
  • Magyar
Képzési forma
Személyre szabott ajánlatot szeretnél?
Kollégáink készséggel állnak rendelkezésedre, hogy segítsenek a neked megfelelő megoldás kialakításában.
Ajánlatot kérek

Tematika

Module 0: Implementing a SQL Data Warehouse - Overview
  • Overview: Implementing a SQL Data Warehouse - Overview
Module 1: Introduction to Data Warehousing
  • Overview: Introduction to Data Warehousing
  • Lesson 1: Overview of Data Warehousing
  • Lesson 2: Considerations for a Data Warehouse Solution
  • Lab 1: Exploring a Data Warehousing Solution
Module 2: Planning Data Warehouse Infrastructure
  • Overview: Planning Data Warehouse Infrastructure
  • Lesson 1: Considerations for Data Warehouse Infrastructure
  • Lesson 2: Planning Data Warehouse Hardware
  • Lab 2: Planning Data Warehouse Infrastructure
Module 3: Designing and Implementing a Data Warehouse
  • Overview: Designing and Implementing a Data Warehouse
  • Lesson 1: Data Warehouse Design Overview
  • Lesson 2: Designing Dimension Tables
  • Lesson 3: Designing Fact Tables
  • Lesson 4: Physical Design for a Data Warehouse
  • Lab 3: Implementing a Data Warehouse
Module 4: Columnstore Indexes
  • Overview: Columnstore Indexes
  • Lesson 1: Introduction to Columnstore Indexes
  • Lesson 2: Creating Columnstore Indexes
  • Lesson 3: Working with Columnstore Indexes
  • Lab 4: Using Columnstore Indexes
Module 5: Implementing an Azure SQL Data Warehouse
  • Overview: Implementing an Azure SQL Data Warehouse
  • Lesson 1: Advantages of Azure SQL Data Warehouse
  • Lesson 2: Implementing an Azure SQL Data Warehouse Database
  • Lesson 3: Developing an Azure SQL Data Warehouse
  • Lesson 4: Migrating to an Azure SQL Data Warehouse
  • Lesson 5: Copying Data with the Azure Data Factory
  • Lab 5: Implement an Azure SQL Data Warehouse
Module 6: Creating an ETL Solution
  • Overview: Creating an ETL Solution
  • Lesson 1: Introduction to ETL with SSIS
  • Lesson 2: Exploring Source Data
  • Lesson 3: Implementing Data Flow
  • Lab 6: Implementing Data Flow in an SSIS Package
Module 7: Implementing Control Flow in an SSIS Package
  • Overview: Implementing Control Flow in an SSIS Package
  • Lesson 1: Introduction to Control Flow
  • Lesson 2: Creating Dynamic Packages
  • Lesson 3: Using Containers
  • Lab 7A: Implementing Control Flow in an SSIS Package
  • Lesson 4: Managing Consistency
  • Lab 7B: Using Transactions and Checkpoints
Module 8: Debugging and Troubleshooting SSIS Packages
  • Overview: Debugging and Troubleshooting SSIS Packages
  • Lesson 1: Debugging an SSIS Package
  • Lesson 2: Logging SSIS Package Events
  • Lesson 3: Handling Errors in an SSIS Package
  • Lab 8: Debugging and Troubleshooting an SSIS Package
Module 9: Implementing a Data Extraction Solution
  • Overview: Implementing a Data Extraction Solution
  • Lesson 1: Introduction to Incremental ETL
  • Lesson 2: Extracting Modified Data
  • Lab 9A: Extracting Modified Data
  • Lesson 3: Loading Modified Data
  • Lesson 4: Temporal Tables
  • Lab 9B: Loading a Data Warehouse
Module 10: Enforcing Data Quality
  • Overview: Enforcing Data Quality
  • Lesson 1: Introduction to Data Quality
  • Lesson 2: Using Data Quality Services to Cleanse Data
  • Lab 10A: Cleansing Data
  • Lesson 3: Using Data Quality Services to Match Data
  • Lab 10B: Deduplicating Data
Module 11: Master Data Services
  • Overview: Master Data Services
  • Lesson 1: Introduction to Master Data Services
  • Lesson 2: Implementing a Master Data Services Model
  • Lesson 3: Hierarchies and Collections
  • Lesson 4: Creating a Master Data Hub
  • Lab 11: Implementing Master Data Services Model
Module 12: Extending SQL Server Integration Services
  • Overview: Extending SQL Server Integration Services
  • Lesson 1: Using Scripts in SSIS
  • Lesson 2: Using Custom Components in SSIS
  • Lab 12: Using Custom Scripts
Module 13: Deploying and Configuring SSIS Packages
  • Overview: Deploying and Configuring SSIS Packages
  • Lesson 1: Overview of SSIS Development
  • Lesson 2: Deploying SSIS Projects
  • Lesson 3: Planning SSIS Package Execution
  • Lab 13: Deploying and Configuring SSIS Packages
Module 14: Consuming Data in a Data Warehouse
  • Overview: Consuming Data in a Data Warehouse
  • Lesson 1: Introduction to Business Intelligence
  • Lesson 2: Introduction to Data Analysis
  • Lesson 3: Introduction to Reporting
  • Lesson 4: Analyzing Data with Azure SQL Data Warehouse
  • Lab 14: Using a Data Warehouse
Tematika (PDF)