Course Status
Availability
Course Duration
Timing
Course ID
Exam Number
Registration Open
Weekdays – Weekends
7 Days, 49 Hours
9:00 AM – 04:00 PM
20767
70-767

Implementing a SQL Data Warehouse

Course Overview

This course imparts core skills on the implementation of data warehouse platform for supporting a BI solution. The course covers the Implementation of ETL using Integration Services, validation, and cleansing of data using Data Quality Services and Master Data Services. Implementing SQL Data Warehouse course is ideal for database professionals, BI developers, and professionals who are responsible for creating BI solutions in an enterprise environment.

Course Objectives

After completing this course, students will be able to:

  • Describe the key elements of a data warehousing solution
  • Create column store 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
  • Deploy SSIS projects
  • Describe BI and common BI scenarios

Prerequisites

  • Designing a normalized database.
  • Creating tables and relationships.
  • Querying with Transact-SQL.
  • Experience in basic programming constructs (such as looping and branching).

You have made the
best choice!

Book Your Seat Today

  • Course Status: Registration Open
  • Availability: Weekdays - Weekends
  • Duration: 6 Days, 42 Hours
  • Course Status: Registration Open
  • Availability: Weekdays - Weekends
  • Duration: 6 Days, 42 Hours
  • Course Status: Registration Open
  • Availability: Weekdays - Weekends
  • Duration: 5 Days - 35 Hours
  • Course Status: Registration Open
  • Availability: Weekdays - Weekends
  • Duration: 7 Days, 49 Hours

More Courses in this category

  • Course Status: Registration Open
  • Availability: Weekdays - Weekends
  • Duration: 6 Days, 42 Hours
  • Course Status: Registration Open
  • Availability: Weekdays - Weekends
  • Duration: 6 Days, 42 Hours
  • Course Status: Registration Open
  • Availability: Weekdays - Weekends
  • Duration: 5 Days - 35 Hours
  • Course Status: Registration Open
  • Availability: Weekdays - Weekends
  • Duration: 7 Days, 49 Hours

Request Information

Request Information