Optimize data warehouse query performance in Azure Synapse Analytics
|
Learn the techniques that you can use to optimize query performance within Azure Synapse Analytics.
Understand performance issues related to tables, Understand table distribution design, Use indexes to improve query performance, Create statistics to improve query performance, Improve query performance with Materialized Views, Use read committed snapshot for data consistency, Optimize common queries with result-set caching
Prerequisites
Before taking this module, it is recommended that you complete Data Fundamentals.
User Reviews
Be the first to review “Optimize data warehouse query performance in Azure Synapse Analytics”
Related Products
Transform data with Spark in Azure Synapse Analytics
Data engineers commonly need to transform large volumes of data. Apache Spark pools in Azure Synapse Analytics provide a distributed processing platform that they can use to accomplish this goal.
Designing Data Systems
Master the principles of designing data systems that handle large-scale data efficiently.
Explore fundamentals of large-scale analytics
Organizations use analytics platforms to build large scale data analytics solutions that generate insights and drive success. Microsoft provides multiple technologies that you can combine to build a large scale data analytics solution.
Use Apache Spark in Azure Databricks
Azure Databricks is built on Apache Spark and enables data engineers and analysts to run Spark jobs to transform, analyze and visualize data at scale.
Data Ingestion with Kafka and Kafka Streaming
Learn how to build real-time data ingestion pipelines using Apache Kafka.
Secure data and manage users in Azure Synapse serverless SQL pools
Learn how you can set up security when using Azure Synapse serverless SQL pools
There are no reviews yet.