Introduction to Microsoft Azure Data (DP-900T00)
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.
AUDIENCE PROFILE
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.
About the course
COURSE OUTLINE
MODULE 01 Introduction to Microsoft Azure Data core data concepts
- Explore core data concepts
- 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.
- Explore data roles and services
- Identify common data professional roles.
- Identify common cloud services used by data professionals.
MODULE 02 Introduction to Microsoft Azure Data relational data in Azure
- Explore fundamental relational data concepts
- Identify characteristics of relational data.
- Define normalization.
- Identify types of SQL statement.
- Identify common relational database objects.
- Explore relational database services in Azure
- Identify options for Azure SQL services.
- Identify options for open-source databases in Azure.
- Provision a database service on Azure.
MODULE 03 Introduction to Microsoft Azure Data non-relational data in Azure
- Explore Azure Storage for non-relational data
- Describe features and capabilities of Azure blob storage.
- Describe features and capabilities of Azure Data Lake Storage Gen2.
- Describe features and capabilities of Microsoft OneLake in Fabric.
- Describe features and capabilities of Azure file storage.
- Describe features and capabilities of Azure table storage.
- Provision and explore an Azure Storage account.
- Explore fundamentals of Azure Cosmos DB
- Describe key features and capabilities of Azure Cosmos DB.
- Identify the APIs supported in Azure Cosmos DB.
- Provision and explore an Azure Cosmos DB database.
MODULE 04 Introduction to Microsoft Azure Data analytics in Azure
- Explore fundamentals of large-scale analytics
- Describe data warehousing architecture.
- Describe key features for data ingestion pipelines.
- Identify common types of analytical data store and related Azure services.
- Use Microsoft Fabric to ingest and analyze data.
- Explore fundamentals of real-time analytics
- Understand batch and stream processing.
- Describe common elements of streaming data solutions.
- Describe features and capabilities of real-time intelligence in Microsoft Fabric.
- Describe features and capabilities of Apache Spark Structured Streaming on Azure.
- Explore real-time analytics in Microsoft Fabric.
- Explore fundamentals of data visualization
- 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.
Register for Training
Schedule
| Start Date | End Date | Duration (days) | Price | Code |
|---|
