search
    

    Home Microsoft 20767B: Implementing a SQL Data Warehouse

    QUICK

    INFORMATION

    icon

    5 Day(s) Course

    icon

    Official Courseware

    icon

    Exam Voucher

    icon

    Certified Trainer

    icon

    1:1 Training Available on Demand

    icon

    Customize Your Batch

    ABOUT

    THE COURSE

    The  five-days Microsoft 20767B Implementing a SQL Data Warehouse Certification Course is part 1 of the series of two courses of MCSA 2016: SQL Business Intelligence Development, that validates your skills to create and deploy a data warehouse with Microsoft SQL Server 2016 and Azure SQL Data Warehouse for efficiently implementing the ETL as well as SQL Services.

    This course is intended for database professionals who support Business Intelligence solutions, engaged in implanting, validating and cleansing data warehouses.

    This course qualifies you for the exam 70-767: Implementing a SQL Data Warehouse Certification.



    Module 1: Introduction to Data Warehousing

    This module introduces the data warehouse concepts and architecture considerations.

    Lessons

    • Data Warehousing Overview
    • Considerations for a Data Warehouse Solution

    Module 2: Planning Data Warehouse Infrastructure

    This module introduces the main hardware considerations for building a data warehouse.

    Lessons

    • Data Warehouse Reference Architectures and Appliances
    • Data Warehouse Building Considerations

    Module 3: Designing and Implementing a Data Warehouse

    This module explains how you go about designing and implementing a schema for a data warehouse.

    Lessons

    • Physical Design for a Data Warehouse
    • Logical Design for a Data Warehouse

    Module 4: Column store Indexes

    This module explains the Columnstore Indexes.

    Lessons

    • Introduction to Columnstore Indexes
    • Creating Columnstore Indexes
    • Working with Columnstore Indexes

    Module 5: Implementing an Azure SQL Data Warehouse

    This module introduces Azure SQL Data Warehouses and how to implement them.

    Lessons

    • Advantages of Azure SQL Data Warehouse
    • Developing an Azure SQL Data Warehouse
    • Migrating to an Azure SQ Data Warehouse
    • Implementing an Azure SQL Data Warehouse

    Module 6: Creating an ETL Solution

    This module will enable you to implement data flow in an SSIS package.

    Lessons

    • ETL with SSIS Introduction
    • Exploring Source Data
    • Implementing Data Flow

    Module 7: Implementing Control Flow in an SSIS Package

    This module discusses the implementation of control flow in an SSIS package.

    Lessons

    • Control Flow Introduction
    • Creating Dynamic Packages
    • Using Containers

    Module 8: Debugging and Troubleshooting SSIS Packages

    This module explains how to debug and troubleshoot SSIS packages.

    Lessons

    • Logging SSIS Package Events
    • Debugging an SSIS Package
    • Handling Errors in an SSIS Package

    Module 9: Implementing an Incremental ETL Process

    This module explains how to implement an SSIS solution that supports incremental DW loads and changing data.

    Lessons

    • Introduction to Incremental ETL
    • Extracting Modified Data
    • Temporal Tables

    Module 10: Enforcing Data Quality

    This module explains how to implement data cleansing by using Microsoft Data Quality services.

    Lessons

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

    Module 11: Using Master Data Services

    This module explains how to implement master data services to enforce data integrity at source.

    Lessons

    • Creating a Master Data Hub
    • Master Data Services Concepts
    • Managing Master Data
    • Implementing a Master Data Services Model

    Module 12: Extending SQL Server Integration Services (SSIS)

    This module explains how to extend SSIS with custom scripts and components.

    Lessons

    • Using Custom Components in SSIS
    • Using Scripting in SSIS

    Module 13: Deploying and Configuring SSIS Packages

    This module explains how to deploy and configure SSIS packages.

    Lessons

    • Overview of SSIS Deployment
    • Planning SSIS Package Execution
    • Deploying SSIS Projects

    Module 14: Consuming Data in a Data Warehouse

    This module explains how to debug and troubleshoot SSIS packages.

    Lessons

    • Introduction to Business Intelligence
    • Introduction to Reporting
    • An Introduction to Data Analysis
    • Analyzing Data with Azure SQL Data Warehouse

    SQL Server Data Warehouse training course is intended for database professionals who need to accomplish a Business Intelligence Developer role. They will be required to exhibit hands-on work creating BI solutions.

    Primary responsibilities will include:

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

    The course requires professionals and learners to meet the following prerequisites:

    At least 2 years’ experience of relevant experience with relational databases, including:
    • Designing a normalized database.
    • Querying with Transact-SQL.
    • Creating tables and relationships.
    • Some exposure to basic programming constructs (such as looping and branching).

    Name Code Fee
    Implementing a SQL Data Warehouse Certification 70-767 USD 108

    gorm icon

    ENQUIRY FORM

    What Our Trainees Say

    Mercury Solutions Ltd. is rated 4.5 stars by www.facebook.com/mercurysol based on 17 reviews.