
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

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