DP-203 : Microsoft Certified Azure Data Engineer Associate from Udemy

What's inside

Learning objectives

Pass the microsoft azure dp-203 azure data solutions test
Learn basic data engineering & database concept
Learn various storage product like azure storage, queue, file, table storage
Build structured data solution with various sql database options
Store semi-structured data with cosmosdb
Develop etl, elt solution with azure data factory
Analyze data with data ware housing system - synapse analytics
Azure data factory control flow activities

Synapse sql in azure synapse analytics
Apache spark in azure synapse analytics
Azure databricks
Delta lake & data warehouse in azure databricks
Azure stream analytics
Show more
Show less

Pass the microsoft azure dp-203 azure data solutions test
Learn basic data engineering & database concept
Learn various storage product like azure storage, queue, file, table storage
Build structured data solution with various sql database options
Store semi-structured data with cosmosdb
Develop etl, elt solution with azure data factory
Analyze data with data ware housing system - synapse analytics
Azure data factory control flow activities
Synapse sql in azure synapse analytics
Apache spark in azure synapse analytics
Azure databricks
Delta lake & data warehouse in azure databricks
Azure stream analytics
Show more
Show less

Syllabus

Introduction

Course Introduction

Important - Udemy Tips & Review Update

Course Materials

Basics of Data

Structured vs Unstructured vs Semi-Structured Data

Batch vs Streaming Data

OLTP vs OLAP

Data Lake vs Data Warehouse

Data Engineering Workflow

Section Quiz

Azure Basic Services

Create Azure Account

Account, Subscription, Resources Groups & Resources

Different Ways to Access Azure

Azure Portal Walkthrough

Getting Ready with Azure CLI

Azure Cloud Shell

Create VM from Portal

Create VM From CLI

-------------------- Part 1: Azure Storage Services --------------------

Welcome to Part 1: Azure Storage Services

Azure Storage

Different Services for Azure Storage

Azure Storage Platform

Provision Azure Storage Account

Explore Azure Storage Account

What is Azure Blob Storage

Explore Azure Blob Storage Part 1

Explore Azure Blob Storage Part 2

Data Replication in Storage

Manual Failover

Blob Access Tier

Secure Storage Account

Azure Table

Assignment : Azure Table

Azure Queue

Azure File Share

Azure Disk Storage

Introduction to Azure Data Lake Gen 2

Lifecycle Management

Assignment : Lifecycle management

Azure Storage Explorer

Manage Azure Storage via Azure CLI Part - 1

Manage Azure Storage via Azure CLI Part - 2

Manage Azure Storage via Azure CLI Part - 3

Manage Azure Storage via Azure CLI Part - 4

Manage Azure Storage via Azure CLI Part - 5

Section Quiz 2

Azure SQL Database

Introduction to Azure SQL Database

Azure SQL IaaS & PaaS Offering

Different Paas Deployment

[Hands-On] Azure SQL Database Part 1

[Hands-On] Azure SQL Database Part 2

[Hands-On] Azure SQL Database Part 3

[Hands-On] Azure SQL Database Part 4

SQL Pricing Model & Service Tier

Manage Azure SQL via Azure CLI Part - 1

Manage Azure SQL via Azure CLI Part - 2

Azure NoSQL Solution : CosmosDB

Introduction to Azure Cosmos DB

APIs in Azure Cosmos DB

Azure Cosmos DB for NoSQL

Components of Azure Cosmos DB for NoSQL

Azure NoSQL Solution : CosmosDB Part 2

Lab1: Creating Azure Cosmos DB Account for NoSQL Part 1

Lab1: Creating Azure Cosmos DB Account for NoSQL Part 2

Lab1: Creating Azure Cosmos DB Account for NoSQL Part 3

Overview: Azure Cosmos DB Account for NoSQL

Lab 2: Creating a Database Part 1

Lab 2: Creating a Database Part 2

Lab 3: Creating a Container

Lab 4: Adding Items to Container

Request Units

Understand Throughput

Cost Management

Cosmos DB - Horizontally Scalable

Partition and Partition Key

Single vs Cross Partition

Avoid Hot Partitions

Time-to-Live (TTL)

Serverless Capacity Mode

Serverless vs Provisioned Throughput

Autoscale vs Standard Throughput

Azure CosmosDB Pricing

-------------------- Part 2: Azure Data Factory --------------------

Welcome to Part 2: Azure Data Factory

Azure Data Factory: Getting Started

Introduction to Azure Data Factory

Create Data Factory Account

Azure Data Factory Studio Overview

Pipelines and Activities

Create Storage Account & Containers

Introduction to Linked Services & Dataset

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Develops a strong foundation for learners considering Microsoft Azure data engineering or who work in that field, including designing, implementing, and managing data solutions

Taught by expert instructors with recognized standing in the field of Microsoft Azure data engineering

Covers diverse Microsoft Azure data services like Azure Data Factory, Blob Storage, HDInsight, and SQL Data Warehouse, which are highly relevant in industry

Helps learners prepare for the Microsoft Azure DP-203 Azure Data Solutions test in a comprehensive manner, which is useful for career advancement

Includes real-world scenarios and exercises that aid in practical application of concepts and skills

Appropriate for learners with a background in basic data engineering and database principles

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in DP-203 : Microsoft Certified Azure Data Engineer Associate with these activities:

Review cloud storage fundamentals

Show steps

Brush up on the basics of cloud storage to ensure a strong foundation for this course.

Browse courses on Azure Storage

Show steps

Review key concepts of cloud storage, such as object storage and block storage.
Familiarize yourself with different cloud storage providers and their offerings.

Show all one activities

Career center

