18756 Stone Oak Park Way, Suite200, San Antonio TX 78258 USA
100 Queen St W, Brampton, ON L6X 1A4, Canada
country flagUnited States
share button

20767: Implementing SQL Data Warehouse Training


SQL Server



Course Description

20767: Implementing SQL Data Warehouse Training teaches professionals the leading methodologies to build a data warehouse with the help of MS SQL Server and Azure SQL Data Warehouse. This technical course demonstrates how to apply a data warehouse platform to support a BI solution. It provides comprehensive knowledge of the main hardware considerations for developing a data warehouse. Throughout this course, trainees will learn to implement a logical design and a physical design for a data warehouse. It also elaborates on the critical features of SSIS and teaches how to create dynamic packages, including parameters and variables. This training program is ideal for a data professional who works as a Business Intelligence Developer. This program covers all the essential topics from implementing control flow and debugging SSIS packages to applying to a master data services school.

This training is designed based on the objectives of the course variant 20767C.

  • Describing data warehousing solution’s key elements.
  • Describe the major hardware considerations to build the data warehouse
  • Implementing a logical and physical design for the data warehouses
  • Creating column store indexes
  • Implement the Azure SQL Data Warehouse
  • Describing SSIS’s key features
  • Using SSIS for implementing data flow
  • Using precedence constraints and tasks for implementing control flow
  • Create variables and parameters consisting of dynamic packages
  • Debugging SSIS packages
  • Describing the considerations for implementing ETL solution
  • Implementing Data Quality Services
  • Implementing the Master Data Services model
  • Describe using of custom components for extending SSIS
  • Deploying SSIS projects
  • Describing Business Intelligence and common Business Intelligence scenarios
Who Should Attend?

The database professionals looking to upgrade to a BI developer role are the primary audience for the course. This course will teach them hands-on work to create Business Intelligence solutions that include implementing Data Warehouse, data cleansing and ETL.

  • Knowledge of Microsoft Windows operating system; and, its core functionality
  • Knowledge of relational databases
  • Experience in database designing
Course Details
  • Start Date: May 03, 2021
  • Duration: 5 Days
  • Skill Level: Intermediate
  • More Schedules: Click
  • Certification: NO
  • Enrolled: 1547
Get In Touch
Are you being sponsored by your employer to take this class?
* I authorize Microtek Learning to contact me via Phone/Email