Course Overview:
In this course, students will gain foundational knowledge of core data concepts and related Microsoft Azure data services. Students will learn about core data concepts such as relational, non-relational, big data, and analytics, and build their foundational knowledge of cloud data services within Microsoft Azure. Students will explore fundamental relational data concepts and relational database services in Azure. They will explore Azure storage for non-relational data and the fundamentals of Azure Cosmos DB. Students will learn about large-scale data warehousing, real-time analytics, and data visualization.
Course Objectives:
• Identify common data formats
• Describe options for storing data in files
• Describe options for storing data in databases
• Describe characteristics of transactional data processing solutions
• Describe characteristics of analytical data processing solutions
• Identify common data professional roles.
• Identify common cloud services used by data professionals.
• Identify characteristics of relational data.
• Define normalization.
• Identify types of SQL statement.
• Identify common relational database objects.
• Identify options for Azure SQL services
• Identify options for open-source databases in Azure
• Provision a database service on Azure
• Describe features and capabilities of Azure blob storage
• Describe features and capabilities of Azure Data Lake Gen2
• Describe features and capabilities of Azure file storage
• Describe features and capabilities of Azure table storage
• Provision and use an Azure Storage account
• Describe key features and capabilities of Azure Cosmos DB
• Identify the APIs supported in Azure Cosmos DB
• Provision and use an Azure Cosmos DB instance
• Describe key features for data ingestion pipelines
• Identify common types of analytical data store and related Azure services
• Describe platform-as-a-service (PaaS) data analytics solutions in Azure
• Provision Azure Synapse Analytics and use it to ingest, process, and query data
• Describe features of Microsoft Fabric – a software-as-a-service (SaaS) solution for data analytics
• Use Microsoft Fabric to ingest and analyze data
• Compare batch and stream processing
• Describe common elements of streaming data solutions
• Describe features and capabilities of Azure Stream Analytics
• Describe features and capabilities of Azure Stream Analytics
• Describe features and capabilities of Spark Structured Streaming on Azure
• Describe features and capabilities of realtime analytics in Microsoft Fabric\
• Describe a high-level process for creating reporting solutions with Microsoft Power BI.
• Describe core principles of analytical data modeling.
• Identify common types of data visualization and their uses.
• Create an interactive report with Power BI Desktop.
Who Should Attend?
The audience for this course is individuals who want to learn the fundamentals of database concepts in a cloud environment, get basic skilling in cloud data services, and build their foundational knowledge of cloud data services within Microsoft Azure.
Course Prerequisites
There are no prerequisites for this course.
Course Content:
Module 1: Explore core data concepts
Introduction
Identify data formats
Explore file storage
Explore databases
Explore transactional data processing
Explore analytical data processing
Knowledge check
Summary
Module 2: Explore data roles and services
Introduction
Explore job roles in the world of data
Identify data services
Knowledge check
Summary
Module 3: Explore fundamental relational data concepts
Introduction
Understand relational data
Understand normalization
Explore SQL
Describe database objects
Knowledge check
Summary
Module 4: Explore relational database services in Azure
Introduction
Describe Azure SQL services and capabilities
Describe Azure services for open-source databases
Exercise: Explore Azure relational database services
Knowledge check
Summary
Module 5: Explore Azure Storage for non-relational dataIntroduction
Explore Azure blob storage
Explore Azure DataLake Storage Gen2
Explore Azure Files
Explore Azure Tables
Exercise: Explore Azure Storage
Knowledge check
Summary
Module 6: Explore fundamentals of Azure Cosmos DBIntroduction
Describe Azure Cosmos DB
Identify Azure Cosmos DB APIs
Exercise: Explore Azure Cosmos DB
Knowledge check
Summary
Module 7: Explore fundamentals of large-scale analytics
Introduction
Describe data warehousing architecture
Explore data ingestion pipelines
Explore analytical data stores
Explore platform-as-a-service (PaaS) solutions
Exercise: Explore data analytics in Azure with Azure Synapse Analytics
Explore Microsoft Fabric
Exercise: Explore Microsoft Fabric
Knowledge check
Summary
Module 8: Explore fundamentals of real-time analytics
Introduction
Understand batch and stream processing
Explore common elements of stream processing architecture
Explore Azure Stream Analytics
Exercise: Explore Azure Stream Analytics
Explore Apache Spark on Microsoft Azure
Exercise: Explore Spark Streaming in Azure Synapse Analytics
Explore Realtime Analytics in Microsoft Fabric
Exercise: Explore Realtime Analytics in Microsoft Fabric
Knowledge check
Summary
Module 9: Explore fundamentals of data visualization
Introduction
Describe Power BI tools and workflow
Describe core concepts of data modeling
Describe considerations for data visualization
Exercise – Explore fundamentals of data visualization with Power BI
Knowledge check
Summary