,

MS 20767 – Implementing a SQL Data Warehouse

This property is marketed by

InnoventSys

Member Since: 3 months
94777849438
WhatsApp
https://degree.lk/wp-content/themes/propertya-child/libs/images/type.png

Offer Type

best-certificate-courses

https://degree.lk/wp-content/themes/propertya-child/libs/images/medium.png

Medium

NG

https://degree.lk/wp-content/themes/propertya-child/libs/images/method.png

Method

NG

https://degree.lk/wp-content/themes/propertya-child/libs/images/duration.png

Duration

05 Days

https://degree.lk/wp-content/themes/propertya-child/libs/images/location.png

Location

Colombo

https://degree.lk/wp-content/themes/propertya-child/libs/images/time.png

Commencement

Soon

Description

The primary audience for this course is database professionals who need to fulfil a Business Intelligence Developer role. They will need to focus on hands-on work creating BI solutions including Data Warehouse implementation, ETL, and data cleansing.

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

After completing 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
 
 

 

Details

Last Updated On: February 9th, 2024 at 2:38 pm
Method:NG
medium:NG
commencement:Soon
duration:05 Days
Location:Colombo

Features

  • Alumni Association
  • Book Shop
  • Cafeteria
  • Clubs and Societies
  • Labs
  • Library
  • LMS
  • Medical Facilities
  • Parking
  • Recreation Area
  • Relaxation Area
  • Student Center
  • Study Area
  • Transport
  • Wi-Fi

Statistics

Schedule a Call

Similar Programs

AWS Certified Solutions Architect – Associate

InnoventSys (Pvt) Ltd, Park Street, Colombo, Sri Lanka

Beds NG
Baths NG
Size 0 NG

AWS Certified Developer – Associate

InnoventSys (Pvt) Ltd, Park Street, Colombo, Sri Lanka

Beds NG
Baths NG
Size 0 NG

CSPO – Certified Scrum Product Owner

InnoventSys (Pvt) Ltd, Park Street, Colombo, Sri Lanka

Beds NG
Baths NG
Size 2 Days

CSM – Certified Scrum Master

InnoventSys (Pvt) Ltd, Park Street, Colombo, Sri Lanka

Beds NG
Baths NG
Size 0 NG

POPM – SAFe 5.0 Product Owner / Product Manager

InnoventSys (Pvt) Ltd, Park Street, Colombo, Sri Lanka

Beds NG
Baths NG
Size 2 Days

SSM – SAFe 5.0 Scrum Master

InnoventSys (Pvt) Ltd, Park Street, Colombo, Sri Lanka

Beds NG
Baths NG
Size 2 Days

Write a Review

You should logged in first to add a review.

Compare programs
Add programs to compare.