Toll Free - 877-442-3915

Account | Self-Paced Login

Account | Self-Paced Login | 877-442-3915

Implementing a Data Warehouse with Microsoft SQL Server Course

Implementing a Data Warehouse with Microsoft SQL Server Training Course


Course Description:

Training Dates
(Click on the course name below to view course details and full list of class dates)

Implementing a Data Warehouse with Microsoft SQL Server
Locations: Available Nationwide and Online
Class Date(s): 12/3/2018 - 12/7/2018
Course Fee : $2795


Implementing a Data Warehouse with Microsoft SQL Server
Locations: Available Nationwide and Online
Class Date(s): 1/7/2019 - 1/11/2019
Course Fee : $2795


Implementing a Data Warehouse with Microsoft SQL Server
Locations: Available Nationwide and Online
Class Date(s): 2/4/2019 - 2/8/2019
Course Fee : $2795


Course Syllabus


Section 1: Introduction to Data Warehousing
This section provides an introduction to the key components of a data warehousing solution and the high-level considerations students must take into account when starting a data warehousing project.

Topics:
Overview of Data Warehousing
Considerations for a Data Warehouse Solution
Lab 1: Exploring a Data Warehousing Solution
Exploring Data Sources
Exploring and ETL Process
Exploring a Data Warehouse

Section 2: Planning Data Warehouse Infrastructure
This section discusses considerations for selecting hardware and distributing SQL Server facilities across servers.

Topics:
Considerations for Data Warehouse Infrastructure
Planning Data Warehouse Hardware
Lab 1: Planning Data Warehouse Infrastructure
Planning Data Warehouse Hardware

Section 3: Designing and Implementing a Data Warehouse
This section describes the key considerations for the logical design of a data warehouse, and then discusses best practices for its physical implementation.

Topics:
Data Warehouse Design Overview
Designing Dimension Tables
Designing Fact Tables
Physical Design for a Data Warehouse
Lab 1: Implementing a Data Warehouse
Implementing a Star Schema
Implementing a Snowflake Schema
Implementing a Time Dimension

Section 4: Creating an ETL Solution with SSIS
This section discusses considerations for implementing an ETL process, and then focuses on Microsoft SQL Server Integration Services (SSIS) as a platform for building ETL solutions.

Topics:
Introducing ETL with SSIS
Exploring Data Sources
Implementing Data Flow
Lab 1: Implementing Data Flow in an SSIS Package
Exploring Data Sources
Transferring Data by Using a Data Flow Task
Using Transformations in a Data Flow

Section 5: Implementing Control Flow in an SSIS Package
This section describes how to implement ETL solutions that combine multiple tasks and workflow logic.

Topics:
Introduction to Control Flow
Creating Dynamic Packages
Using Containers
Managing Consistency
Lab 1: Implementing Control Flow in an SSIS Package
Using Tasks and Precedence in a Control Flow
Using Variables and Parameters
Using Containers
Lab 1: Using Transactions and Checkpoints
Using Transactions
Using Checkpoints

Section 6: Debugging and Troubleshooting SSIS Packages
This section describes how you can debug packages to find the cause of errors that occur during execution. It then discusses the logging functionality built into SSIS that you can use to log events for troubleshooting purposes. Finally, the section describes common approaches for handling errors in control flow and data flow.

Topics:
Debugging an SSIS Package
Logging SSIS Package Events
Handling Errors in an SSIS Package
Lab 1: Debugging and Troubleshooting an SSIS Package
Debugging an SSIS Package
Logging SSIS Package Execution
Implementing an Event Handler
Handling Errors in a Data Flow

Section 7: Implementing a Data Extraction Solution
This section describes the techniques you can use to implement an incremental data warehouse refresh process.

Topics:
Planning Data Extraction
Extracting Modified Data
Lab 1: Extracting Modified Data
Using a Datetime Column
Using Change Data Capture
Using the CDC Control Task
Using Change Tracking

Section 8: Loading Data into a Data Warehouse
This section describes the techniques you can use to implement data warehouse load process.

