20767: Implementing a SQL Data Warehouse (MOC20767)

Placeholder

20767: Implementing a SQL Data Warehouse (MOC20767)

 2.395,00

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.

Doel

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.

    Voorkennis

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

    Vorm

    Classical and Tailor iT made training

    Inhoud

    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

    Vervolgopleidingen

    Bijzonderheden

    5 days

    € 2.395

    Cursusdata

    11, 12, 13, 14 en 15 september 2017

    23, 24, 25, 26 en 27 oktober 2017

    20, 21, 22, 23 en 24 november 2017

    Andere data?

    Locaties

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

    Andere locatie?

    SKU: MOC20767 Categorieën: , , Tag:
    Meer weten over een training of advies? Bel met onze opleidingsadviseurs 085 02 01 070 of gebruik het contactformulier.