$1,500.00 Software Assurance Training Vouchers Accepted


    Location Start date End Date Class Times Class Details Action
    No class dates currently scheduled. Click here to request a date


    Exams Included:

    • 70-767: Implementing a Data Warehouse using SQL

    TechSherpas ’ boot camps are geared towards providing students with the necessary skills and knowledge to not only pass the Microsoft Certification exams, but to also excel in their IT career paths. All of our boot camps are all-inclusive and include benefits such as:

    • 100% Test Pass Guarantee
    • All course materials, practice exams and official certification exams
    • Onsite Prometric Testing Center
    • Hands-on instruction by a certified instructor
    • Breakfast and Lunch provided each day
    • Airfare, lodging and transportation packages available (Option 2)


    Audience Profile

    This exam is intended for extract, transform, and load (ETL) and data warehouse developers who create business intelligence (BI) solutions. Their responsibilities include data cleansing, in addition to ETL and data warehouse implementation.


    At Course Completion

    After completing this course, students will be able to:

    • Provision a Database Server
    • Upgrade SQL Server
    • Configure SQL Server

    Manage Databases and Files (shared


    Course Description

    This accelerated boot camp will prepare students to pass the 70-767 exam, and provide students with the knowledge and skills to provision a Microsoft SQL Server 2016 database. Students will learn SQL Server 2016 provision both on-premise and in Azure, and covers installing from new and migrating from an existing install..

    Design, implement, and maintain a data warehouse

    • Design and implement dimension tables
    • Design and implement fact tables
    • Design and implement indexes for a data warehouse workload
    • Design storage for a data warehouse
    • Design and implement partitioned tables and views


    Extract, transform, and load data

    • Design and implement an extract, transform, and load (ETL) control flow by using a SQL Server Integration Services (SSIS) package
    • Design and implement an ETL data flow by using an SSIS package
    • Implement an ETL solution that supports incremental data extraction
    • Implement an ETL solution that supports incremental data loading
    • Debug SSIS packages


    Deploy and configure SSIS packages and projects

    • Build data quality solutions
    • Create a knowledge base
    • Maintain data quality by using DQS
    • Implement a Master Data Services (MDS) model
    • Manage data by using MDS