К содержимому
learnspaceYOUR NEXT CHAPTER
ПРОСТРАНСТВО ОБУЧЕНИЯ
ГлавнаяКаталог курсовМоё обучениеCoursera

Знания без границ

Учитесь у лучших университетов и компаний мира.

Открыть Coursera
Интеграция
Пространство университета
Моё пространствоСтраница курса
↵
ЯЛичный кабинетСтудент
© 2026 LearnSpaceКаждый день — возможность узнать больше.Помощь
Build A Data Warehouse in Azure · LearnSpace
Назад в каталог
courseraIT и технологии

Build A Data Warehouse in Azure

Курс от EDUCBA
Начальный≈ 15.5 чАнглийский
О курсеНавыкиПрограммаПреподаватели

О курсе

Unlock the power of Azure Synapse Analytics with our comprehensive course designed to elevate your data warehousing skills. Across twelve modules, participants delve into foundational concepts, advanced techniques, and practical applications, equipping them with the expertise needed to excel in modern data-driven environments. Learning Outcomes: 1) Understand data warehousing fundamentals and design principles. 2) Master Azure Synapse Analytics features and capabilities. 3) Learn to provision workspaces, integrate data, and optimize performance. 4) Ensure security and compliance in data management processes. 5) Explore advanced analytics with Apache Spark and data visualization with Power BI. Benefits for learners: Completing this course empowers participants to efficiently manage data, optimize workflows, and derive meaningful insights using Azure Synapse Analytics. By gaining expertise in Azure's cutting-edge data platform, learners become invaluable assets to organizations seeking to leverage data for strategic decision-making and competitive advantage. What Makes This Course Unique: This course stands out for its comprehensive coverage of Azure Synapse Analytics, encompassing both foundational concepts and advanced techniques. Participants benefit from hands-on experience, real-world examples, and expert guidance, ensuring they acquire practical skills that can be immediately applied in professional settings. Join us on a journey to master data warehousing in Azure and unlock new possibilities for success in the data-driven world. Target Learner: 1) Data Engineers or Database Administrators seeking to expand their skills in designing, implementing, and managing data warehouses specifically in the Azure cloud environment. 2) Business Intelligence Developers or Analysts aiming to understand how to leverage Azure services to build scalable and efficient data warehouses for advanced analytics and reporting. 3) IT professionals or decision-makers responsible for architecting data solutions within their organizations, interested in utilizing Azure's data warehousing capabilities to improve data management, accessibility, and insights. Pre-requisites: 1) Basic Understanding of Data Concepts: Learners should have a fundamental understanding of data concepts such as databases, data modeling, and data manipulation. 2) Familiarity with Azure Platform: Prior experience or knowledge of Microsoft Azure platform services, such as Azure SQL Database, Azure Data Factory, and Azure Storage, would be beneficial. 3) SQL Proficiency: A solid understanding of SQL (Structured Query Language) is essential, as SQL is commonly used for querying and manipulating data in Azure data services.

Навыки, которые вы освоите

Azure Synapse AnalyticsData WarehousingExtract, Transform, LoadData IntegrationData ProcessingData Visualization SoftwarePower BIData SecurityScalabilityData TransformationCloud SecurityData PipelinesPerformance TuningApache SparkQuery LanguagesData ArchitectureDatabase ManagementSecurity ControlsData StorageMicrosoft Azure

Программа курса

12 модулей · 135 учебных материалов

01Introduction to Data Warehousing14 материалов

Understanding Need for Data Warehousing

Course Syllabus - Welcome readingЧтениеCourse IntroductionВидеоWhat is a Data warehouse?ВидеоWhat is the need to go for Data warehouse?Видео

Учитесь у экспертов

EDUCBA

Преподаватель курса

Build A Data Warehouse in Azure
В каталоге вашей программы

Инвестируйте в себя

Новые знания — в удобное для вас время.

Начать на Coursera

Обучение откроется на Coursera
в новой вкладке

Обучение на Coursera

≈ 15.5 ч

12 модулей

Язык: Английский

Субтитры: Вьетнамский, Казахский

Часть программы вашего университета
Data warehouse architecture and design overviewВидео
Data Lake Vs Data warehouseВидео
Understanding the Need for Data WarehousingЗадание

Key Concepts and Components of a Data Warehouse

Data warehouses key conceptsВидеоTypes of data warehousesВидеоKey Concepts and Components of Data WarehouseЗаданиеFrom Data Chaos to Clarity: Applying Core Data Warehousing Concepts in AzureDIALOGUEIntroduction to Data WarehousingЗаданиеDiscussion Prompt - Introduction to Data WarehousingОбсуждениеClarifying Data Warehouse Needs and Architecture in AzureDIALOGUE
02Introduction to Azure Services for Data Warehousing11 материалов

