Microsoft/Azure SQL Data Warehouse Performance Tuning and Optimization

Azure SQL Data Warehouse Performance Tuning and Optimization Certification Training 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

 

Azure SQL Data Warehouse Performance Tuning and Optimization (16 Hours) Download Course Contents

Live Virtual Classroom Fee For Both Group Training & 1-on-1 Training On Request
Group Training Date On Request
1-on-1 Training (GTR)
4 Hours
8 Hours
Week Days
Week End

Start Time : At any time

12 AM
12 PM

GTR=Guaranteed to Run
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request
Special Solutions for Corporate Clients! Click here Hire Our Trainers! Click here

Course Modules

Module 1: Data Gathering
  • Topic details are not available.
Module 2: Knowledge Transfer
  • 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
Module 3: Hands-On Troubleshooting:
  • Topic details are not available.
Download Course Contents

Request More Information

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