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

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

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

Открыть Coursera
Интеграция
Пространство университета
Моё пространствоСтраница курса
↵
ЯЛичный кабинетСтудент
© 2026 LearnSpaceКаждый день — возможность узнать больше.Помощь
Data Warehousing & Pipeline Development in Microsoft Fabric · LearnSpace
Назад в каталог
courseraАнализ данных

Data Warehousing & Pipeline Development in Microsoft Fabric

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

О курсе

This course teaches you how to build and manage data warehouses and pipelines using Microsoft Fabric. You will get hands-on experience by creating data warehouses, designing schemas, and developing ETL/ELT pipelines with Data Factory. The course covers the use of T-SQL for data transformations and incorporates version control for data workflows, ensuring you can manage production environments confidently. By the end of this course, you will be able to orchestrate data pipelines, implement security, and handle data-to-insights workflows from ingestion through security and deployment.

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

Extract, Transform, LoadData IntegrationData WarehousingGit (Version Control System)Data PipelinesTransact-SQLData TransformationCI/CDSnowflake SchemaStar SchemaData ArchitectureContinuous IntegrationDevOpsData ModelingDatabase DesignDataflowPerformance Tuning

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

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

01Fabric Data Warehouse Fundamentals25 материалов

Introduction to Fabric data warehouse

Fabric data warehouse overviewВидеоCourse syllabusЧтениеFabric Data Warehouse architectureЧтениеData Warehouse interface explorationВидео

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

Microsoft

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

Data Warehousing & Pipeline Development in Microsoft Fabric
В каталоге вашей программы

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

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

Начать на Coursera

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

Обучение на Coursera

≈ 29.4 ч

5 модулей

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

Субтитры: Арабский, Французский, Итальянский, Бразильский португальский, Корейский, Немецкий, Пушту, Испанский, Дари, Японский

Часть программы вашего университета
Warehouse strategy discussionDIALOGUE
Fabric Data Warehouse component explorationЗадание
Data Warehouse fundamentals knowledge checkЗадание

Creating and configuring a data warehouse

Building the foundation rightВидеоData warehouse setup guideЧтениеData warehouse creation processВидеоStrategic Configuration planning for data warehousesDIALOGUEData warehouse creation and setupЗаданиеWarehouse setup knowledge checkЗадание

Computing scaling and performance

Scale when you need itВидеоCompute scaling and performance optimizationЧтениеPerformance testing and scalingВидеоScaling strategy planningDIALOGUECompute scaling experimentЗаданиеPerformance and scaling knowledge checkЗадание

T-SQL for data warehousing

T-SQL in the cloud eraВидеоT-SQL in Fabric data warehouseЧтениеT-SQL operations demonstrationВидеоT-SQL data warehousing scenariosЗаданиеT-SQL operations knowledge checkЗаданиеData warehouse fundamentals graded quizЗадание
02Schema Design for Data Warehousing26 материалов

Star schema modeling

The power of star schemaВидеоStar schema design principlesЧтениеStar schema implementationВидеоStar schema implementation in Fabric data warehouseЗаданиеStrategic star schema design planningDIALOGUESales analysis star schema creationЗаданиеStar schema design knowledge checkЗадание

Snowflake schema implementation

When normalization mattersВидеоSnowflake schema design and implementationЧтениеStar to snowflake transformationВидеоNormalization strategy discussionDIALOGUEComplex dimension snowflake implementationЗаданиеSnowflake implementation knowledge checkЗадание

Data vault modeling

Enterprise-scale data integrationВидеоData Vault modeling methodologyЧтениеData Vault model creationВидеоData Vault strategy planningDIALOGUEBusiness domain Data Vault designЗаданиеData Vault concepts knowledge checkЗадание

Schema design decision framework

Choosing the right approachВидеоSchema selection decision matrixЧтениеSchema evaluation processВидеоYour schema strategyDIALOGUEMulti-scenario schema evaluationЗаданиеSchema selection knowledge checkЗадание
03Advanced Table Types and Transactions28 материалов

