> > > 20463 Detailed outline

Implementing a Data Warehouse with Microsoft SQL Server (20463)

Course Description Schedule Course Outline

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 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
 

Accessing our website tells us you are happy to receive all our cookies. However you can change your cookie settings at any time. Find out more.   Got it!