Azure SQL Data Warehouse Performance Tuning and Optimization

Overview

SQL Data Warehouse is a cloud-based Enterprise Data Warehouse (EDW) that utilizations Massively Parallel Processing (MPP) to immediately run complex questions crosswise over petabytes of information. Use SQL Data Warehouse as a key part of a major information arrangement. Import enormous information into SQL Data Warehouse with straightforward PolyBase T-SQL questions, and afterward utilize the intensity of MPP to run elite investigation. As you coordinate and break down, the information distribution center will turn into the single variant of truth your business can depend on for bits of knowledge.

Audience :

  • IT experts who are keen on getting an Azure accreditation
  • Those hoping to execute information streams inside their associations

 

Download Course Contents
Schedule & Prices
Course Details Schedule
Classroom Training*
Duration : 2 Days
Fee : Dubai : USD 2,000 Sydney : USD 1,800 London : USD 1,700 India : USD 1,500
March
02-03 (Delhi)
02-03 (london)
08-09 (Dubai)
09-10 (Bangalore)
09-10 (london)
16-17 (Chennai)
April
13-14 (Bangalore)
20-21 (Chennai)
May
18-19 (Chennai)
July
06-07 (Delhi)
06-07 (london)
12-13 (dubai)
13-14 (Bangalore)
13-14 (london)
20-21 (Chennai)
December
07-08 (Delhi)
07-08 (london)
13-14 (Dubai)
14-15 (Bangalore)
14-15 (london)
21-22 (Chennai)
Instructor-Led Online Training
Duration : 2 Days
Fee : USD 1,500 (1-on-1)†
March
02-03
08-09
09-10
16-17
April
13-14
20-21
May
18-19
July
06-07
12-13
13-14
20-21
December
07-08
13-14
14-15
21-22
Fly-Me-a-Trainer
Duration : 2 Days
Fee : On Request 		Client's Location
As per mutual convenience

Enquire Now




Input symbols

Course Prerequisites

Course Pre-requisites:

  • A fundamental comprehension of information streams and their employments

 



After completion this course, you will learn following topics:

  • Describe the key components of an information warehousing arrangement
  • Describe the fundamental equipment contemplations for building an information stockroom
  • Implement a coherent structure for an information distribution center
  • Implement a physical structure for an information stockroom
  • Create columnstore records
  • Implementing an Azure SQL Data Warehouse
  • Describe the key highlights of SSIS
  • Implement an information stream by utilizing SSIS
  • Implement control stream by utilizing errands and priority imperatives
  • Create dynamic bundles that incorporate factors and parameters
  • Debug SSIS bundles
  • Describe the contemplations for actualize an ETL arrangement
  • Implement Data Quality Services
  • Implement a Master Data Services model
  • Describe how you can utilize custom parts to expand SSIS
  • Deploy SSIS ventures
  • Describe BI and normal BI situations

 

)