20767: Implementing a SQL Data Warehouse (MOC20767)

Logo TailorIT RGB

20767: Implementing a SQL Data Warehouse (MOC20767)


20767: Implementing a SQL Data Warehouse (MOC20767)

This five day course defines how to implement a data warehouse platform to support a BI solution. During this course the students will learn how to create a data warehouse with Microsoft SQL Server 2016 and with Azure SQL Data Warehouse, to implement ETL with SQL Server Integration Services, and to validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services.


After following this course, the students will be able to:

  • Describe the key elements of a data warehousing solution
  • Describe the main hardware considerations for building a data warehouse
  • Implement a logical design for a data warehouse
  • Implement a physical design for a data warehouse
  • Create columnstore indexes
  • Implementing an Azure SQL Data Warehouse
  • Describe the key features of SSIS
  • Implement a data flow by using SSIS
  • Implement control flow by using tasks and precedence constraints
  • Create dynamic packages that include variables and parameters
  • Debug SSIS packages
  • Describe the considerations for implement an ETL solution
  • Implement Data Quality Services
  • Implement a Master Data Services model
  • Describe how you can use custom components to extend SSIS
  • Deploy SSIS Projects
  • Describe BI and common BI scenarios
  • Doelgroep

    The audience for this course are database professionals who need to fulfil a Business Intelligence Developer role. They will need to focus on hands-on work creating BI solutions including Data Warehouse implementation, ETL, and data cleansing.


    To participate in this course, the students need at least 2 years' experience of working with relational databases.


    Classical and Tailor iT made training


    During this course the following topics will be covered:

    Module 1: Introduction to Data Warehousing

    Module 2: Planning Data Warehouse Infrastructure

    Module 3: Designing and Implementing a Data Warehouse

    Module 4: Columnstore Indexes

    Module 5: Implementing an Azure SQL Data Warehouse

    Module 6: Creating an ETL Solution

    Module 7: Implementing Control Flow in an SSIS Package

    Module 8: Debugging and Troubleshooting SSIS Packages

    Module 9: Implementing an Incremental ETL Process

    Module 10: Enforcing Data Quality

    Module 11: Using Master Data Services

    Module 12: Extending SQL Server Integration Services (SSIS)

    Module 13: Deploying and Configuring SSIS Packages

    Module 14: Consuming Data in a Data Warehouse



    5 days

    € 2.395


    27, 28, 29, 30 en 31 januari 2020

    24, 25, 26, 27 en 28 februari 2020

    30 en 31 maart & 1, 2 en 3 april 2020

    20, 21, 22, 23 en 24 april 2020

    15, 16, 17, 18 en 19 juni 2020

    18, 19, 20, 21 en 22 november 2019

    Andere data?


    Breda, Tilburg, Amsterdam, Rotterdam, Utrecht, Eindhoven, Antwerpen, Zwolle

    Andere locatie?

    Meer weten over een training of advies? Bel met onze opleidingsadviseurs 085 02 01 070 of gebruik het contactformulier.