Introduction to Microsoft Azure Synapse Analytics
In this course, you will learn how Azure Synapse Analytics enables you to perform different types of analytics through its’ components that can be used to build Modern Data Warehouses through to advanced analytical solutions. You will learn how Azure Synapse Analytics solves the issue of having a single service to fulfill the broad range of analytics requirements that organizations face today and take a tour of the core application used to interact with the various components of Azure Synapse Analytics.
Monthly Subscription Starting at AED 99 + VAT
- Level Professional
- Duration 8 hours
- Course by Microsoft
-
Offered by
About
In this course, you will learn how Azure Synapse Analytics enables you to perform different types of analytics through its’ components that can be used to build Modern Data Warehouses through to advanced analytical solutions. You will learn how Azure Synapse Analytics solves the issue of having a single service to fulfill the broad range of analytics requirements that organizations face today and take a tour of the core application used to interact with the various components of Azure Synapse Analytics. You will learn the various components of Azure Synapse Analytics that enable you to build your analytical solutions in one place. 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 fourth 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).Modules
Welcome to the course
-
1
Videos
-
2
Readings
-
1
Discussion
1
Discussions
- Meet and greet
1
Videos
- Introduction to the course
2
Readings
- Course syllabus
- How to be successful in this course
What is Azure Synapse Analytics
-
3
Videos
-
2
Assignment
2
Assignment
- Knowledge check
- Test prep
3
Videos
- What is Azure Synapse Analytics?
- How Azure Synapse Analytics works
- When to use Azure Synapse Analytics
Components of Azure Synapse Analytics
-
3
Videos
-
2
Readings
-
1
Plugin
-
3
Assignment
3
Assignment
- Exercise quiz
- Exercise quiz
- Knowledge check
3
Videos
- Create Azure Synapse Analytics workspace
- Describe Azure Synapse Analytics SQL
- Explain Apache Spark in Azure Synapse Analytics
2
Readings
- Exercise - Create and manage Azure Synapse Analytics workspace
- Exercise - Create pools in Azure Synapse Analytics
Build an analytical solution
-
2
Videos
-
3
Readings
-
3
Assignment
3
Assignment
- Exercise quiz
- Knowledge check
- Test prep
2
Videos
- Orchestrate data integration with Azure Synapse pipelines
- Module summary
3
Readings
- Exercise - Identifying Azure Synapse pipeline components
- Visualize your analytics with Power BI
- Understand hybrid transactional analytical processing with Azure Synapse Link
Explore Azure Synapse Studio
-
3
Videos
-
5
Readings
-
2
Assignment
2
Assignment
- Knowledge check
- Test prep
3
Videos
- Use Azure Synapse Studio
- Understand the Azure Synapse Analytical processes
- Module summary
5
Readings
- Explore the Data hub
- Explore the Develop hub
- Explore the Integrate hub
- Explore the Monitor hub
- Explore the Manage hub
Build a modern data warehouse
-
2
Videos
-
2
Readings
-
2
Assignment
2
Assignment
- Exercise quiz
- Knowledge check
2
Videos
- Describe a modern data warehouse
- Define a modern data warehouse architecture
2
Readings
- Exercise - Identify modern data warehouse architecture components
- Design ingestion patterns for a modern data warehouse
Work with data in a modern data warehouse
-
3
Videos
-
2
Readings
-
3
Assignment
3
Assignment
- Exercise quiz
- Knowledge check
- Test prep
3
Videos
- Understand data storage for a modern data warehouse
- Understand file formats and structure for a modern data warehouse
- Module summary
2
Readings
- Prepare and transform data with Azure Synapse Analytics
- Serve data for analysis with Azure Synapse Analytics
Course practice exam
-
1
Videos
-
1
Readings
-
1
Assignment
1
Assignment
- Course practice exam
1
Videos
- Course 4 recap
1
Readings
- About the Practice Exam
Course wrap up
-
1
Videos
-
1
Readings
-
1
Discussion
1
Discussions
- Reflect on learning
1
Videos
- Course summary
1
Readings
- Next steps
Auto Summary
Discover how Azure Synapse Analytics can transform your data solutions with this professional-level course on Coursera. Designed for data engineers and developers, this course is part of a 10-course Specialization aimed at preparing you for the Exam DP-203. Over 480 minutes, you'll explore the core components and advanced analytical capabilities of Azure Synapse, helping you build modern data warehouses and comprehensive analytics solutions. Ideal for those targeting expertise in Microsoft Azure data services. Available with a Starter subscription.
Microsoft