Azure SQL Data Warehouse Performance Tuning and Optimization Course

24 hours all-inclusive training program

3 specific modules include data gathering and knowledge transfer

Understand data warehouse performance metrics

Spread payments with instalment options

Blended online & classroom learning modes

4.75/5

6572 Enrolled

course-img

Overview

What we will guide you through

  • Learn query optimization strategies and techniques
  • Master indexing methods for enhanced performance
  • Manage and monitor workload distribution
  • Implement partitioning for large datasets
  • Utilise PolyBase for data integration
  • Analyse execution plans and query tuning
  • Includes advanced performance tuning case studies

Learning Objectives

On completing the course, you will master these skills

  • 1

    Understand the fundamentals of Azure SQL Data Warehouse (SQL DW)

  • 2

    Learn about the various performance diagnosis techniques to measure and optimise the performance of SQL DW

  • 3

    Explore techniques for gathering detailed information about the workload on SQL DW, including schema analysis and resource monitoring

  • 4

    Be able to design and optimise effective data models for SQL DW

  • 5

    Comprehend how to use the proper indexes and statistics to optimise SQL DW queries

  • objective-image

    Ready to get started?

  • Enquire Now Call Now