ICC Teleservices Ltd

Implementing a SQL Data Warehouse Training from ICC Teleservices

Duration 40(Hrs)

Buy Now

COURSE OUTLINE

1 - INTRODUCTION TO DATA WAREHOUSING

Gain an Introduction to Data Warehousing
Consider Factors Involved in a Data Warehouse Solution
Lab: Exploring a Data Warehouse Solution

2 - PLANNING DATA WAREHOUSE INFRASTRUCTURE

Review Considerations for Building a Data Warehouse
Plan Data Warehouse Hardware
Lab: Planning Data Warehouse Infrastructure

3 - DESIGNING AND IMPLEMENTING A DATA WAREHOUSE

Design Dimension Tables and Fact Tables
Determine Physical Design for a Data Warehouse
Lab: Implementing a Data Warehouse Schema

4 - COLUMNSTORE INDEXES

Review Columnstore Indexes
Create and Work with Columnstore Indexes
Lab: Using Columnstore Indexes

5 - IMPLEMENTING AN AZURE SQL DATA WAREHOUSE

Understand the Advantages of Azure SQL Data Warehouse
Implement an Azure SQL Data Warehouse
Develop an Azure SQL Data Warehouse
Migrate to an Azure SQL Data Warehouse
Copy Data with the Azure Data Factory
Lab: Implementing an Azure SQL Data Warehouse

6 - CREATING AN ETL SOLUTION

Gain an Introduction to ETL with SSIS
Explore Source Data
Implement Data Flow
Lab: Implementing Data Flow in an SSIS Package

7 - IMPLEMENTING CONTROL FLOW IN AN SSIS PACKAGE

Introduce Control Flow
Create Dynamic Packages
Adopt Containers
Lab: Implementing Control Flow in an SSIS Package
Lab: Using Transactions and Checkpoints

8 - DEBUGGING & TROUBLESHOOTING SSIS PACKAGES

Debug an SSIS Package
Log SSIS Package Events
Handle Errors in an SSIS Package
Lab: Debugging and Troubleshooting an SSIS Package

9 - IMPLEMENTING A DATA EXTRACTION SOLUTION

Navigate Incremental ETL
Extract and Load Modified Data
Manage Temporal Tables
Lab: Extracting Modified Data
Lab: Loading Incremental Changes

10 - ENFORCING DATA QUALITY

Apply Data Quality Services to Cleanse Data
Use Data Quality Services to Match Data
Lab: Cleansing Data
Lab: De-Duplicating Data

11 - USING MASTER DATA SERVICES

Become Familiar with Master Data Services
Execute a Master Data Services Model
Create a Master Data Hub
Lab: Implementing Master Data Services

12 - EXTENDING SQL SERVER INTEGRATION SERVICES (SSIS)

Utilize Custom Components in SSIS
Perform Scripting in SSIS
Lab: Using Scripts and Custom Components

13 - DEPLOYING AND CONFIGURING SSIS PACKAGES

Review SSIS Deployment
Deploy SSIS Projects
Plan SSIS Package Execution
Lab: Deploying and Configuring SSIS Packages

14 - CONSUMING DATA IN A DATA WAREHOUSE

Understand Basic Concepts of Business Intelligence, Reporting and Data Analysis
Analyze Data with Azure SQL Data Warehouse
Lab: Using Business Intelligence Tools

OUR PARTNER