Microsoft/Azure SQL Data Warehouse Performance Tuning and Optimization

Download Course Contents

Azure SQL Data Warehouse Performance Tuning and Optimization Course 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 Certification
  • Those hoping to execute information streams inside their associations

 

This is a Rare Course and it can be take up to 3 weeks to arrange the training.

  • 1. Do you have limited Window for training?
  • 2. Can you only spend 4-hours per day?
  • 3. Do you want to start training immediately?
  • If your answer is yes to any one of the above, you need 1-on-1- Training
The 1-on-1 Advantage
Methodology
Flexible Dates
4-Hour Sessions
  • View video
  • The course will be free if we are not able to start within 7 days of booking.
  • Only applicable for courses on which this logo appears.

Your will learn:

Module 1: Data Gathering
  • Details are not available.
  • Overview: In this module you will review MPP essential concepts how to create a data warehouse and how to connect to a data warehouse
  • Database Scaling: In this module you will learn the concepts behind how database scaling works how to scale and how resource classes are affected by scaling
  • Table Design: In this module you will learn about table creation the difference between rowstore and columnstore tables table geometry how to choose a distribution column and best practices for table design.
  • Statistics: In this module you will learn how statistics objects work as well as how to create and manage statistics
  • Data Movement: In this module you will learn the concepts behind data movement how joins and aggregations work how to read MPP plans and how to tune DMS for best performance.
  • Partitioning: In this module you will learn the fundamentals of partitioning in an MPP system how to manage partitions and how to manage sizes and loading with partitions.
  • Performance: In this module you will learn how to tune for best performance using: statistics clustered columnstore indexes locking table design and avoiding resource contention
  • Details are not available.
Live Online Training (Duration : 16 Hours) Fee On Request
Group Training Date On Request
1-on-1 Training
4 Hours
8 Hours
Week Days
Weekend

Start Time : At any time

12 AM
12 PM

1-On-1 Training is Guaranteed to Run (GTR)
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request
Classroom Training is available. Enquire for the fee Click
Comfort Track

If you think 32 hours is too long. We can offer Comfort Track for 16 hours

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

 

Request More Information

Add Name and Email Address of participant (If different from you)

FAQ's


Yes, fee excludes local taxes.
The Fee includes:
  • Courseware
Yes, Koenig Solutions is a Microsoft Learning Partner