This course introduces students to fundamental database concepts within cloud computing environments and provides foundational knowledge of cloud data services in Microsoft Azure. You will learn to identify and describe core data concepts, including relational databases, non-relational databases, big data, and analytics solutions, then explore how these technologies are implemented using Microsoft Azure's cloud infrastructure. The course covers the roles, responsibilities, and tasks of data professionals in modern organizations. You will examine relational data offerings, provisioning and deploying relational database solutions, and techniques for querying relational data through Azure cloud services. Additionally, you will explore non-relational data offerings, methods for deploying non-relational databases and data stores in Azure, and the various data processing options available for building analytics solutions. The course includes coverage of Azure Synapse Analytics, Azure Databricks, and Azure HDInsight, as well as Power BI fundamentals, including its core building blocks and their integration.
Audience profile:
This course is designed for individuals who want to build foundational knowledge of database concepts in cloud environments, develop basic skills in cloud data services, and prepare for work with Microsoft Azure data solutions.
Job role: Data Engineer, Database Administrator
Preparation for exam: DP-900
Skills gained:
- Describe core data concepts in Azure
- Explain concepts of relational data in Azure
- Explain concepts of non-relational data in Azure
- Identify components of a modern data warehouse in Azure
Course outline
Module 1: Explore core data concepts
Students learn the fundamentals of database concepts in cloud environments and build foundational knowledge of cloud data services in Microsoft Azure. You will identify and describe core data concepts such as relational, non-relational, big data, and analytics, and explore how these technologies are implemented with Azure. You will also examine the various roles, tasks, and responsibilities that data professionals perform.
Lessons
- Explore core data concepts
- Explore roles and responsibilities in the world of data
- Describe concepts of relational data
- Explore concepts of non-relational data
- Explore concepts of data analytics
Module 2: Explore relational data in Azure
You will gain foundational knowledge of cloud data services within Microsoft Azure, focusing on relational data solutions. You will explore relational data offerings available in Azure, learn about provisioning and deploying relational database solutions, and master techniques for querying relational data through Azure cloud services.
Lessons
- Explore relational data offerings in Azure
- Explore provisioning and deploying relational database offerings in Azure
- Query relational data in Azure
Module 3: Explore non-relational data in Azure
You will build foundational knowledge of cloud data services and explore non-relational data solutions available in Microsoft Azure. You will examine non-relational data offerings, learn provisioning and deployment techniques for non-relational databases, and manage various non-relational data stores within Azure.
Lessons
- Explore non-relational data offerings in Azure
- Explore provisioning and deploying non-relational data services on Azure
- Manage non-relational data stores in Azure
Module 4: Explore modern data warehouse analytics in Azure
You will explore the data processing and analytics capabilities available in Microsoft Azure. This module covers processing options for building data analytics solutions, including Azure Synapse Analytics, Azure Databricks, and Azure HDInsight. You will also learn Power BI fundamentals, including how its core building blocks work together to create business intelligence solutions.
Lessons
- Examine components of a modern data warehouse
- Explore data ingestion in Azure
- Explore data storage and processing in Azure
- Get started building with Power BI