Distributed vs. replicated tables

Distribution for performanceВидеоTable distribution strategiesЧтениеDistribution strategy implementationВидеоData distribution strategy performance analysisЗаданиеDistribution strategy planningDIALOGUETable distribution implementationЗаданиеTable distribution knowledge checkЗадание

Clustered columnstore indexes

Columnstore for analyticsВидеоColumnstore index architectureЧтениеColumnstore implementation and testingВидеоIndex performance analysis and optimizationЗаданиеIndexing strategy discussionDIALOGUEColumnstore performance analysisЗадание

Multi-table transactions

Transaction integrity at scaleВидеоAdvanced transaction managementЧтениеComplex transaction implementationВидеоTransaction design planningDIALOGUEMulti-table transaction developmentЗаданиеTransaction management knowledge checkЗадание

User-defined functions

Reusable logic for efficiencyВидеоUDF development and optimizationЧтениеUDF development processВидеоT-SQL user-defined function toolkitЗаданиеFunction design strategyDIALOGUEUDF development and testingЗадание
04Data Factory and Pipeline Development28 материалов

Data Factory overview

Pipeline-driven data integrationВидеоData factory architecture and componentsЧтениеData Factory interface tourВидеоPipeline component mapperЗаданиеIntegration architecture planningDIALOGUEData Factory interface explorationЗаданиеData Factory fundamentals knowledge checkЗадание

Creating ETL/ELT pipelines

ETL vs ELT strategyВидеоETL/ELT pipeline design patternsЧтениеPipeline development processВидеоETL vs. ELT implementation patternsЗаданиеPipeline design strategyDIALOGUEETL and ELT pipeline implementationЗадание

Pipeline parameters and control flow

Fundamental pipeline parameterizationВидеоDynamic and reusable pipelinesВидеоAdvanced pipeline controlЧтениеAdvanced control flow implementationВидеоControl flow strategyDIALOGUEAdvanced pipeline control implementationЗадание

Pipeline monitoring and troubleshooting

Operational excellence in data pipelinesВидеоPipeline operations and monitoringЧтениеMonitoring and debugging processВидеоMonitoring strategy planningDIALOGUEPipeline monitoring and troubleshootingЗаданиеPipeline operations knowledge checkЗадание
05Transformation Logic and CI/CD26 материалов

Transformation strategies

Choosing the right transformation toolВидеоTransformation strategy comparisonЧтениеTransformation strategy designВидеоYour transformation strategyDIALOGUEMulti-strategy transformation designЗаданиеTransformation strategy knowledge checkЗадание

Implementing dataflows and notebook transformations

Visual vs. code-based transformationsВидеоDataflows Gen2 and notebook developmentЧтениеTransformation implementation demoВидеоImplementation approach selectionDIALOGUEComprehensive transformation implementationЗаданиеTransformation implementation knowledge checkЗадание

Delta pipeline integration

Schema evolution in productionВидеоDelta pipeline architecture and schema evolutionЧтениеDelta integration configurationВидеоEvolution strategy planningDIALOGUESchema evolution testingЗаданиеDelta integration knowledge checkЗадание

CI/CD with Git integration

DevOps for data pipelinesВидеоGit integration and CI/CD for FabricЧтениеCI/CD setup and implementationВидеоDevOps strategy planningDIALOGUEComplete CI/CD ImplementationЗаданиеCI/CD Implementation knowledge checkЗадание
Schema design mastery graded quiz Задание
Columnstore optimization knowledge checkЗадание
UDF development knowledge checkЗадание
Advanced table types and transactions graded quizЗадание
Pipeline design knowledge check Задание
Pipeline control knowledge checkЗадание
Data Factory and pipeline development graded quizЗадание
Transformation logic and CI/CD graded quizЗадание
Enterprise data warehouse and pipeline solutionЗадание