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

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

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

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

Data Warehousing with Microsoft Azure Synapse Analytics

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

О курсе

In this course, you will explore the tools and techniques that can be used to work with Modern Data Warehouses productively and securely within Azure Synapse Analytics. You will learn how Azure Synapse Analytics enables you to build Data Warehouses using modern architecture patterns and how the common schema is implemented in a data warehouse. You'll learn the best practices you need to adopt to load data into a data warehouse and the techniques that you can use to optimize query performance within Azure Synapse Analytics. This course is part of a Specialization intended for Data engineers and developers who want to demonstrate their expertise in designing and implementing data solutions that use Microsoft Azure data services for anyone interested in preparing for the Exam DP-203: Data Engineering on Microsoft Azure (beta). This is the fifth course in a program of 10 courses to help prepare you to take the exam so that you can have expertise in designing and implementing data solutions that use Microsoft Azure data services. The Data Engineering on Microsoft Azure exam is an opportunity to prove knowledge expertise in integrating, transforming, and consolidating data from various structured and unstructured data systems into structures that are suitable for building analytics solutions that use Microsoft Azure data services. Each course teaches you the concepts and skills that are measured by the exam. By the end of this Specialization, you will be ready to take and sign-up for the Exam DP-203: Data Engineering on Microsoft Azure (beta).

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

Azure Synapse AnalyticsData WarehousingSnowflake SchemaData TransformationStar SchemaApache SparkData ProcessingDatabase DesignData MartMicrosoft AzureQuery LanguagesData ManagementTransact-SQLData LakesData ArchitectureData SecuritySQLPerformance TuningData IntegrationData Import/Export

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

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

01Design a Modern Data Warehouse using Azure Synapse Analytics16 материалов

Welcome to the course

Introduction to the courseВидеоCourse syllabusЧтениеHow to be successful in this courseЧтениеData retrievalОбсуждение

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

Microsoft

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

Data Warehousing with Microsoft Azure Synapse Analytics
В каталоге вашей программы

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

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

Начать на Coursera

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

Обучение на Coursera

≈ 14.9 ч

6 модулей

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

Субтитры: Арабский, Французский, Бенгальский, Узбекский, Украинский, Китайский (Китай), Греческий, Итальянский, Бразильский португальский, Нидерландский, Корейский, Немецкий, Пушту, Урду, Русский, Тайский, Индонезийский, Шведский, Турецкий, Азербайджанский, Испанский, Дари, Хинди, Японский, Казахский, Венгерский, Польский

Часть программы вашего университета

Build a modern data warehouse

Describe a modern data warehouseВидео
Define a modern data warehouse architectureВидео
Identify modern data warehouse architecture componentsЧтение
Design ingestion patterns for a modern data warehouseЧтение
Knowledge checkЗадание

Work with data in a modern data warehouse

Understand data storage for a modern data warehouseВидеоUnderstand file formats and structure for a modern data warehouseВидеоPrepare and transform data with Azure Synapse AnalyticsЧтениеServe data for analysis with Azure Synapse AnalyticsЧтениеKnowledge checkЗаданиеTest prepЗаданиеModule summaryВидео
02Design a multidimensional schema to optimize analytical workloads10 материалов

Design and implement data stores in a modern data warehouse

Module introductionВидеоDesign and implement a star schemaВидео Create a star schemaЧтениеDesign and implement a snowflake schemaЧтение Create a snowflake schemaЧтениеDesign and implement a time dimension tableЧтениеCreate and populate a time dimension tableЧтениеKnowledge checkЗаданиеTest prepЗаданиеModule summaryВидео
03Data loading and querying in Azure Synapse Analytics26 материалов

Use data loading best practices in Azure Synapse Analytics

Lesson introductionВидеоUnderstand data load design goalsВидеоExplain load methods into Azure Synapse AnalyticsВидеоManage source data filesВидеоManage singleton updates and concurrent access to Azure Synapse AnalyticsВидеоSet-up dedicated data load accountsЧтениеImplement workload managementВидеоImplement workload managementЧтениеSimplify ingestion with the Copy ActivityЧтениеKnowledge checkЗаданиеTest prepЗаданиеLesson summaryВидео

