We use cookies to offer you a better experience and to analyse how visitors use our site, you may consent to our cookies by continuing to use our site, or you may view more information and choose to reject cookies by clicking here. Thank you

Contact us online or call us on 0191 377 8377

  • Name*:*
  • Organisation:
  • Telephone:
  • Email:*
  • Message*:*
  • Send me a copy of this email
  • Send me course updates from time to time via email

    Your subscription will naturally terminate after your chosen time limit. We will get in touch just before the end so that you can subscribe again if you would like to continue receiving information after that point.

* Required Fields

PDF
Course SQL Server Implementing a Data Warehouse with SQL Server 20463
  • Public Scheduled Price£1995 +VAT
  • Course Duration5 Days
  • Course Options
    Public Scheduled
    Public Scheduled
    Fixed content, fixed date, fixed location, fixed length, multiple organisations - All you need to do is choose which course you would like to attend and contact us to book!
    Private
    Private
    Flexible content, flexible date, flexible location, variable length, private to your organisation - Courses can be held at one of our training venues or at another location convenient to you. Training can be set over a number of days or weeks to allow for practice time between training sessions.
    Virtual

Overview
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.
Prerequisites
    • An awareness of key business priorities such as revenue, profitability, and financial accounting is desirable.
    • Some exposure to basic programming constructs (such as looping and branching).
    • Querying with Transact-SQL.
    • Creating tables and relationships.
    • Designing a normalized database.
    • At least 2 years’ experience of working with relational databases, including:
Objectives
    • 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
Target Audience
    • This course is intended for database professionals who need to create and support a data warehousing solution. 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
What's included
    • For courses held on our premises, complimentary tea, coffee and biscuits are available. Lunch is not provided, however, there is a wide variety of eateries within a short walk of the centre.
    • Comprehensive course materials and exercises
Course Content
    • Introduction to Data Warehousing
      Overview of Data Warehousing

      Considerations for a Data Warehouse Solution
    • Planning Data Warehouse Infrastructure
      Considerations for Data Warehouse Infrastructure

      Planning Data Warehouse Hardware
    • Designing and Implementing a Data Warehouse
      Data Warehouse Design Overview

      Designing Dimension Tables

      Designing Fact Tables

      Physical Design for a Data Warehouse
    • Creating an ETL Solution with SSIS
      Introduction to ETL with SSIS

      Exploring Data Sources

      Implementing Data Flow
    • Implementing Control Flow in an SSIS Package
      Introduction to Control Flow

      Creating Dynamic Packages

      Using Containers

      Managing Consistency
    • Debugging and Troubleshooting SSIS Packages
      Debugging an SSIS Package

      Logging SSIS Package Events

      Handle errors in an SSIS package
    • Implementing a Data Extraction Solution
      Planning Data Extraction

      Extracting Modified Data
    • Loading Data into a Data Warehouse
      Planning Data Loads

      Using SSIS for Incremental Loads

      Using Transact-SQL Loading Techniques
    • Enforcing Data Quality
      Introduction to Data Quality

      Using Data Quality Services to Cleanse Data

      Using Data Quality Services to Cleanse Data
    • Master Data Services
      Introduction to Master Data Services

      Implementing a Master Data Services Model

      Managing Master Data

      Creating a Master Data Hub
    • Extending SQL Server Integration Services
      Using Scripts in SSIS

      Using Custom Components in SSIS
    • Deploying and Configuring SSIS Packages
      Overview of SSIS Deployment

      Deploying SSIS Projects

      Planning SSIS Package Execution
    • Consuming Data in a Data Warehouse
      Introduction to Business Intelligence

      Enterprise Business Intelligence

      Self-Service BI and Big Data

 

Course Dates

IT Training Solutions Ltd
Oakville, 14 Durham Road West, Bowburn, Durham, DH6 5AU
0191 377 8377
ittrainingsolutions.co.uk

Printed: 23 Aug 19

 

 

 

Contact us

  • Name*:*
  • Organisation:
  • Telephone:
  • Email:*
  • Message*:*
  • Send me a copy of this email
  • Send me course updates from time to time via email

    Your subscription will naturally terminate after your chosen time limit. We will get in touch just before the end so that you can subscribe again if you would like to continue receiving information after that point.

* Required Fields