DP-900: Introduction to Microsoft Azure Data
MOC: DP-900T00
MS Subscription
Interface Gold
n 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.
What you will learn
With a focus on practical applications, the course covers:
- Differentiate between structured, semi-structured, and unstructured data
- Understand relational (SQL) vs. non-relational (NoSQL) data
- Learn about batch vs. stream processing.
- Learn to deploy and manage relational databases
- Explore NoSQL options
- Data roles
- Storage types
- Understand modern data warehousing
What products and services will you use and learn about in this course
- Azure SQL Database
- Azure SQL Managed Instance
- SQL Server on Azure Virtual Machines
- Azure Cosmos DB
- Azure Blob Storage
- Azure Table Storage.
- Azure Synapse Analytics
- Azure Data Factory
- Azure Databricks and Azure HDInsight
- Power BI Desktop
- Power BI Service
Prepare for the Microsoft Certified: Azure Data Fundamentals Certification
This course is designed to help students confidently prepare for the DP-900: Microsoft Certified: Azure Data Fundamentals exam.
Note: To pass the certification test, studying outside the course may be required to ensure all the concepts are fully understood.
- $695
- 1 Day, Labs, Live Q&A
- Replay™ Class Recordings Included
- Included in “all-you-can-eat” Microsoft Live Training Subscription
4:00 AM - 12:00 PM (HI)
7:00 AM - 3:00 PM (PT)
7:00 AM - 3:00 PM (AZ)
8:00 AM - 4:00 PM (MT)
9:00 AM - 5:00 PM (CT)
10:00 AM - 6:00 PM (ET)
4:00 AM - 12:00 PM (HI)
7:00 AM - 3:00 PM (PT)
7:00 AM - 3:00 PM (AZ)
8:00 AM - 4:00 PM (MT)
9:00 AM - 5:00 PM (CT)
10:00 AM - 6:00 PM (ET)
5:00 AM - 1:00 PM (HI)
7:00 AM - 3:00 PM (PT)
8:00 AM - 4:00 PM (AZ)
8:00 AM - 4:00 PM (MT)
9:00 AM - 5:00 PM (CT)
10:00 AM - 6:00 PM (ET)
5:00 AM - 1:00 PM (HI)
7:00 AM - 3:00 PM (PT)
8:00 AM - 4:00 PM (AZ)
8:00 AM - 4:00 PM (MT)
9:00 AM - 5:00 PM (CT)
10:00 AM - 6:00 PM (ET)
Course Outline
Learning Path 1: Introduction to Microsoft Azure Data core data concepts
Data is the foundation on which all software is built. By learning about common data formats, workloads, roles, and services, you can prepare yourself for a career as a data professional.
Modules:
- Explore core data concepts
- Explore data roles and services
Exercises:
- None
Learning Path 2: Introduction to Microsoft Azure Data relational data in Azure
Relational data is at the heart of most business applications, and is the foundation on which many enterprise data solutions are built. Microsoft Azure provides services for managing relational databases, enabling you to build new applications or migrate existing ones to the cloud.
Modules:
- Explore fundamental relational concepts
- Explore relational database services in Azure
Exercise:
- Explore Azure relational database services
Learning Path 3: Introduction to Microsoft Azure Data non-relational data in Azure
Non-relational data is a common way for applications to store and query data without the overhead of a relational schema. In Microsoft Azure, you can use Azure Storage and Azure Cosmos DB to build highly scalable, secure data stores for non-relational data.
Modules:
- Explore Azure Storage for non-relational data
- Explore fundamentals of Azure Cosmo DB
Exercise:
- Explore Azure Storage
Learning Path 4: Introduction to Microsoft Azure Data analytics in Azure
The phenomenal growth in data in recent years is fueling digital transformation of businesses and other organizations by empowering fast and informed decision making through data analytics. Microsoft Azure provides multiple services that you can combine to build large-scale analytics solutions that leverage the latest technologies and techniques for data ingestion, storage, modeling, and visualization.
Modules:
- Explore fundamentals of large-scale data warehouse
- Explore fundamentals of real-time analytics
- Explore fundamentals of data visualization
Exercises:
- Explore data analytics in Microsoft Fabric
- Explore Microsoft Fabric Real-Time Intelligence
- Explore fundamentals of data visualization with Power BI
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.
Prerequisites
Prerequisite certification is not required before taking this course. Successful Azure Data Fundamentals students start with some basic awareness of computing and Internet concepts, and an interest in extracting insights from data. Specifically:
- Experience using a web browser, such as Microsoft Edge.
- Familiarity with basic data-related concepts, such as working with tables of data in a spreadsheet and visualizing data using charts.
- A willingness to learn through hands-on exploration.
For learners who might be new to the data space and not yet familiar with some basic concepts, there is also a primer, Understand data concepts – (https://learn.microsoft.com/en-us/training/paths/understand-data-concepts/) . This primer provides and basic introduction to general concepts and terminology and is independent of any specific Microsoft solution