SQL Server: Data Warehousing Masterclass

£495 + VAT

Do you get involved in the creation of data warehousing within your organisation? The solution provided by a Data Warehouse must be agile and supportable once in production to ensure it provides the business with the required information.

Whether you are new to data warehousing, and or SQL Server, or if you are an experienced SQL Server Business Intelligence developer, this workshop will provide you with the knowledge to build a Data Warehouse effectively within a business.

Join us for a demo-packed workshop to learn about the world of data quality using Master Data Services, Data Quality Service, Data Warehouse design patterns, and ETL capabilities of Integration Services. During the workshop you will build a Data Warehouse to reinforce your learning.

Course Outline

At the end of the two days you will have built a Data Warehouse, created a SSIS package to manage the load of data into a Data Warehouse. You will also address data quality issues using DQS and MDS. This workshop includes teaching on the following topics:

  • Master Data Services
  • Data Quality Services
  • Data Warehouse design patterns
  • Developing data warehouses
  • Using SQL Server Integration Services
  • Integrating SSIS, DQS and MDS