Release v2.0 - May 2023
The entire course has been updated and refreshed. All chapters have been re-recorded. This has been done to ensure that all contents now reflect the most recent changes to the services on the Azure platform.
Release v2.0 - May 2023
The entire course has been updated and refreshed. All chapters have been re-recorded. This has been done to ensure that all contents now reflect the most recent changes to the services on the Azure platform.
All course contents have also been aligned as per any changes to the course objectives.
Additional questions have been also added to the Practice Tests.
Release v1.0 Initial Release
This course is designed for students who want to attain the "Microsoft Certified: Azure Data Engineer Associate" certification
This course has contents for the Exam DP-203
The objectives covered in this course are
Design and implement data storage (40-45%)
Design and develop data processing (25-30%)
Design and implement data security (10-15%)
Monitor and optimize data storage and data processing (10-15%)
In this course students will learn about the various Azure services that pertain to Data Engineering. Some of the important aspects that students will learn include the following
What is the purpose of an Azure Data Lake Gen 2 storage account
Basics on Transact-SQL commands
How to work with Azure Synapse. This will include building a data warehouse into a dedicated SQL Pool.
How to build an ETL pipeline with the help of Azure Data Factory. There will be various scenarios on how to create mapping data flows.
How to stream data with the use of Azure Stream Analytics. You can see how SQL commands can be used for your streaming data.
Basics on the Scala programming language, and SPARK
How to work with SPARK, Scala in Azure Databricks. We will see how to work with Notebooks. We will also see how to stream data into Azure Databricks.
The different security measures and monitoring aspects to consider when working with Azure services
This chapters looks into the course structure
This chapters looks into a quick tour of the Azure Portal
This chapters looks into understanding data
This chapters looks into example of data storage
This chapters looks into a lab on Azure storage accounts
This chapters looks into Azure SQL databases
This chapters looks into a lab on an application connecting to an Azure storage account
This chapters looks into Azure Data Lake Gen-2 storage accounts
This chapters looks into a Lab on creating Azure Data Lake Gen2 storage accounts
This chapters looks into the different file formats
This chapters looks into using Power BI to view your data
This chapters looks into the costing aspect
This chapters looks has all the code for this section
This chapters looks into the section introduction
This chapters looks into the internals of a database
This chapters looks into setting up a new Azure SQL database
This chapters looks into the T-SQL Select clause
This chapters looks into the T-SQL Where clause
This chapters looks into the T-SQL Order by clause
This chapters looks into the T-SQL Aggregate functions
This chapters looks into the T-SQL Group by clause
This chapters looks into the T-SQL Having clause
This chapters looks into the primary and foreign keys
This chapters looks into the T-SQL creating tables
This chapters looks into the T-SQL Table joins
This chapters looks into the Section introduction
This chapters looks into Azure Synapse Analytics
This chapters looks into creating an Azure Synapse workspace
This chapters looks into the different compute options
This chapters looks into a lab on external tables - Part 1
This chapters looks into a lab on external tables - Part 2
This chapters looks into creating a SQL Pool
This chapters looks into loading data into a Dedicated SQL Pool
This chapters looks into copying data using the COPY command
This chapters looks into copying data using the COPY command with Parquet data
This chapters looks into loading data using Polybase
This chapters looks into designing a data warehouse
This chapters looks into dimension tables
This chapters looks into building a fact table
This chapters looks into building a dimension table
This chapters looks into transferring data into the SQL Pool
This chapters looks into Power BI for the star schema
This chapters looks into understanding Azure Synapse Architecture
This chapters looks into understanding table types
This chapters looks into understanding round-robin tables
This chapters looks into hash-distributed tables
This chapters looks into creating replicated tables
This chapters looks into designing your tables
This chapters looks into surrogate keys for dimension tables
This chapters looks into slowly changing dimensions
This chapters looks into reading JSON files
This chapters looks into windowing functions
This chapters looks into the case statement
This chapters looks into a quick note on what we are taking forward
This chapters looks into the Spark pool
This chapters looks into a section introduction
OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.
Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.
Find this site helpful? Tell a friend about us.
We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.
Your purchases help us maintain our catalog and keep our servers humming without ads.
Thank you for supporting OpenCourser.