Optimize data warehouse query performance in Azure Synapse Analytics

Lesson introductionВидеоUnderstand performance issues related to tablesВидеоUnderstand performance issues related to tablesЧтениеSynapse Analytics SQL PoolsPLUGINUnderstand table distribution designВидеоUse indexes to improve query performanceВидео
04Integrating pools and developer tools in Azure Synapse Analytics23 материалов

Integrate SQL and Apache Spark pools in Azure Synapse Analytics

Lesson introductionВидеоDescribe the integration methods between SQL and Spark pools in Azure Synapse AnalyticsВидеоUnderstand the use-cases for SQL and Spark pools integrationВидеоAuthenticate in Azure Synapse AnalyticsВидеоTransfer data between SQL and Spark pool in Azure Synapse AnalyticsЧтениеAuthenticate between Spark and SQL pool in Azure Synapse AnalyticsЧтениеIntegrate SQL and Spark pools in Azure Synapse AnalyticsЧтениеExternalize the use of Spark pools within Azure Synapse WorkspaceВидеоTransfer data outside the Synapse workspace using the PySpark connectorЧтениеKnowledge checkЗаданиеLesson summaryВидео

Understand data warehouse developer features of Azure Synapse Analytics

Lesson introductionВидеоExplore the development tools for Azure Synapse AnalyticsЧтениеUnderstand transact-SQL language capabilities for Azure Synapse AnalyticsЧтениеWork with windowing functionsВидеоWork with windowing functionsЧтениеWork with approximate executionВидео
05Manage, optimize and secure a data warehouse36 материалов

Manage and monitor data warehouse activities in Azure Synapse Analytics

Lesson introductionВидеоScale compute resources in Azure Synapse AnalyticsЧтениеPause compute in Azure Synapse AnalyticsВидеоManage workloads in Azure Synapse AnalyticsЧтениеUse Azure Advisor to review recommendationsВидеоUse dynamic management views to identify and troubleshoot query performanceЧтениеKnowledge checkЗаданиеLesson summaryВидео

Analyze and optimize data warehouse storage in Azure Synapse Analytics

Lesson introductionВидеоUnderstand skewed data and space usageЧтениеCheck for skewed data and space usageЧтениеUnderstand column store storage detailsВидеоView column store storage detailsЧтениеUnderstand the impact of wrong choices for column data typesЧтение

Secure a data warehouse in Azure Synapse Analytics

Lesson introductionВидеоUnderstand network security options for Azure Synapse AnalyticsВидеоConfigure conditional accessPLUGINConfigure conditional accessЧтениеConfigure authenticationВидеоConfigure authentication using Key VaultPLUGIN
06Practice Exam on Work with Data Warehouses using Azure Synapse Analytics6 материалов

Course Practice Exam

Course recapВидеоAbout the practice examЧтениеCourse practice examЗадание

Course wrap up

Course summaryВидеоReflect on learningОбсуждениеNext stepsЧтение
Use table distribution and indexes to improve performanceЧтение
Create statistics to improve query performanceЧтение
Improve query performance with materialized viewsВидео
Use read committed snapshot for data consistencyВидео
Optimize common queries with result-set cachingВидео
Knowledge checkЗадание
Test prepЗадание
Lesson summaryВидео
Work with approximate executionЧтение
Work with JSON data in SQL poolsЧтение
Encapsulate transact-SQL logic with stored proceduresВидео
Knowledge checkЗадание
Test prepЗадание
Lesson summaryВидео
Compare storage requirements between optimal and sub-optimal column data typesЧтение
Describe the impact of materialized viewsВидео
Improve the execution plan of a query with a materialized viewЧтение
Understand rules for minimally logged operationsВидео
Optimize a delete operationЧтение
Knowledge checkЗадание
Lesson summaryВидео
Configure authentication using keys and shared accessВидео
Manage authorization through column and row level securityВидео
Manage authorization through column and row level security - Permissions and Best practicesВидео
Manage authorization through column and row level securityЧтение
Manage sensitive data with Dynamic Data MaskingЧтение
Implement encryption in Azure Synapse AnalyticsВидео
Knowledge checkЗадание
Test prepЗадание
Lesson summaryВидео