Azure Synapse Dedicated SQL Pool

Please log in to access your purchased courses.

This course provides a comprehensive exploration of Microsoft’s Data Warehousing Solution on cloud, the Dedicated SQL Pool. Basically, you will understand how to harness the power of massive parallel processing in a Dedicated SQL Pool, its performance optimizations, and you will acquire skills in enhancing security in Synapse Dedicated SQL Pool.

Azure Synapse Analytics

Lessons

Introduction to Azure Synapse Analytics Overview of Azure Synapse Analytics Lab – Create a Synapse Workspace Lab – Tour in Azure Synapse Analytics

Data Warehousing and ETL in Dedicated SQL Pool

Lessons

Data Warehousing and ETL MPP Architecture of Dedicated SQL Pool Distributions in Tables of Dedicated SQL Pool Indexing of Tables of the Dedicated SQL Pool Lab – Create Dedicated SQL Pool Lab – Create Azure SQL DB Lab – Popoulate Dedicated SQL pool using Synapse Link Lab – Explore Dedicated SQL Pool Data Loading Process (ETL) in Dedicated SQL Pool Create and Load Staging Tables Slowly Changing Dimensions Loading Dimension Tables Loading Fact Tables and Post Load Optimization

Performance Improvement of Dedicated SQL Pool

Lessons

Table Partitioning Lab – Create a partitioned Table Partition splitting and switching Partition splitting and switching Example Overview Lab-Partition splitting and switching example Dynamic Management Views Identify Connection Information and activity Identify and troubleshoot query performance Materialized Views EXPLAIN WITH_RECOMMENDATIONS Workload Management Lab – Workload Management

Secure a Dedicated SQL Pool

Lessons

Conditional Access Dynamic Data Masking Lab – Dynamic Data Masking Lab – Column Level Security Lab – Row Level Security Lab – Transparent Data Encryption