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

Data Warehousing and Business Intelligence (Coursera) Coursera
University of California, Irvine

Data Warehousing and Business Intelligence (Coursera)

This course builds on “The Nature of Data and Relational Database Design” to extend the process of capturing and manipulating data through data warehousing and data mining. Once the transactional data is processed through ETL (Extract, Transform, Load), it is then stored in a data warehouse for use in managerial decision making. Data mining is one of the key enablers in the process of converting data stored in a data warehouse into actionable insight for better and faster decision making.

Sep 21st 2026
4 Weeks
Data Engineering Capstone Project (Coursera) Coursera
IBM

Data Engineering Capstone Project (Coursera)

In this course you will apply a variety of data engineering skills and techniques you have learned as part of the previous courses in the IBM Data Engineering Professional Certificate. You will assume the role of a Junior Data Engineer who has recently joined the organization and be presented with a real-world use case that requires a data engineering solution.

Sep 21st 2026
5-12 Weeks
Database Management Essentials (Coursera) Coursera
University of Colorado System

Database Management Essentials (Coursera)

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.

Sep 21st 2026
5-12 Weeks
Create Machine Learning Models in Microsoft Azure (Coursera) Coursera
Microsoft

Create Machine Learning Models in Microsoft Azure (Coursera)

Machine learning is the foundation for predictive modeling and artificial intelligence. If you want to learn about both the underlying concepts and how to get into building models with the most common machine learning tools this path is for you. In this course, you will learn the core principles of machine learning and how to use common tools and frameworks to train, evaluate, and use machine learning models. This course is designed to prepare you for roles that include planning and creating a suitable working environment for data science workloads on Azure.

Sep 21st 2026
3 Weeks
Artificial Intelligence on Microsoft Azure (Coursera) Coursera
Microsoft

Artificial Intelligence on Microsoft Azure (Coursera)

Whether you're just beginning to work with Artificial Intelligence (AI) or you already have AI experience and are new to Microsoft Azure, this course provides you with everything you need to get started. Artificial Intelligence (AI) empowers amazing new solutions and experiences; and Microsoft Azure provides easy to use services to help you build solutions that seemed like science fiction a short time ago; enabling incredible advances in health care, financial management, environmental protection, and other areas to make a better world for everyone.

Sep 21st 2026
1 Week
Manage Identities and Governance in Azure (Coursera) Coursera
Whizlabs

Manage Identities and Governance in Azure (Coursera)

Manage Identities and Governance in Azure Course is the first course of the Exam Prep AZ-104: Microsoft Azure Administrator Associate Specialization. This course is designed to describe the basics of Azure Administrator related to using multiple Azure services. This course includes an overview of a basic Introduction to Azure services, Azure AD, Access Control Management, RBAC, Azure Subscriptions, and Governance. This course is basically divided into four modules and Lessons and Video Lectures further segment each module.

Sep 21st 2026
3 Weeks
Deploy a website with Azure Virtual Machines (Coursera) Coursera
Microsoft

Deploy a website with Azure Virtual Machines (Coursera)

If your web hosting requirements aren't directly supported by the Azure Web app platform, you can leverage virtual machines to customize and control every aspect of ta webserver. In this course, you will learn how to create, configure, and manage virtual machines on Linux and Windows that host web apps. You will look at the decisions made before creating a VM, the options to create and manage the VM, and the extensions and services you use to manage your VM. You will learn how to create a Linux virtual machine using the Azure portal.

Sep 21st 2026
5-12 Weeks
Connect Your Services with Microsoft Azure Service Bus (Coursera) Coursera
Microsoft

Connect Your Services with Microsoft Azure Service Bus (Coursera)

Azure lets you create applications composed of various components: website front-ends, back-end services, and triggered functions that perform compute-on-demand services. Azure also includes various communication strategies to let these various components pass data to each other. In this course, you will learn how to leverage these communication services to create scalable, efficient solutions out of testable components.

Sep 21st 2026
5-12 Weeks
Microsoft Azure Machine Learning for Data Scientists (Coursera) Coursera
Microsoft

Microsoft Azure Machine Learning for Data Scientists (Coursera)

Machine learning is at the core of artificial intelligence, and many modern applications and services depend on predictive machine learning models. Training a machine learning model is an iterative process that requires time and compute resources. Automated machine learning can help make it easier. In this course, you will learn how to use Azure Machine Learning to create and publish models without writing code.

Sep 21st 2026
4 Weeks
Business intelligence and data warehousing (Coursera) Coursera
Universidad Nacional Autónoma de México

Business intelligence and data warehousing (Coursera)

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.

Sep 21st 2026
5-12 Weeks
Computer Vision in Microsoft Azure (Coursera) Coursera
Microsoft

Computer Vision in Microsoft Azure (Coursera)

In Microsoft Azure, the Computer Vision cognitive service uses pre-trained models to analyze images, enabling software developers to easily build applications"see" the world and make sense of it. This ability to process images is the key to creating software that can emulate human visual perception. In this course, you'll explore some of these capabilities as you learn how to use the Computer Vision service to analyze images.

Sep 21st 2026
3 Weeks