Microsoft DP-900 : Azure Data Fundamentals

Paths

Microsoft DP-900 : Azure Data Fundamentals

Authors: Henry Been, Emilio Melo, Niraj Joshi, Ifedayo Bamikole, Mohit Batra, Nikola Ilic, Pinal Dave, Viktor Suha, Mihaela Danci, JS Padoan, Thomas LeBlanc

This path will prepare you for Microsoft DP-900 Azure Data Fundamentals Certification.

Core data concepts Understand relational data workload on Azure Understand non-relational workload on Azure Understand an analytics workload on Azure

Pre-requisites

Data Literacy

Beginner

In this section, you will learn basic skills required for working with cloud data services. You will be able to identify and appraise Microsoft Azure Data offerings, such AWS Data Factory, HDInsight, DataBricks and Synapse Analytics.

Getting Started with Azure Data Workloads

by Henry Been

May 20, 2021 / 42m

42m

Start Course
Description

Are you wondering how to get started in the field of data? Do you want to build a foundational understanding of types of data and data workloads? In this course, Getting Started with Azure Data Workloads, you’ll learn to differentiate between different types of data, databases, and data workloads. First, you’ll explore the difference between structured and unstructured data. Next, you’ll discover different types of databases and data workloads. Finally, you’ll learn how to differentiate between batch data and streaming data. When you’re finished with this course, you’ll be able to decide if a problem is best solved using batch data or streaming data, and you'll have the skills and knowledge to become a successful data engineer.

Table of contents
  1. Course Overview
  2. Types of Data, Databases, and Workloads
  3. Batch Data and Streaming Data

Data Literacy: Essentials of Azure Data Factory

by Emilio Melo

Apr 8, 2021 / 35m

35m

Start Course
Description

Data Engineering is one of the hottest topics on the IT industry at the moment, as the velocity, volume, and variety of data nowadays require skills beyond just traditional ETL. The DP-900 exam, as one of the Microsoft certifications on the data platform, is a good entry point for the area. In this course, Data Literacy: Essentials of Azure Data Factory, you’ll learn the main concepts of Data Factory needed for the exam. First, you’ll explore important concepts such as pipelines and activities. Next, you’ll discover other key components of Azure Data Factory, such as integration runtimes and triggers. Finally, you’ll learn how data factory can be used for data ingestion and processing. When you’re finished with this course, you’ll have the skills and knowledge of Azure Data Factory needed to proceed with the DP-900 exam.

Table of contents
  1. Course Overview
  2. Understanding Azure Data Factory Components

Data Literacy: Essentials of Azure HDInsight

by Niraj Joshi

Mar 23, 2021 / 20m

20m

Start Course
Description

Hadoop is an excellent framework to manage and process big data, but it comes with its own challenges which get resolved by the state-of-the-art managed service of Azure Cloud called HDInsight. In this course, Data Literacy: Essentials of Azure HDInsight, you’ll learn the basics of Hadoop and the challenges in Hadoop that could be overcome by HDInsight. First, you’ll explore what big data is. Next, you’ll discover the mechanism to store these huge chunks of data. Finally, you’ll learn how to create an HDInsight scalable cluster on Azure. When you’re finished with this course, you’ll have the skills and knowledge of what a data lake architecture is and how to create and manage it on a cloud like Azure.

Table of contents
  1. Course Overview
  2. Evaluating the Benefits of Using Azure HDInsight
  3. Summarizing the Brief Architecture of HDInsight
  4. Analyzing Multiple Cluster Types in HDInsight

Data Literacy: Essentials of Azure Databricks

by Ifedayo Bamikole

Apr 27, 2021 / 23m

23m

Start Course
Description

There are different solutions data professionals are trying to create and it is important to understand what tool is right for the job. In this course, Data Literacy: Essential of Azure DataBricks, you’ll learn about the different components that make up Azure DataBricks. First, you’ll explore its history and its relationship to common data solutions like Big Data, Machine Learning and Spark. Next, you’ll discover what the Azure DataBricks workspace is and how data can be ingested into it. Finally, you’ll learn about the list of capabilities within the workspace and how it integrates with other data tools. When you’re finished with this course, you’ll have the skills and knowledge of Azure DataBricks as a tool to create Big Data and Machine Learning Solutions.

Table of contents
  1. Course Overview
  2. Key Components of Azure Databricks
  3. Capabilities of Azure Databricks

Data Literacy: Essentials of Azure Synapse Analytics

by Mohit Batra

Jun 15, 2021 / 41m

41m

Start Course
Description

Azure Synapse Analytics is a unified & integrated platform for building analytical solutions. In this course, Data Literacy: Essentials of Azure Synapse Analytics, you’ll learn about the Azure Synapse Analytics platform and it will cover the objectives of the Azure DP-900 exam, related to Azure Synapse. First, you’ll see various components and their roles in Azure Synapse Analytics, and how it can be used to build a Modern Data Warehouse architecture. Next, you’ll learn how you can set up the Synapse workspace. Followed by this, you'll discover how to ingest and transform data using Synapse Pipelines. Then, you'll learn how to use different compute options, like Dedicated SQL Pools and Apache Spark Pools in Synapse to transform the data. Finally, you'll see how to model and serve data using Serverless SQL Pool. By the end of this course, you’ll have the skills and knowledge of Azure Synapse Analytics needed to get started on the platform.

Table of contents
  1. Course Overview
  2. Introduction to Azure Synapse Analytics
  3. Working with Azure Synapse Analytics

Intermediate

In this section, you will explore database concepts and their usage in a cloud environment. Learn the basic concepts for relational and non-relational data. Explore the databases supported by Azure.

Understanding Relational Data with Azure

by Nikola Ilic

