Azure Synapse Analytics Deep Dive: Optimize a Data Warehouse with Dedicated SQL Pools

Azure Synapse is a scalable analytics service that brings together enterprise data warehousing and Big Data analytics. This deep dive shows you how to perform data engineering and exploration, build automated data integration pipelines, run interactive queries using serverless SQL pools, and optimize a data warehouse with dedicated SQL pools. Finally, you will learn the end-to-end Azure Machine Learning and Azure Cognitive experience in Azure Synapse Analytics.

• Use T-SQL developer features, including windowing functions and HyperLogLog functions
• Use data loading best practices with workload management, workload classification, and isolation
• Improve data warehouse query performance through optimizing table structures
• Improve query performance
• Check for skewed data and space usage
• Understand column-store storage details
• Study the impact of column data type selection
• Study the impact of materialized views
• Avoid extensive logging