Course 20767A: Implementing a SQL Data Warehouse

Prihajajoče izvedbe

Nivo:For IT professionals
Prodajalec:Microsoft
Kategorija prodajalca:SQL Server
Teme:Database, Server
Trajanje (dni):5
Ur/dan:8
Tip učenja:Preko spleta
Cena:1.190€ + DDV

This 5-day instructor led course describes how to implement a data warehouse platform to support a BI solution. 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.

  • 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
  • At least 2 years’ experience of working with relational databases, including:
  • Designing a normalized database.
  • Creating tables and relationships.
  • Querying with Transact-SQL.
  • Some exposure to basic programming constructs (such as looping and branching).
  • An awareness of key business priorities such as revenue, profitability, and financial accounting is desirable.
  • Exam code: 70-767
  • 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.

Gregor Papež, MCT

Online Termin ni potrjen

17. januar 2022 - 21. januar 2022

  • Cena: 1.190€ + DDV
Pokaži urnik
  • 17.01.2022, 08:00-16:00
    Online classroom
  • 18.01.2022, 08:00-16:00
    Online classroom
  • 19.01.2022, 08:00-16:00
    Online classroom
  • 20.01.2022, 08:00-16:00
    Online classroom
  • 21.01.2022, 08:00-16:00
    Online classroom

Za več informacij nas kontaktirajte na telefonsko številko: 01 568 40 40 ali trzenje@housing.si.