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

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

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

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

Data Storage & Processing

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

О курсе

Master the data storage patterns and processing techniques that power enterprise analytics in Microsoft Fabric. In this hands-on course, you’ll design scalable lakehouse solutions and build production-grade storage architectures that support performance, governance, and advanced analytics workloads. You’ll implement a Medallion architecture in OneLake using bronze, silver, and gold layers, and register lineage in Microsoft Purview. You’ll ingest data into a Fabric Lakehouse using pipelines, Copy Jobs, and notebooks while selecting appropriate Delta table types. You’ll query data through the SQL Endpoint for analysis and use notebooks for programmatic access, then enforce consistency with time-travel queries and MERGE-based ACID transactions using Delta Lake. You’ll also optimize tables with OPTIMIZE, ZORDER, and VACUUM operations and design a Fabric Warehouse schema in T-SQL to support star-schema analytics and incremental loads. By the end, you’ll have practical experience building optimized Lakehouse and Warehouse solutions and the core data engineering skills required for enterprise Fabric implementations.

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

Data StorageStar SchemaData WarehousingTransact-SQLData MaintenanceTransaction ProcessingData AccessPower BIData ProcessingData ArchitectureData Storage TechnologiesOperational DatabasesData LakesDependency AnalysisInformation ManagementData AnalysisData PipelinesMicrosoft AzureExtract, Transform, LoadPerformance Tuning

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

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

01Implementing Medallion Architecture5 материалов
Why Medallion Architecture WinsВидеоBronze, Silver, and Gold Layer DesignВидеоMedallion Design PatternsЧтениеHands-on Activity: Build Medallion StructureЧтение

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

Microsoft

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

Data Storage & Processing
В каталоге вашей программы

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

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

Начать на Coursera

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

Обучение на Coursera

≈ 8.2 ч

11 модулей

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

Часть программы вашего университета
Knowledge Check: Implementing Medallion ArchitectureЗадание
02Tracing Lineage in Microsoft Fabric4 материалов
Why Lineage Matters for GovernanceЧтениеHands-on Activity: Trace Lineage in Microsoft FabricЧтениеKnowledge Check: Tracking Lineage in Microsoft FabricЗаданиеLayer Data with Medallion AssessmentЗадание
03Ingestion Methods and Delta Table Types8 материалов
Choosing the Right Ingestion PathВидеоIngestion Methods Explained - Part 1ВидеоIngestion Methods Explained - Part 2ВидеоIngestion Patterns Quick ReferenceЧтениеHands-on Activity: Practice Multiple Ingestion MethodsЧтениеSelect Ingestion Method and Table TypeDIALOGUEKnowledge Check: Ingestion Methods and Delta Table TypesЗаданиеIngest Data into Lakehouse AssessmentЗадание
04Reading Data with SQL Endpoint and Notebooks7 материалов
Two Paths to Your DataВидеоSQL Endpoint Deep DiveВидеоNotebook Data AccessВидеоSQL vs. Notebook Access ComparisonЧтениеHands-on Activity: Query Data Both WaysЧтениеKnowledge Check: Reading Data with SQL Endpoint and NotebooksЗаданиеRead Data from Lakehouse AssessmentЗадание
05Delta Lake Transactions and MERGE Operations5 материалов
Discover Why Transactions MatterDIALOGUEACID Properties and the Transaction LogВидеоMERGE Syntax and PatternsЧтениеHands-on Activity: Implement MERGE OperationЧтениеKnowledge Check: Delta Lake Transactions and MERGE OperationsЗадание
06Time-Travel Queries for Historical Analysis7 материалов
The Power of Looking Back in TimeВидеоTime-Travel Syntax and CapabilitiesВидеоTime-Travel Patterns and RetentionЧтениеHands-on Activity: Perform Time-Travel AuditЧтениеHands-on Activity: Time-Travel Audit ReportЗаданиеKnowledge Check: Time-Travel Queries for Historical AnalysisЗаданиеEnsure Delta Consistency AssessmentЗадание
07Delta Table Optimization6 материалов
When Queries Slow to a CrawlВидеоOPTIMIZE and ZORDER Explained - Part 1ВидеоOPTIMIZE and ZORDER Explained - Part 2ВидеоOptimization Commands ReferenceЧтениеHands-on Activity: Diagnose and OptimizeЧтениеDelta Table OptimizationЗадание
08Managing Storage with VACUUM6 материалов
The Hidden Cost of Data HistoryВидеоVACUUM Operations and RetentionВидеоVACUUM Patterns and Best PracticesЧтениеHands-on Activity: VACUUM with VerificationЧтениеKnowledge Check: Managing Storage with VACUUMЗаданиеOptimize and Vacuum Delta Tables AssessmentЗадание
09Designing Star-Schema Warehouses5 материалов
Why Star Schemas Power AnalyticsВидеоStar Schema Design and T-SQL PatternsВидеоWarehouse Design PatternsЧтениеHands-on Activity: Design Star SchemaЧтениеDesigning Star-Schema WarehousesЗадание
10Warehouse Mirroring6 материалов
When ETL Isn't Fast EnoughЧтениеWarehouse Mirroring ConfigurationВидеоMirroring Setup ReferenceЧтениеMirroring Configuration WalkthroughЧтениеWarehouse MirroringЗаданиеModel Warehouses in T-SQL AssessmentЗадание
11Data Storage & Processing Pipeline Project4 материалов
Why This Project MattersЧтениеProject Requirements and Evaluation CriteriaЧтениеProject InstructionsЧтениеData Storage & Processing Architecture Document ProjectЗадание