Overview of Azure Data Platform

Introduction to Azure Data PlatformВидеоKey Features and benefits of Azure Data PlatformВидеоOverview of Azure Data PlatformЗадание

Introduction to Azure Synapse Analytics

Introduction to Azure Synapse AnalyticsВидеоMore on Azure Synapse AnalyticsВидеоIntroduction to Azure Synapse AnalyticsЗадание

Azure SQL Data Warehouse Overview

Azure SQL Data Warehouse overviewВидеоKey component of a big data solutionВидеоAzure SQL Data Warehouse OverviewЗаданиеIntroduction to Azure Services for Data WarehousingЗаданиеDiscussion Prompt - Introduction to Azure Services for Data WarehousingОбсуждение
03Designing Data Warehouse Architecture16 материалов

Design Principles and Best Practices for Data Warehousing

Best practices for designing and implementing a DW for BIВидеоBest practices for loading data into a dedicated SQL pool ASA Part 1ВидеоBest practices for loading data into a dedicated SQL pool ASA Part 2ВидеоBest practices for serverless SQL pool in ASAВидеоBest practices for dedicated SQL pool in ASAВидеоDesign principles and best practices for data warehousingЗадание

Choosing Right Azure Services for your Data Warehouse

Azure data services for ASA Part 1ВидеоAzure data services for ASA Part 2ВидеоAzure NoSQL-data services for ASAВидеоAzure streaming servicesВидеоChoosing the right Azure services for your data warehouseЗадание

Data Modeling Considerations for Data Warehouse

Data modelling considerations in ASAВидеоSelf service ETLВидеоData Modeling Considerations for a Data WarehouseЗаданиеDesigning Data Warehouse ArchitectureЗаданиеDiscussion Prompt - Designing Data Warehouse ArchitectureОбсуждение
04Data Extraction and Loading11 материалов

Data Modeling Considerations for Data Warehouse

Understanding data extractionВидеоLearning how data is loadedВидеоData Modeling Considerations for Data WarehouseЗадание

Data Transformation and Loading into Data Warehouse

Overview of data transformationВидеоExplain Azure Data Factory transformation methodsВидеоDescribe Azure Data Factory transformation types Part 1ВидеоDescribe Azure Data Factory transformation types Part 2ВидеоTransform natively in ASA and ADF with data flows ВидеоData Transformation and Loading into Data WarehouseЗаданиеData Extraction and LoadingЗаданиеDiscussion Prompt - Data Extraction and LoadingОбсуждение
05Implementing Azure Synapse Analytics for Data Warehousing9 материалов

Overview of Azure Synapse Analytics

Overview of Azure Synapse AnalyticsВидеоAzure Synapse Analytics - operationsВидеоAzure Synapse Analytics - Use casesВидеоOverview of Azure Synapse AnalyticsЗадание

Key Features and Capabilities of Azure Synapse Analytics

Key features of Azure SynapseВидеоCapabilities of Azure Synapse AnalyticsВидеоKey Features and Capabilities of Azure Synapse AnalyticsЗаданиеImplementing Azure Synapse Analytics for Data WarehousingЗаданиеDiscussion Prompt - Implementing Azure Synapse Analytics for Data WarehousingОбсуждение
06Creating and Managing Data Warehouse in Azure Synapse Analytics18 материалов

Provisioning Azure Synapse Analytics Workspace

LAB - Create Synape WS using powershell -LABВидеоLAB - Explore Synapse StudioВидеоLAB - Pause resume and cleanupВидеоPause ComputeЧтениеLAB - Create Synape WS through portalВидеоProvisioning Azure Synapse Analytics WorkspaceЗадание

Configuring Data Warehouse Storage and Compute Resources

LAB - Create new dedicated SQL pool-thru portalВидеоLAB - Create new dedicated SQL pool-thru StudioВидеоLAB - Create a new serverless Apache Spark pool using Azure Portal and Synapse StudioВидеоConfiguring Data Warehouse Storage and Compute Resources Задание

Managing Security and Access Control

Manage authorization through column and row level security Part 1ВидеоManage authorization through column and row level security Part 2ВидеоManage sensitive data with Dynamic Data Masking Part 1ВидеоManage sensitive data with Dynamic Data Masking Part 2ВидеоDemo Configure authentication and acess controlВидеоManaging Security and Access Control Задание
07Data Integration and Orchestration in Azure Synapse Analytics8 материалов

Data Ingestion and Integration Options

Introduction to data ingestionВидеоIntroduction to data integration Part 1ВидеоIntroduction to data integration Part 2ВидеоData Ingestion and Integration OptionsЗадание

Orchestration of Data Workflows in Azure Synapse Pipelines

