<
Live Online
Databases

Implementing a Data Warehouse with Microsoft SQL Server 2014

$2,995.00 USD$2,695.50 USD
Get discounts withPremium
Member discount will apply to your offsite enrollment
  • About
  • Curriculum

This course describes how to implement a data warehouse platform to support a BI solution. Students will learn how to create a data warehouse with Microsoft® SQL Server® 2014, implement ETL with SQL Server Integration Services, and validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services.

Note: This course is designed for customers who are interested in learning SQL Server 2012 or SQL Server 2014. It covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform.

Prerequisites

This course requires that you meet the following prerequisites:

  • At least 2 years’ experience of working with relational databases, including:
  • Designing a normalized database.
  • Creating tables and relationships.
  • Querying with Transact-SQL.
  • Some exposure to basic programming constructs (such as looping and branching).
  • An awareness of key business priorities such as revenue, profitability, and financial accounting is desirable.

Course Objectives

After completing this course, students will be able to:

  • Describe data warehouse concepts and architecture considerations.
  • Select an appropriate hardware platform for a data warehouse.
  • Design and implement a data warehouse.
  • Implement Data Flow in an SSIS Package.
  • Implement Control Flow in an SSIS Package.
  • Debug and Troubleshoot SSIS packages.
  • Implement an ETL solution that supports incremental data extraction.
  • Implement an ETL solution that supports incremental data loading.
  • Implement data cleansing by using Microsoft Data Quality Services.
  • Implement Master Data Services to enforce data integrity.
  • Extend SSIS with custom scripts and components.
  • Deploy and Configure SSIS packages.
  • Describe how BI solutions can consume data from the data warehouse.

Intended Audience

This course is intended for database professionals who need to fulfil a Business Intelligence Developer role. They will need to focus on hands-on work creating BI solutions including Data Warehouse implementation, ETL, and data cleansing. Primary responsibilities include:

  • Implementing a data warehouse.
  • Developing SSIS packages for data extraction, transformation, and loading.
  • Enforcing data integrity by using Master Data Services.
  • Cleansing data by using Data Quality Services.

About the Author

NterOne is a global training and consulting company focusing on live online IT training courses, self-paced e-learning, private onsite training, consulting, and software focused on the training industry.
Posted: 20 December, 2016

Module 1: Introduction to Data Warehousing

This module provides an introduction to the key components of a data warehousing solution and the high-level considerations you must take into account when you embark on a data warehousing project.

  • Overview of Data Warehousing
  • Considerations for a Data Warehouse Solution

Lab: Exploring a Data Warehousing Solution

After completing this module, you will be able to:

  • Describe the key elements of a data warehousing solution
  • Describe the key considerations for a data warehousing project

Module 2: Data Warehouse Hardware Considerations

This module discusses considerations for selecting hardware and distributing SQL Server facilities across servers.

  • Considerations for building a Data Warehouse
  • Data Warehouse Reference Architectures and Appliances

Lab: Planning Data Warehouse Infrastructure

After completing this module, you will be able to:

  • Describe key considerations for BI infrastructure.
  • Plan data warehouse infrastructure.

Module 3: Designing and Implementing a Data Warehouse

This module describes the key considerations for the logical design of a data warehouse, and then discusses best practices for its physical implementation.

  • Logical Design for a Data Warehouse
  • Physical design for a data warehouse

Lab: Implementing a Data Warehouse Schema

After completing this module, you will be able to:

  • Describe a process for designing a dimensional model for a data warehouse
  • Design dimension tables for a data warehouse
  • Design fact tables for a data warehouse
  • Design and implement effective physical data structures for a data warehouse
This is a certification course.
By completing this course, you are eligible for certification opportunities. This course provides the instruction and educational material needed to prepare for a third-party certification exam.
This is a course package.
Course packages provide a comprehensive learning plan at a discounted price, and may lead to certification opportunities.