SQL Server Data Warehouse Implementation

---

Course Overview

Participants will learn to perform ETL (Extraction Transformation and Loading) operations by creating SSIS packages, managing a control flow and data flow, executing packages, and troubleshooting errors. To ensure the smooth functioning of the ETL operations, you will manage SSIS packages and secure them. Delegates will use SSIS packages to design and build a Data Warehouse.

The course requires a working knowledge of SQL.

Duration: 3 day course

---

Course Content

Introduction to Data Warehouses
Overview of Data Warehouses
Examine Data Warehousing Concepts
Introduction to Data Analysis and Reporting Concepts

Creating Dimensions and Changing Granularity of Dimensions
Create Dimensions
Change Granularity

Creating Fact Tables and Columnstore Indexes
Create Fact Tables
Create Columnstore Indexes

Implementing Data Warehouses in SQL Server 2012
Overview of Data Warehouse Components
Install Integration Services

Working with Integration Services
Create an SSIS Project
Add Packages to an SSIS Project

Managing Control Flow
Deploy a Control Flow
Execute Packages from Different Control Flow

Working with Dynamic Variables
Create Expressions with Variables
Create Package Templates

Implementing Data Flow
Add Data Flow Components to a Data Flow Task
Perform Transformation Tasks
Track Changed Data

Managing Data Flow
Add Script Tasks and Script Components to an SSIS Package
Profile OLTP Data
Cleanse Data Using DQS

Managing SSIS Package Execution
Execute SSIS Packages on the Server
Configure the Package Execution Strategy

Debugging and Troubleshooting Packages
Debug Package Execution Components
Troubleshoot Package Failures

Deploying Packages
Deploy SSIS Packages
Examine MSI Packages

Securing Packages and Databases
Secure Packages
Secure Databases

Working with MDS and Windows Azure
Configure MDS
Work with MDS Databases
Work with Windows Azure

Email us about this courses


Telephone on 01952 938014