Unlock This Course & The Entire Vault™ Library
Have questions about our subscriptions? Call 1-800-264-9029 or email an account manager.
Login Buy SubscriptionDP-900T00: Introduction to Microsoft Azure Data
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.
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
