Company: Pluralsight Author: John Savill Full Title: Optimizing Microsoft Azure Data Solutions Year: 2019 Language: English Genre: Educational: Databases Skill Level: Intermediate Price: - - Files: MP4 (+ Slides .PDF, Subtitles .SRT) Time: 02:41:34 Video: AVC, 1280 x 720 (1.778) at 30.000 fps, 200 kbps Audio: AAC at 96 Kbps, 2 channels, 48.0 KHz 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. 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. Lessons: 1. Course Overview 01. Course Overview 2. Core Optimization Concepts 02. Module Introduction 03. Why Is This Important? 04. Consumption in the Cloud 05. What Is Optimization in the Cloud? 06. Common Types of Optimization 07. Data Partioning 08. Module Summary 3. Optimizing Azure SQL Database and Data Warehouse 09. Module Introduction 10. Azure SQL Database Offerings 11. DTU vs. vCore 12. Core Azure SQL Database Offerings 13. Performance Impact of General Purpose vs. Business Critical 14. Serverless and Hyperscale 15. Database Sharding 16. Indexing and Tuning 17. Query Optimization 18. Optimizing with In-memory Tables and Compression 19. Azure SQL Data Warehouse Offerings 20. Azure SQL Data Warehouse Scale 21. Optimizing Data Loading 22. Azure SQL Data Warehouse Loading Best Practices 23. Module Summary 4. Optimizing Azure Cosmos DB 24. Module Introduction 25. Request Units 26. Cosmos DB Partitions 27. Picking the Partition Key 28. Architecting Data Layout 29. Duplicating Data and the Change Feed 30. Other Optimization Considerations 31. Module Summary 5. Optimization Considerations for Data Services 32. Module Introduction 33. Azure Data Lake Storage Tuning 34. HDInsight Optimization 35. Azure Stream Analytics Optimization 36. Module Summary Our members see more. Join us! ------------- Our members see more. Join us!