Learners who complete DP-203 : Microsoft Certified Azure Data Engineer Associate will develop knowledge and skills that may be useful to these careers:

Data Engineer

A Data Engineer is responsible for implementing and maintaining the infrastructure that supports data-driven applications. This course can help you build a strong foundation in Azure Data Engineering, which is a critical skill for Data Engineers. The course covers a wide range of topics, including data storage, processing, integration, orchestration, and security. By taking this course, you will gain the knowledge and skills you need to succeed as a Data Engineer.

See salaries and explore the career path for Data Engineer

Data Architect

A Data Architect designs and builds the data infrastructure that supports an organization's data needs. This course can help you develop the skills you need to become a successful Data Architect. The course covers a wide range of topics, including data modeling, data warehousing, and data integration. By taking this course, you will gain the knowledge and skills you need to design and build data infrastructure that meets the needs of your organization.

See salaries and explore the career path for Data Architect

Big Data Engineer

A Big Data Engineer works with large and complex datasets to extract insights and make informed decisions. This course can help you develop the skills you need to become a successful Big Data Engineer. The course covers a wide range of topics, including data storage, processing, and analysis. By taking this course, you will gain the knowledge and skills you need to work with big data and extract valuable insights.

See salaries and explore the career path for Big Data Engineer

Cloud Architect

A Cloud Architect designs and builds cloud-based solutions. This course can help you develop the skills you need to become a successful Cloud Architect. The course covers a wide range of topics, including cloud computing concepts, cloud services, and cloud security. By taking this course, you will gain the knowledge and skills you need to design and build cloud-based solutions that meet the needs of your organization.

See salaries and explore the career path for Cloud Architect

Data Scientist

A Data Scientist uses data to solve problems and make informed decisions. This course can help you develop the skills you need to become a successful Data Scientist. The course covers a wide range of topics, including data analysis, machine learning, and artificial intelligence. By taking this course, you will gain the knowledge and skills you need to use data to solve problems and make informed decisions.

See salaries and explore the career path for Data Scientist

Software Engineer

A Software Engineer designs, develops, and maintains software applications. This course can help you develop the skills you need to become a successful Software Engineer. The course covers a wide range of topics, including software development concepts, programming languages, and software testing. By taking this course, you will gain the knowledge and skills you need to design, develop, and maintain software applications.

See salaries and explore the career path for Software Engineer

Database Administrator

A Database Administrator manages and maintains databases. This course can help you develop the skills you need to become a successful Database Administrator. The course covers a wide range of topics, including database design, database administration, and database security. By taking this course, you will gain the knowledge and skills you need to manage and maintain databases.

See salaries and explore the career path for Database Administrator

Business Analyst

A Business Analyst analyzes business processes and makes recommendations for improvement. This course can help you develop the skills you need to become a successful Business Analyst. The course covers a wide range of topics, including business analysis techniques, data analysis, and problem solving. By taking this course, you will gain the knowledge and skills you need to analyze business processes and make recommendations for improvement.

See salaries and explore the career path for Business Analyst

Project Manager

A Project Manager plans, executes, and closes projects. This course can help you develop the skills you need to become a successful Project Manager. The course covers a wide range of topics, including project management concepts, project planning, and project execution. By taking this course, you will gain the knowledge and skills you need to plan, execute, and close projects.

See salaries and explore the career path for Project Manager

Quality Assurance Analyst

A Quality Assurance Analyst tests and evaluates software applications to ensure they meet quality standards. This course can help you develop the skills you need to become a successful Quality Assurance Analyst. The course covers a wide range of topics, including software testing concepts, testing techniques, and quality assurance standards. By taking this course, you will gain the knowledge and skills you need to test and evaluate software applications.

See salaries and explore the career path for Quality Assurance Analyst

Technical Writer

A Technical Writer creates and maintains technical documentation. This course can help you develop the skills you need to become a successful Technical Writer. The course covers a wide range of topics, including technical writing concepts, documentation tools, and information architecture. By taking this course, you will gain the knowledge and skills you need to create and maintain technical documentation.

See salaries and explore the career path for Technical Writer

Data Analyst

A Data Analyst analyzes data and makes recommendations for improvement. This course can help you develop the skills you need to become a successful Data Analyst. The course covers a wide range of topics, including data analysis techniques, data visualization, and statistical analysis. By taking this course, you will gain the knowledge and skills you need to analyze data and make recommendations for improvement.

See salaries and explore the career path for Data Analyst

Information Security Analyst

An Information Security Analyst protects an organization's data and information systems from unauthorized access, use, disclosure, disruption, modification, or destruction. This course can help you develop the skills you need to become a successful Information Security Analyst. The course covers a wide range of topics, including information security concepts, information security threats, and information security controls. By taking this course, you will gain the knowledge and skills you need to protect an organization's data and information systems.

See salaries and explore the career path for Information Security Analyst

Network Administrator

A Network Administrator manages and maintains computer networks. This course can help you develop the skills you need to become a successful Network Administrator. The course covers a wide range of topics, including network design, network protocols, and network security. By taking this course, you will gain the knowledge and skills you need to manage and maintain computer networks.

See salaries and explore the career path for Network Administrator

Systems Administrator

A Systems Administrator manages and maintains computer systems. This course can help you develop the skills you need to become a successful Systems Administrator. The course covers a wide range of topics, including system administration concepts, operating systems, and system security. By taking this course, you will gain the knowledge and skills you need to manage and maintain computer systems.

See salaries and explore the career path for Systems Administrator

DP-203

Microsoft Certified Azure Data Engineer Associate

14 deals to help you save

What's inside

Learning objectives

Syllabus

Good to know

Save this course

Activities

Career center

Reading list

Share

Similar courses