Topics:
Planning Data Loads
Using SSIS for Incremental Loads
Using Transact-SQL Loading Techniques
Lab 1: Loading a Data Warehouse
Loading Data from CDC Output Tables
Using a Lookup Transformation to Insert or Update Dimension Data
Implementing a Slowly Changing Dimension
Using the MERGE Statement

Section 9: Enforcing Data Quality
This section introduces Microsoft SQL Server Data Quality Services (DQS), and describes how you can use it to cleanse and deduplicate data.

Topics:
Introduction to Data Quality
Using Data Quality Services to Cleanse Data
Using Data Quality Services to Cleanse Data
Lab 1: Cleansing Data
Creating a DQS Knowledge Base
Using a DQS Project to Cleanse Data
Using DQS in an SSIS Package

Section 10: Master Data Services
Master Data Services provides a way for organizations to standardize data and improve the quality, consistency, and reliability of the data that guides key business decisions. This section introduces Master Data Services and explains the benefits of using it.

Topics:
Introduction to Master Data Services
Implementing a Master Data Services Model
Managing Master Data
Creating a Master Data Hub
Lab 1: Implementing Master Data Services
Creating a Master Data Services Model
Using the Master Data Services Add-in for Excel
Enforcing Business Rules
Loading Data Into a Model
Consuming Master Data Services Data

Section 11: Extending SQL Server Integration Services
This section describes the techniques you can use to extend SSIS. The section is not designed to be a comprehensive guide to developing custom SSIS solutions, but to provide an awareness of the fundamental steps required to use custom components and scripts in an ETL process that is based on SSIS.

Topics:
Using Scripts in SSIS
Using Custom Components in SSIS
Lab 1: Using Custom Scripts
Using a Script Task

Section 12: Deploying and Configuring SSIS Packages
In this section, students will learn how to deploy packages and their dependencies to a server, and how to manage and monitor the execution of deployed packages.

Topics:
Overview of SSIS Deployment
Deploying SSIS Projects
Planning SSIS Package Execution
Lab 1: Deploying and Configuring SSIS Packages
Creating an SSIS Catalog
Deploying an SSIS Project
Running an SSIS Package in SQL Server Management Studio
Scheduling SSIS Packages with SQL Server Agent

Section 13: Consuming Data in a Data Warehouse
This section introduces business intelligence (BI) solutions and describes how you can use a data warehouse as the basis for enterprise and self-service BI.

Topics:
Introduction to Business Intelligence
Enterprise Business Intelligence
Self-Service BI and Big Data
Lab 1: Using a Data Warehouse
Exploring an Enterprise BI Solution
Exploring a Self-Service BI Solution

Available Locations

Alabama
Birmingham
Birmingham South
Huntsville
Mobile
Montgomery

Arizona
Mesa
Phoenix
Scottsdale
Tucson

Arkansas
Bentonville
Fayetteville
Little Rock
Little Rock west

California
Bakersfield
El Segundo
Elk Grove
Fresno
Glendale
Irvine
Los Angeles
Los Angeles West
Mission Valley
Orange
Palo Alto
Petaluma
Pleasanton
Redwood City
Riverside
Sacramento
San Diego
San Diego downtown
San Francisco
San Jose
Walnut Creek
Woodland Hills

Colorado
Boulder
Centennial
Colorado Springs
Denver
Fort Collins
Grand Junction
Lakewood
Loveland

Connecticut
Cheshire
Danbury
East Granby
Hartford
Rocky Hill
Shelton
Stamford

Delaware
Wilmington DE

Florida
Boca Raton
Brandon
Clearwater
Daytona Beach
Fort Myers
Fort Walton Beach
Ft Lauderdale
Jacksonville
Kissimmee
Lake Mary
Lakeland
Land O Lakes
Melbourne
Miami
Miami Doral
Miramar Beach
Naples
Orange Park
Orlando
Orlando Downtown
Orlando Northeast
Palm Beach Gardens
Pensacola
Plantation
Sarasota
St Petersburg
Tallahassee
Tampa
Vero Beach

Georgia
Alpharetta
Atlanta Buckhead
Augusta
Columbus GA
Duluth
Kennesaw
Macon
Savannah

Idaho
Boise
Meridian

Illinois
Chicago
Gurnee
Joliet
Naperville
Northbrook
Oakbrook Terrace
Peoria
Rockford
Schaumburg

