We are happy to advise you!
0845 470 1000     Contact

Instructor-Led Online Training (ILO)
Live Online Classes in the Virtual Classroom

Find out more and view dates

> > > 20767 Detailed outline

Implementing a SQL Data Warehouse (20767)

Detailed Course Outline

Module 1: Introduction to Data Warehousing
  • Overview of Data Warehousing
  • Considerations for a Data Warehouse Solution
Module 2: Planning Data Warehouse Infrastructure
  • Considerations for Building a Data Warehouse
  • Data Warehouse Reference Architectures and Appliances
Module 3: Designing and Implementing a Data Warehouse
  • Logical Design for a Data Warehouse
  • Physical Design for a Data Warehouse
Module 4: Columnstore 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
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
Module 8: Debugging and Troubleshooting SSIS Packages
  • Debugging an SSIS Package
  • Logging SSIS Package Events
  • Handling Errors in an SSIS Package
Module 9: Implementing an Incremental ETL Process
  • Introduction to Incremental ETL
  • Extracting 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
  • Master Data Services Concepts
  • Implementing a Master Data Services Model
  • Managing Master Data
  • Creating a Master Data Hub
Module 12: Extending SQL Server Integration Services (SSIS)
  • Using Custom Components in SSIS
  • Using Scripting 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
  • Introduction to Reporting
  • An Introduction to Data Analysis
  • Analyzing Data with Azure SQL Data Warehouse

Labs

  • Exploring a Data Warehouse Solution
  • Planning Data Warehouse Infrastructure
  • Implementing a Data Warehouse Schema
  • Using Columnstore Indexes
  • Implementing an Azure SQL 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 DataLab : Loading Incremental Changes
  • Cleansing DataLab : De-duplicating Data
  • Implementing Master Data Services
  • Using Scripts and Custom Components
  • Deploying and Configuring SSIS Packages
  • Using Business Intelligence Tools