Implementing a SQL Data Warehouse (20767)

Category ID Duration Level Price
SQL Server M20767 5 Day(s) Intermediate $2,895.00

Implementing a SQL Data Warehouse (20767)

Seattle, WA Class Schedule

GTR

Guaranteed to Run

Delivery Format Date Time Register
Classroom Virtual 10/26/2020 - 10/30/2020 10:00 AM - 5:00 PM EDT Register
Classroom Virtual 10/26/2020 - 10/30/2020 10:00 AM - 5:00 PM EDT Register
Classroom Virtual 10/26/2020 - 10/30/2020 10:00 AM - 5:00 PM EDT Register

Seattle Training Center

Address


1001 4th Avenue


Suite 3200


Seattle, WA 98154

Call Us

US Toll Free 844-238-8607

Email Us


info@productivitypointls.com

Course Overview

This 4-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.

Course Objectives

Lesson objectives help students become comfortable with the course, and also provide a means to evaluate learning. Upon successful completion of this course, 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

Productivity Point Learning Solutions evolved out of a desire to increase our outreach both nationally and internationally.

Productivity Point Headquarters
1580 Sawgrass Corporate Parkway
Suite 205
Sunrise, Florida 33323
United States

Contact
T 1-844-238-8607
P 1-954-425-6141
F 1-954-928-9057
E info@productivitypointls.com

© Copyright 2020 Productivity Point Learning Solutions. All Rights Reserved.