May 6, 2021 / 1h 8m

1h 8m

Start Course
Description

Are you a seasoned data professional heading towards a cloud environment? Do you have profound SQL knowledge, but you're not sure how it can be applied in Azure Data Services? Or do you simply want to acquire the skills necessary to successfully pass the DP-900 exam? In this course, Understanding Relational Data with Azure, you’ll gain the ability to identify key concepts and features in the Azure relational ecosystem. First, you’ll explore the main characteristics of OLTP and OLAP systems. Next, you’ll discover the difference between various Azure delivery models, such as PaaS, IaaS, and SaaS. You'll also understand key characteristics of various relational Data Services within Azure, namely Azure SQL Database, Azure DB for MySQL, and Azure DB for PostgreSQL.

Finally, you’ll learn how to connect and query relational data from Azure SQL Database, Azure DB for MySQL, and Azure DB for PostgreSQL. When you’re finished with this course, you’ll have the foundational understanding of relational data in Azure that will enable you to make a smooth transition from on-prem to a cloud environment, and get you ready for the DP-900 exam.

Table of contents
  1. Course Overview
  2. Understand Core Concepts of Relational Data Workloads
  3. Understand Different Delivery Models in Azure
  4. Explore Relational Data Services in Azure
  5. Querying Azure SQL Database

Understanding Non-relational Data with Azure

by Pinal Dave

Mar 10, 2021 / 56m

56m

Start Course
Description

Non-relational data is an asset that can be utilized in Azure.mIn this course, Understanding Non-relational Data with Azure, you’ll learn about various non-relational data stores and their use cases.

First, you’ll explore all available non-relational data stores like Azure Table Storage, Azure Blob Storage, Azure File Storage and Azure Cosmos DB.

Next, you’ll discover advantages and challenges in implementing various non-relational workloads on data stores. Finally, you’ll learn how time series works with Azure as well as CSV and JSON files.

By the end of this course, you’ll have the skills and knowledge of non-relational data-stores available on the Azure platform needed to analyze your non-relational workload.

Table of contents
  1. Course Overview
  2. Analyzing Non-relational Data Stores
  3. Working with Time Series Data, JSON, and CSV Files

Advanced

In this section, you will explore data services such as Azure Data Studio, Power BI, and Azure Cosmos DB. You will explore querying data through cloud data solutions offered by Azure.

Data Literacy : Essentials of Azure Data Studio

by Viktor Suha

Apr 1, 2021 / 33m

33m

Start Course
Description

Getting data and working with data from an ever increasing number of data sources have become paramount for the developer. In this course, Data Literacy: Essentials of Azure Data Studio, you’ll learn how to connect to different databases, both on-premises and in the cloud, then run your SQL queries from a lightweight, cross-platform and open source client tool called Azure Data Studio. First, you’ll explore what Azure Data Studio is, what capabilities it has, what you can use it for, and how it compares to SQL Server Management Studio. Next, you’ll discover how to download and install this tool to start working with your data. Finally, you’ll learn what the differences between Data Manipulation Language and Data Definition Language SQL statements are, how to run your SQL queries, how to manage database connections to SQL Server, Azure SQL Database or PostgreSQL, and what notebooks are. When you’re finished with this course, you’ll have the skills and knowledge of using Azure Data Studio to query and work with your data from different data sources.

Table of contents
  1. Course Overview
  2. Understanding Azure Data Studio
  3. Querying Data with Azure Data Studio

Data Literacy: Essentials of Power BI

by Mihaela Danci

Apr 22, 2021 / 39m

39m

Start Course
Description

Power BI can empower you to uncover trends and patterns hidden within your data, enabling you to make data-driven decisions.

In this course, Data Literacy: Essentials of Power BI, you’ll learn to consume and create charts using Power BI:

  1. discover the key features of Power BI
  2. explore interactive and paginated reports
  3. learn how to build and share content with your colleagues
When you’re finished with this course, you’ll have the skills and knowledge to navigate and design Power BI reports.

Table of contents
  1. Course Overview
  2. Discovering Power BI
  3. Creating Content with Power BI

Data Literacy: Essentials of Azure Cosmos DB

by JS Padoan

Mar 18, 2021 / 32m

32m

Start Course
Description

Developing an efficient and reliable service on a global scale requires leveraging first-class cloud tools. In this course, Data Literacy: Essentials of Azure Cosmos DB, you’ll learn the major features of the tool and the pitfalls to avoid. First, you’ll explore planning an Azure Cosmos DB. Next, you’ll discover the different Azure Cosmos DB APIs. Finally, you’ll learn how to identify and manage data security components. When you’re finished with this course, you’ll have the skills and knowledge of Azure CosmoDB needed to successfully start to use and leverage that fantastic tool.

Table of contents
  1. Course Overview
  2. Planning Azure Cosmos DB
  3. Managing Azure Cosmos DB

Data Literacy: Understanding Data Warehousing with Azure

by Thomas LeBlanc

May 25, 2021 / 38m

38m

Start Course
Description

Azure has brought data warehousing to a new level. In this course, Data Literacy: Understanding Data Warehousing with Azure, you’ll learn the high-level overview of a modern data warehouse using Azure Data Warehouse services. First, you’ll explore Azure data storage options. Next, you’ll discover ingestion techniques using Azure Data Factory. Finally, you’ll learn how to produce insights with analytical, machine learning, and visualization tools. When you’re finished with this course, you’ll have the skills and knowledge to answer the Data Warehouse questions needed to pass the DP-900 exam.

Table of contents
  1. Course Overview
  2. Modern Data Warehouse Storage
  3. Flow of Data and Massive Parallel Processing
  4. Analyzing, Slicing, and Dicing Data
  5. Analytics with Azure Databricks