Module 1: Explore core data concepts
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.
Lesson
- Core data concepts
- Data roles and Services
After completing this module, students will be able to:
- Identify how data is defined and stored
- Identify characteristics of relational and non-relational data
- Describe and differentiate data workloads
- Describe and differentiate batch and streaming data
- Identify common data professional roles
- Identify common cloud services used by data professionals
Module 2: Explore fundamentals of relational data in Azure
Students will explore fundamental relational data concepts and relational database services in Azure.
Lesson
- Explore relational data offerings in Azure
- Explore Azure services for relational data
Lab : Provision Azure relational database services
After completing this module, students will be able to:
- 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
Module 3: Explore fundamentals of non-relational data in Azure
Students will explore Azure storage for non-relational data and the fundamentals of Azure Cosmos DB.
Lesson
- Fundamentals of Azure Storage
- Fundamentals of Azure Cosmos DB
Lab : Explore Azure Storage
Lab : Explore Azure Cosmos DB
After completing this module, students will be able to:
- 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
Module 4: Explore fundamentals of data analytics
Students will learn about modern data warehousing, real-time analytics, and data visualization.
Lesson
- Modern data warehousing
- Streaming and real-time analytics
- Data visualization
Lab : Explore Azure Synapse Analytics
Lab : Analyze streaming data
Lab : Visualize data with Power BI
After completing this module, students will be able to:
- Identify common elements of a modern data warehousing solution
- Describe key features for data ingestion pipelines
- Identify common types of analytical data store and related Azure services
- Provision Azure Synapse Analytics and use it to ingest, process, and query 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 Spark Structured Streaming on Azure
- Describe features and capabilities of Azure Synapse Data Explorer
- 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