Optimizing Microsoft Azure Data Solutions
Azure has a vast array of data services, and in this course you'll explore a number of key areas that will help maximize the utilization of those data services and enable your organization to get the most out of its cloud data service spend.
What you'll learn
Getting the most out of cloud data service spend in terms of performance is critical for every organization. In this course, Optimizing Microsoft Azure Data Solutions, you will gain the ability to access and optimize a number of key data services in Azure. First, you will learn how to optimize Azure SQL Database and Azure SQL Data Warehouse. Next, you will discover the key optimization considerations related to Cosmos DB and the importance of partitioning data the right way. Finally, you will explore how to achieve maximum performance when using Azure Data Lake and a number of key analysis services. When you’re finished with this course, you will have the skills and knowledge of optimizing Azure data services needed to maximize your Azure data service deployments.
Table of contents
- Module Introduction 1m
- Azure SQL Database Offerings 6m
- DTU vs. vCore 2m
- Core Azure SQL Database Offerings 6m
- Performance Impact of General Purpose vs. Business Critical 6m
- Serverless and Hyperscale 8m
- Database Sharding 5m
- Indexing and Tuning 12m
- Query Optimization 13m
- Optimizing with In-memory Tables and Compression 6m
- Azure Synapse Analytics Offerings 3m
- Azure Synapse Analytics Scale 5m
- Azure Synapse Analytics Compute Offerings 2m
- Optimizing Data Loading 6m
- Other Azure Data Loading Best Practices 3m
- Module Summary 1m