Indiana
Carmel
Evansville
Fort Wayne
Indianapolis
Indianapolis downtown
South Bend

Iowa
Cedar Rapids
Des Moines
Quad Cities

Kansas
Lenexa
Topeka
Wichita

Kentucky
Erlanger
Lexington
Louisville

Louisiana
Baton Rouge
Lafayette
New Orleans

Maine
Portland ME

Maryland
Annapolis
Baltimore
Bethesda
Columbia MD
Ellicott City
Frederick
Germantown
Greenbelt
Owings Mills
Rockville
Towson

Massachusetts
Boston
Braintree
Danvers
Mansfield
Newton
North Andover
Norwell
Springfield MA
Westborough
Woburn
Worcester

Michigan
Ann Arbor
Franklin MI
Grand Rapids
Kalamazoo
Lansing
Livonia
Novi
Traverse City
Troy

Minnesota
Bloomington
Maple Grove
Minneapolis
Minneapolis downtown
Rochester MN
St Cloud
Woodbury

Mississippi
Gulfport
Jackson

Missouri
Columbia MO
Kansas City
Lees Summit
O Fallon
Springfield
St Louis
St Louis downtown

Montana
Great Falls

Nebraska
Lincoln
Omaha

Nevada
Henderson
Las Vegas
Reno

New Hampshire
Bedford
Concord
Londonderry
Nashua
Portsmouth

New Jersey
Bridgewater
East Brunswick
East Rutherford
Hamilton
Jersey City
Mahwah
Morristown
Mt Laurel
Paramus
Princeton
Red Bank

New Mexico
Albuquerque

New York
Albany
Bohemia
Brooklyn
Buffalo
Harrison
Melville
Mt Kisco
New York City - Grand Central Station
New York City - Lower Manhattan
New York City - Penn Station
Poughkeepsie
Queens
Rochester
Syracuse
Uniondale

North Carolina
Asheville
Chapel Hill
Charlotte
Charlotte North
Charlotte Uptown
Fayetteville
Greensboro
Hickory
Morrisville
Raleigh
Wilmington

North Dakota
Fargo
Grand Forks

Ohio
Akron
Beachwood
Blue Ash
Cincinnati
Cleveland
Columbus
Columbus Downtown
Dayton
Dublin
Independence OH
Norwood
Toledo
Westlake
Youngstown

Oklahoma
Edmond
Oklahoma City
Tulsa

Oregon
Beaverton
Eugene
Medford
Portland
Salem
Tualatin

Pennsylvania
Allentown
Conshohocken
Erie
Harrisburg
Huntingdon Valley
Lancaster
Malvern
Philadelphia
Pittsburgh
Pittsburgh downtown
State College
University Center
Wexford
York

Rhode Island
Providence
Warwick

South Carolina
Cayce
Greenville
Mount Pleasant

South Dakota
Sioux Falls

Tennessee
Chattanooga
Franklin
Knoxville
Memphis
Nashville

Texas
Addison
Amarillo
Austin
Austin downtown
Bryan
Corpus Christi
Dallas
El Paso
Fort Worth
Grapevine
Houston
Houston North
Irving
Katy
Keller
League City
McAllen
Midland
Plano
Plano Frisco
San Antonio
San Antonio downtown
Sugar Land
The Woodlands
Waco

Utah
Provo
Salt Lake City

Vermont
Shelburne

Virginia
Alexandria
Arlington VA
Charlottesville
Fairfax
Fredericksburg
Glen Allen
Lynchburg
Manassas
McLean
Newport News
Norfolk
Reston
Richmond
Roanoke

Washington
Bellevue
Bellingham
Bothell
Kennewick
Mukilteo
Olympia
Puyallup
Seattle
Spokane
Tacoma

Washington DC
Washington DC
Washington DC - Union Station

West Virginia
Martinsburg

Wisconsin
Brookfield
Glendale WI
Green Bay
Madison
Madison east
Milwaukee

Wyoming
Casper
Cheyenne


Online Self-Paced Training Value Package Only $149

"The Instructor made class truly interesting and put everything into real world terms."
- Meredith T(Jersey City, NJ)


Business Computer Skills BBB Profile