Pipelines and activities in Azure Synapse AnalyticsВидеоOrchestration of Data Workflows in Azure Synapse PipelinesЗаданиеData Integration and Orchestration in Azure Synapse AnalyticsЗаданиеDiscussion Prompt - Data Integration and Orchestration in Azure Synapse AnalyticsОбсуждение
08Advanced Analytics in Azure Synapse Analytics9 материалов

Introduction to Big Data Analytics in Azure Synapse Analytics

Introduction to Apache Spark in Azure Synapse AnalyticsВидеоAnalyze Data with Apache SparkВидеоVisualize Data with Apache SparkВидеоIntroduction to Big Data Analytics in Azure Synapse AnalyticsЗадание

Performing Data Exploration and Analysis Using Apache Spark

LAB- Performing data exploration and analysis using Apache Spark Part 1ВидеоLAB- Performing data exploration and analysis using Apache Spark Part 2ВидеоDiscussion Prompt - Advanced Analytics in Azure Synapse AnalyticsОбсуждениеPerforming Data Exploration and Analysis Using Apache SparkЗаданиеAdvanced Analytics in Azure Synapse AnalyticsЗадание
09Performance Optimization in Azure Synapse Analytics9 материалов

Optimizing Performance and Scaling in Azure Synapse Analytics

Optimizing Performance and Scaling in Azure Synapse AnalyticsВидеоUnderstanding the performance bottlenecks and optimization in ASAВидеоOptimizing Performance and Scaling in Azure Synapse AnalyticsЗадание

Query Performance Tuning and Optimization Techniques

Understand performance issues related to tablesВидеоUsing Indexes to Improve Query Performance in ASAВидеоCreate statistics to improve query performanceВидеоQuery Performance Tuning and Optimization TechniquesЗаданиеPerformance Optimization in Azure Synapse AnalyticsЗаданиеDiscussion Prompt - Performance Optimization in Azure Synapse AnalyticsОбсуждение
10Data Partitioning and Distribution Strategies10 материалов

Partitioning Data for Improved Query Performance

Partitioning tables in dedicated SQL PoolВидеоData partitioning techniques in System Design Part 1ВидеоData partitioning techniques in System Design Part 2ВидеоPartitioning Data for Improved Query PerformanceЗадание

Choosing Right Distribution Strategy for Data Warehouse Tables

Understanding distribution tablesВидеоHow to choose right data distribution strategy for ASAВидеоAssessing distribution strategy suitabilityВидеоDiscussion Prompt - Data Partitioning and Distribution StrategiesОбсуждениеChoosing Right Distribution Strategy for Data Warehouse TablesЗаданиеData Partitioning and Distribution StrategiesЗадание
11Advanced Security and Compliance in Azure Synapse Analytics10 материалов

Implementing Security and Encryption for Data at Rest and in Transit

Security baseline for ASA Part 1ВидеоSecurity baseline for ASA Part 2ВидеоEncryption for data at rest and in transit in ASAВидеоImplementing Security and Encryption for Data at Rest and in TransitЗадание

Compliance Considerations and Data Governance in Azure Synapse Analytics

Ensuring Regulatory Compliance in Azure Synapse Analytics Part 1ВидеоEnsuring Regulatory Compliance in Azure Synapse Analytics Part 2ВидеоEmpowering Data Governance with Microsoft Purview and ASAВидеоDiscussion Prompt - Advanced Security and Compliance in Azure Synapse AnalyticsОбсуждениеCompliance Considerations and Data Governance in Azure Synapse AnalyticsЗаданиеAdvanced Security and Compliance in Azure Synapse AnalyticsЗадание
12Scaling and Managing Azure Synapse Analytics10 материалов

Scaling Up and Out to Meet Performance and Capacity Needs

Scale compute resources in Azure Synapse - Hands onВидеоManage workloads in Azure Synapse AnalyticsВидеоScaling Up and Out to Meet Performance and Capacity NeedsЗадание

Monitoring, Troubleshooting, and Optimizing Azure Synapse Analytics

Introduction to the Monitor Hub in ASA - Hands onВидеоLeveraging Azure Advisor Recommendations for Dedicated SQL PoolsВидеоTroubleshooting common issues encountered in dedicated SQL pools Part 1ВидеоTroubleshooting common issues encountered in dedicated SQL pools Part 2ВидеоMonitoring, Troubleshooting, and Optimizing Azure Synapse AnalyticsЗаданиеDiscussion Prompt - Scaling and Managing Azure Synapse AnalyticsОбсуждениеScaling and Managing Azure Synapse AnalyticsЗадание
Creating and Managing Data Warehouse in Azure Synapse AnalyticsЗадание
Discussion Prompt - Creating and Managing Data Warehouse in Azure Synapse AnalyticsОбсуждение