20767 : Implementing a SQL 2016 Data Warehouse (SSIS)

  • Overview

    Implementing SQL Data Warehouse (SSIS) training course imparts core skills on implementation of data warehouse platform for supporting a BI solution. Participants enrolled for this SQL Data Warehouse certification will learn to create data warehouse with SQL Server 2016 and Azure SQL Data Warehouse. The course also covers Implementation of ETL using Integration Services, validation and cleansing of data using Data Quality Services and Master Data Services.

    Implementing SQL Data Warehouse course is ideal for database professionals, BI developers, and professionals who are responsible for creating BI solutions in an enterprise environment.

    Course Objectives

    • Understand the components of a data warehousing solution
    • Implement a logical and physical design to create a data warehouse
    • Implement a physical design for a data warehouse
    • Understand SSIS for implementing data flows
    • Create dynamic packages using parameters and variables
    • Implement Data Quality Services and Master Data Services
    • Implement custom components for extending SSIS
    • Implement Business Intelligence and its common scenarios in this SQL Data Warehouse certification training

    Course Content / Exam(s)

    Schedule for 20767 : Implementing a SQL 2016 Data Warehouse (SSIS)
    Course # Course Contents Regular Track
    (days)
    Fast Track
    (days)
    20767 Implementing a SQL 2016 Data Warehouse (SSIS) 5 4
    Total 5 4
    Prerequisites
    • Designing a normalized database.
    • Creating tables and relationships.
    • Querying with Transact-SQL.
    • Some exposure to basic programming constructs (such as looping and branching).
    Recommended Courses and Certification:
  • Students Reviews
    Jose Biniecki Mariusz Koenig IT Training Student

    During my stay, I did 2 fast track courses, MCSA: Windows Server 2012 R2 and MCSA SQL Server 2012 at Koenig Goa, India. I spent my time pretty nicely. I achieved MCSA certificates and met with new...

    Read MoreJose Biniecki MariuszPoland
    Mohammad Hassan Mahamud Koenig IT Training Student

    The SQL Server Performance Tuning and Optimization training I received at Koenig Delhi was very informative and practical. The course was quite relevant to my job and will help me in most aspects of...

    Read MoreMohammad Hassan MahamudBangladesh
    Clotilde Mundlovo  Soiane Koenig IT Training Student

    It was a great pleasure to have attended MCSA SQL Server 2012 course in Koenig Dubai. The training exceeded my expectations, taking into account the environment and ambience which were quite...

    Read MoreClotilde Mundlovo SoianeUnited Arab Emirates
    Daniel  Thompson Koenig IT Training Student

    This was my second trip to train with Koenig in India. My first time was in Dehradun, northern India and the experience is a life changing one. This time I decided to choose Goa and one of the forces...

    Read MoreDaniel ThompsonUnited Kingdom
    Bert  Ham Koenig IT Training Student

    I would like to thank you and your team for a very good course, I am very pleased with the results (MCSA 2012 graduation) and the acquired knowledge. The MCSA training was very good and the trainer...

    Read MoreBert HamNetherlands
    View All Testimonials
  • Schedule & Prices
    1
    5
    5
    Classes will be conducted from 09:00 am - 05:00 pm at Your Local Time
    Price includes Official Curriculum.
    For any Query or Custom Plan info@koenig-solutions.com +1 877 226 2244
  • Enquire Now
    * Required Fields