Coursera

Data Warehousing with Microsoft Azure Synapse Analytics (Coursera)

Offered by Microsoft,
Data Warehousing with Microsoft Azure Synapse Analytics (Coursera)

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.

Class Deals by MOOC List - Click here and see Coursera's Active Discounts, Deals, and Promo Codes.

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).

What You Will Learn

  • How to use Azure Synapse Analytics to build Data Warehouses using modern architecture patterns.

Course 5 of 10 in the Microsoft Azure Data Engineering Associate DP-203 Exam Prep Specialization

Syllabus

WEEK 1
Design a Modern Data Warehouse using Azure Synapse Analytics
In this module, you will learn how Azure Synapse Analytics enables you to build Data Warehouses using modern architecture patterns.

WEEK 2
Design a multidimensional schema to optimize analytical workloads
In this module, you will learn about how the common schema is implemented in a data warehouse.

WEEK 3
Data loading and querying in Azure Synapse Analytics
In this module, you will 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.

WEEK 4
Integrating pools and developer tools in Azure Synapse Analytics
In this module, you will learn how to integrate SQL and Apache Spark pools in Azure Synapse Analytics. You will also learn about the language capabilities that are available to create data warehouses in Azure Synapse Analytics.

WEEK 5
Manage, optimize and secure a data warehouse
In this module, you will learn how to manage and monitor Azure Synapse Analytics. You will learn to analyze information used to optimize a data warehouse in Azure Synapse Analytics and how to approach and implement security to protect your data with Azure Synapse Analytics.

WEEK 6
Practice Exam on Work with Data Warehouses using Azure Synapse Analytics
In this module, you will take a practice exam that covers key skills measured in the Exam DP-203: Data Engineering on Microsoft Azure.

Go to Class
MOOC List is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Related Courses

Deploy a website to Azure with Azure App Service (Coursera) Coursera
Microsoft

Deploy a website to Azure with Azure App Service (Coursera)

CS: Software Engineering

In this course, you will see how web apps in Azure allow you to publish and manage your website easily without having to work with the underlying servers, storage, or network assets. Instead, you can focus on your website features and rely on the robust Azure platform to provide secure access to your site. You will see how Azure App Service enables you to build and host web applications in the programming language of your choice without managing infrastructure. You will also learn how to create a website through the hosted web app platform in Azure App Service.

Aug 3rd 2026
5-12 Weeks
Web Applications Microsoft Azure Visual Studio
Details
Prepare for DP-100: Data Science on Microsoft Azure Exam (Coursera) Coursera
Microsoft

Prepare for DP-100: Data Science on Microsoft Azure Exam (Coursera)

CS: Software Engineering Computer Science

Microsoft certifications give you a professional advantage by providing globally recognized and industry-endorsed evidence of mastering skills in digital and cloud businesses. In this course, you will prepare to take the DP-100 Azure Data Scientist Associate certification exam. You will refresh your knowledge of how to plan and create a suitable working environment for data science workloads on Azure, run data experiments, and train predictive models. In addition, you will recap on how to manage, optimize, and deploy machine learning models into production.

Aug 3rd 2026
5-12 Weeks
Machine Learning Data Science Microsoft Azure
Details
Developing AI Applications on Azure (Coursera) Coursera
LearnQuest

Developing AI Applications on Azure (Coursera)

Data Science

This course introduces the concepts of Artificial Intelligence and Machine learning. We'll discuss machine learning types and tasks, and machine learning algorithms. You'll explore Python as a popular programming language for machine learning solutions, including using some scientific ecosystem packages which will help you implement machine learning.

Jul 27th 2026
5-12 Weeks
ML Artificial Intelligence Machine Learning
Details
Foundations for Big Data Analysis with SQL (Coursera) Coursera
Cloudera

Foundations for Big Data Analysis with SQL (Coursera)

Statistics & Data Analysis Data Science

In this course, you'll get a big-picture view of using SQL for big data, starting with an overview of data, database systems, and the common querying language (SQL). Then you'll learn the characteristics of big data and SQL tools for working on big data platforms. You'll also install an exercise environment (virtual machine) to be used through the specialization courses, and you'll have an opportunity to do some initial exploration of databases and tables in that environment.

Aug 3rd 2026
5-12 Weeks
Databases SQL Big Data
Details
Business intelligence and data warehousing (Coursera) Coursera
Universidad Nacional Autónoma de México

Business intelligence and data warehousing (Coursera)

Statistics & Data Analysis Data Science

Welcome to the specialization course Business Intelligence and Data Warehousing. This course will be completed on six weeks, it will be supported with videos and various documents that will allow you to learn in a very simple way how to identify, design and develop analytical information systems, such as Business Intelligence with a descriptive analysis on data warehouses. You will be able to understand the problem of integration and predictive analysis of high volume of unstructured data (big data) with data mining and the Hadoop framework.

Jul 27th 2026
5-12 Weeks
Data Mining SAP HANA Business Intelligence
Details
Manage Resources in Azure (Coursera) Coursera
Microsoft

Manage Resources in Azure (Coursera)

CS: Software Engineering

In this course, you will learn how to work with the Azure command line and web portal to create, manage, and control cloud-based resources. You will look at all three approaches to deploying cloud resources and how to make an informed decision about which one to leverage for your services. You'll also quickly look at the service models supported by Azure which can help you determine the services you should start with when planning out an Azure deployment. You will learn how to install the Azure CLI locally and use it to manage Azure resources. You will also use Azure PowerShell interactively for one-off tasks and write scripts to automate repeated tasks.

Aug 3rd 2026
5-12 Weeks
Microsoft Azure Azure Resources Management
Details
Business Intelligence Concepts, Tools, and Applications (Coursera) Coursera
University of Colorado System

Business Intelligence Concepts, Tools, and Applications (Coursera)

Statistics & Data Analysis Data Science

This is the fourth course in the Data Warehouse for Business Intelligence specialization. Ideally, the courses should be taken in sequence. In this course, you will gain the knowledge and skills for using data warehouses for business intelligence purposes and for working as a business intelligence developer. You’ll have the opportunity to work with large data sets in a data warehouse environment and will learn the use of MicroStrategy's Online Analytical Processing (OLAP) and Visualization capabilities to create visualizations and dashboards.

Aug 3rd 2026
5-12 Weeks
Data Analysis Decision Making Business Intelligence
Details
Data Mining Pipeline (Coursera) Coursera
University of Colorado Boulder

Data Mining Pipeline (Coursera)

Statistics & Data Analysis Data Science

This course introduces the key steps involved in the data mining pipeline, including data understanding, data preprocessing, data warehousing, data modeling, interpretation and evaluation, and real-world applications. Data Mining Pipeline can be taken for academic credit as part of CU Boulder’s Master of Science in Data Science (MS-DS) degree offered on the Coursera platform.

Aug 3rd 2026
4 Weeks
Data Modeling Data Mining Data Warehousing
Details
Deploying Microservices to Kubernetes using Azure DevOps (Coursera) Coursera
Whizlabs

Deploying Microservices to Kubernetes using Azure DevOps (Coursera)

CS: Information & Technology

Kubernetes is open-source, and its container orchestration benefits enable automation of various tasks such as deployment, management, and scaling of container-based applications. Presently, you can find various cloud-based applications using Kubernetes workloads. Since the Azure cloud provides ease of running Kubernetes alongside ease of scalability and management of microservices with higher availability, it is one of the foremost choices of all enterprises for DevOps transformation. You can utilize the opportunity to improve your expertise in deploying microservices in Kubernetes and capitalize on many career options.

Aug 17th 2026
3 Weeks
Node.js DevOps Azure
Details