Introduction to Microsoft Azure Data (DP-900T00)
Contact us to book this course
Data Engineer
On-Site, Virtual
1 day
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
- Describe core data concepts
- Identify considerations for relational data on Azure
- Describe considerations for working with non-relational data on Azure
- Describe an analytics workload on Azure
Audience
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 outline
Download as PDF-
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 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
- 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
- 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
- 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
- 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
