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

MLOps Platforms: Amazon SageMaker and Azure ML (Coursera) Coursera
Duke University

MLOps Platforms: Amazon SageMaker and Azure ML (Coursera)

Data Science

In MLOps Platforms: Amazon SageMaker and Azure ML you will learn the necessary skills to build, train, and deploy machine learning solutions in a production environment using two leading cloud platforms: Amazon Web Services (AWS) and Microsoft Azure. This course is also a great resource for individuals looking to prepare for AWS or Azure machine learning certifications or who are working (or seek to work) as data scientists, software engineers, software developers, data analysts, or other roles that use machine learning.

Aug 3rd 2026
5-12 Weeks
Machine Learning EDA Exploratory Data Analysis
Details
Azure: Network Security (Coursera) Coursera
Whizlabs

Azure: Network Security (Coursera)

CS: Information & Technology

Azure: Network Security Course is the Second course of the Exam Prep AZ-500: Microsoft Azure Security Engineer Associate Specialization. This course is designed to describe the concepts of Azure Network Security related to multiple Azure services. This course includes an overview of concepts like planning and implementation of security for virtual networks, private access to Azure resources, and public access to Azure resources.

Aug 3rd 2026
2 Weeks
Security Network Security Azure
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
Azure: Identity and Access Management (Coursera) Coursera
Whizlabs

Azure: Identity and Access Management (Coursera)

CS: Information & Technology

Azure: Identity and Access Management Course is the first course of the Exam Prep AZ-500: Microsoft Azure Security Engineer Associate Specialization. This course is designed to describe the basics of Azure Security related to using multiple Azure services. This course includes an overview of Managing identities in Azure AD, Managing authentication and authorization by using Azure AD, and management of application access in Azure AD. This course is divided into two modules and Lessons and Video Lectures further segment each module.

Aug 3rd 2026
2 Weeks
Identity Azure Azure AD
Details
Database Management Essentials (Coursera) Coursera
University of Colorado System

Database Management Essentials (Coursera)

CS: Software Engineering

Database Management Essentials provides the foundation you need for a career in database development, data warehousing, or business intelligence, as well as for the entire Data Warehousing for Business Intelligence specialization. In this course, you will create relational databases, write SQL statements to extract information to satisfy business reporting requests, create entity relationship diagrams (ERDs) to design databases, and analyze table designs for excessive redundancy.

Jul 27th 2026
5-12 Weeks
SQL MySQL Business Intelligence
Details
Exam Prep DP-300: Azure Database Administrator Associate (Coursera) Coursera
Whizlabs

Exam Prep DP-300: Azure Database Administrator Associate (Coursera)

CS: Information & Technology

Database administration is one of the basic necessities of every enterprise. The growth of cloud and On-premises relational databases continues to create the need for professional database administrators. Therefore, an updated certification such as DP-300 could open up favorable options for employment of database administrators.

Aug 17th 2026
5-12 Weeks
SQL Cloud Computing Azure SQL Database
Details
Natural Language Processing in Microsoft Azure (Coursera) Coursera
Microsoft

Natural Language Processing in Microsoft Azure (Coursera)

Data Science

Natural language processing supports applications that can see, hear, speak with, and understand users. Using text analytics, translation, and language understanding services, Microsoft Azure makes it easy to build applications that support natural language. In this course, you will learn how to use the Text Analytics service for advanced natural language processing of raw text for sentiment analysis, key phrase extraction, named entity recognition, and language detection.

Aug 3rd 2026
3 Weeks
NLP Microsoft Azure Natural Language Processing
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
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