Trusted Training Partners

    Home / Uncategorized / Implementing a Data Warehouse with MS SQL Server 2014 Training Course Course
Quick Look Course Summary:Implementing a Data Warehouse with MS SQL Server 2014 Training Course Course
  • Next Public Course Date:

  • Length: 3 day(s)

  • Price (at your venue): 1 Person R 15,365.00 EX VAT 3 Person R 9,344.72 EX VAT 10 Person R 6,014.09 EX VAT

  • Certification Type:Accredited

  • Locations & Venues: Off-site or in-house. We train in all major city centres throughout South Africa.

Get Free & personalised
Training Advice

    Knowing your course will help us prepare for our consultation and phone call.

    The more people you send on our courses, the cheaper the unit cost.

    YesNo

    Input this code: captcha

    Implementing a Data Warehouse with MS SQL Server 2014 Training Course Course: Introduction

    Our course 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. The course also describes the key considerations for the logical design of a data warehouse, and then discusses best practices for its physical implementation. Amongst other topics, debugging, ETL solutions and implementing control flow will also be discussed.

    Implementing a Data Warehouse with MS SQL Server 2014 Training Course Course :Course Outline

    1. Introduction to Data Warehousing
    Overview of Data Warehousing
    Considerations for a Data Warehouse Solution
    Exploring a Data Warehousing Solution
    Exploring Data Sources
    Exploring and ETL Process
    Exploring a Data Warehouse

    2. Planning Data Warehouse Infrastructure
    Considerations for Data Warehouse Infrastructure
    Planning Data Warehouse Hardware

    3. Designing and Implementing a Data Warehouse
    Data Warehouse Design Overview
    Designing Dimension Tables
    Designing Fact Tables
    Physical Design for a Data Warehouse
    Implementing a Data Warehouse
    Implement a Star Schema
    Implement a Snowflake Schema
    Implement a Time Dimension

    4. Creating an ETL Solution with SSIS
    Introduction to ETL with SSIS
    Exploring Data Sources
    Implementing Data Flow
    Implementing Data Flow in an SSIS Package
    Transferring Data by Using a Data Flow Task
    Using Transformations in a Data Flow

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

    6. Debugging and Troubleshooting SSIS Packages
    Debugging an SSIS Package
    Logging SSIS Package Events
    Handling Errors in an SSIS Package
    Logging SSIS Package Execution
    Implementing an Event Handler
    Handling Errors in a Data Flow

    7. Implementing a Data Extraction Solution
    Planning Data Extraction
    Extracting Modified Data
    Extracting Modified Data
    Using a Date time Column
    Using Change Data Capture
    Using the CDC Control Task
    Using Change Tracking

    8. Loading Data into a Data Warehouse
    Planning Data Loads
    Using SSIS for Incremental Loads
    Using Transact-SQL Loading Techniques
    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

    9. Enforcing Data Quality
    Introduction to Data Quality
    Using Data Quality Services to Cleanse Data
    Cleansing Data
    Creating a DQS Knowledge Base
    Using a DQS Project to Cleanse Data
    Using DQS in an SSIS Package

    10. Master Data Services
    Introduction to Master Data Services
    Implementing a Master Data Services Model
    Managing Master Data
    Creating a Master Data Hub
    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

    11. Extending SQL Server Integration Services
    Using Scripts in SSIS
    Using Custom Components in SSIS
    Using Custom Scripts
    Using a Script Task

    Implementing a Data Warehouse with MS SQL Server 2014 Training Course Course: Course Duration

    3 day/s

    Who should attend: Implementing a Data Warehouse with MS SQL Server 2014 Training Course Course

    This course is intended for programmers, SQL Server.

    **Quote does not include Any Exam Fees (if applicable)

    IMPORTANT ACTION: Do Not Wait To Improve Your Skills.  

    Book Now By Completing Online Booking Form / Customised Proposal or Obtain Approval For Your Already Received Customised Proposal

    Realize incredible savings by sending more delegates

    Do you want to save costs by doing training at your premises?

    Save costs by providing own laptop

    Region *

    Accredited Courses

    Additional Courses

    Software & IT Courses

    Top Rated