Take advantage of spring savings with up to 50% off ILT training.

MyGK
Support
USA USA - English
0
Checkout

Cart (0)

Contact Sales
Course  
Contact Sales
Support
0
Checkout

Cart (0)

Request Group Training

Implementing a SQL Data Warehouse

Learn to implement a data warehouse platform with Microsoft SQL Server 2016.

This course provides students with the knowledge and skills to provision a Microsoft SQL Server database. The course covers SQL Server provision both on-premise and in Azure, and covers installing from new and migrating from an existing install.

Scheduling a custom training event for your team is fast and easy! Click here to get started.

Is This The Right Course?

  • Basic knowledge of the Microsoft Windows operating system and its core functionality.
  • Working knowledge of relational databases.
  • Some experience with database design

Who Should Attend?

  • Database professionals who need to fulfill a BI developer role focused on hands-on work by creating BI solutions, including data warehouse implementation, ETL and data cleansing
  • Database professionals responsible for implementing a data warehouse, developing SSIS packages for data ETL, enforcing data integrity using Microsoft Data Services and cleansing data using Data Quality Services

What You'll Learn
  • Describe the key elements of a data warehouse solution
  • Considerations for building a data warehouse
  • Implementing 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 of implement an ETL Solution
  • Implement Data Quality Services
  • Implement a Master Data Service model
  • Describe how you can use custom components to extend SSIS
  • Deploy SSI projects
  • Describe BI and common BI scenarios

Prerequisites
  • Basic knowledge of the Microsoft Windows operating system and its core functionality.
  • Working knowledge of relational databases.
  • Some experience with database design
GK# 821527 Vendor# Impl SQL Data Wrhs