Implementing Data Warehouse

Current Status

Not Enrolled

Price

$1500

Get Started

Take this Course

Course Content

Expand All

MODULE 1

Overview of Data Warehousing 7 Topics

Expand

Lesson Content

0% Complete 0/7 Steps

The Business Problem

What Is a Data Warehouse?

Data Warehouse Architectures

Components of a Data Warehousing Solution

Data Warehousing Projects

Data Warehousing Project Roles

SQL Server as a Data Warehousing Platform

Considerations for a Data Warehouse Solution 4 Topics

Expand

Lesson Content

0% Complete 0/4 Steps

Data Warehouse Database and Storage

Data Sources

Extract, Transform, and Load Processes

Data Quality and Master Data Management

MODULE 2

Considerations for Data Warehouse Infrastructure 5 Topics

Expand

Lesson Content

0% Complete 0/5 Steps

System Sizing Considerations

Data Warehouse Workloads

Typical Server Topologies for a BI Solution

Scaling-out a BI Solution

Planning for High Availability

Planning Data Warehouse Hardware 8 Topics

Expand

Lesson Content

0% Complete 0/8 Steps

SQL Server Fast Track Reference Architectures

Core-Balanced System Architecture

Demonstration: Calculating Maximum Consumption Rate

Determining Processor and Memory Requirements

Determining Storage Requirements

Considerations for Storage Hardware

SQL Server Data Warehouse Appliances

SQL Server Parallel Data Warehouse

MODULE 3

Data Warehouse Design Overview 4 Topics

Expand

Lesson Content

0% Complete 0/4 Steps

The Dimensional Model

The Data Warehouse Design Process

Dimensional Modeling

Documenting Dimensional Models

Designing Dimension Tables 7 Topics

Expand

Lesson Content

0% Complete 0/7 Steps

Considerations for Dimension Keys

Dimension Attributes and Hierarchies

Unknown and None

Designing Slowly Changing Dimensions

Time Dimension Tables

Self-Referencing Dimension Tables

Junk Dimensions

Designing Fact Tables 3 Topics

Expand

Lesson Content

0% Complete 0/3 Steps

Fact Table Columns

Types of Measure

Types of Fact Table

Physical Design for a Data Warehouse 9 Topics

Expand

Lesson Content

0% Complete 0/9 Steps

Data Warehouses I/O Activity

Consideration for Database Files

Table Partitioning

Demonstration: Partitioning a Fact Table

Considerations for Indexes

Demonstration: Creating Indexes

Data Compression

Demonstration: Implementing Data Compression

Using Views to Abstract Base Tables

MODULE 4

Introduction to ETL with SSIS 5 Topics

Expand

Lesson Content

0% Complete 0/5 Steps

Options for ETL

What Is SSIS?

SSIS Projects and Packages

The SSIS Design Environment

Upgrading from Previous Versions

Exploring Source Data 5 Topics

Expand

Lesson Content

0% Complete 0/5 Steps

Why Explore Source Data?

Examining Source Data

Demonstration: Exploring Source Data

Profiling Source Data

Demonstration: Using the Data Profiling Task

Implementing Data Flow 7 Topics

Expand

Lesson Content

0% Complete 0/7 Steps

Optimizing Data Flow Performance

Demonstration: Implementing a Data Flow

MODULE 5

Introduction to Control Flow 6 Topics

Expand

Lesson Content

0% Complete 0/6 Steps

Control Flow Tasks

Precedence Constraints

Grouping and Annotations

Demonstration: Implementing Control Flow

Using Multiple Packages

Creating a Package Template

Creating Dynamic Packages 4 Topics

Expand

Lesson Content

0% Complete 0/4 Steps

Variables

Parameters

Expressions

Demonstration: Using Variables and Parameters

Using Containers 7 Topics

Expand

Lesson Content

0% Complete 0/7 Steps

Introduction to Containers

Sequence Containers

Demonstration: Using a Sequence Container

For Loop Containers

Demonstration: Using a For Loop Container

Foreach Loop Containers

Demonstration: Using a Foreach Loop Container

Managing Consistency 5 Topics

Expand

Lesson Content

0% Complete 0/5 Steps

Configuring Failure Behavior

Using Transactions

Demonstration: Using a Transaction

Using Checkpoints

Demonstration: Using a Checkpoint

MODULE 6

Debugging an SSIS Package 6 Topics

Expand

Lesson Content

0% Complete 0/6 Steps

Overview of SSIS Debugging

Viewing Package Execution Events

Breakpoints

Variable and Status Windows

Data Viewers

Demonstration: Debugging a Package

Logging SSIS Package Events 5 Topics

Expand

Lesson Content

0% Complete 0/5 Steps

SSIS Log Providers

Log Events and Schema

Implementing SSIS Logging

Viewing Logged Events

Demonstration: Logging Package Execution

Handling Errors in an SSIS Package 4 Topics

Expand

Lesson Content

0% Complete 0/4 Steps

Introduction to Error Handling

Implementing Event Handlers

Handling Data Flow Errors

Demonstration: Handling Errors

MODULE 7

Planning Data Extraction 6 Topics

Expand

Lesson Content

0% Complete 0/6 Steps

Overview of Data Warehouse Load Cycles

Considerations for Incremental ETL

Common ETL Data Flow Architectures

Planning Extraction Windows

Planning Transformations

Documenting Data Flows

Extracting Modified Data 11 Topics

Expand

Lesson Content

0% Complete 0/11 Steps

Options for Extracting Modified Data

Extracting Rows Based on a Datetime Column

Demonstration: Using a Datetime Column

Change Data Capture

Demonstration: Using Change Data Capture

Extracting Data with Change Data Capture

The CDC Control Task and Data Flow Components

Demonstration: Using CDC Components

Change Tracking

Demonstration: Using Change Tracking

Extracting Data with Change Tracking

1 of 2