Microsoft Azure Data Fundamentals (DP-900)
If you’ve ever wanted to get ahead in cloud data without breaking a sweat, our Microsoft Certified Azure Data Fundamentals (exam DP-900) certification guide is the perfect start. You’ll learn the difference between relational and non-relational databases, explore Azure Synapse Analytics for end-to-end data solutions, and get hands-on with tools like Power BI for reporting.
This beginner-friendly course makes mastering Azure data workloads and modern data warehouses a breeze.
What You`ll Learn on This Course
-
- Learn to describe core data workloads such as transactional and analytical workloads, and their key differences
- Manage and work with relational databases using tools luke Azure SQL Databases, Azure Database for PostgreSQL, and Azure SQL Managed Instance
- Gain hands-on experience with Azure Cosmos DB and Azure Table Storage for managing nonrelational data, including key-value, column-family, and document data models
- Understand the fundamentals of data analytics such as batch processing, stream processing, and real-time analytics
- Learn to work with modern data warehouse solutions and implement en-to-end analytics using Azure Synapse Analytics
- Develop skills in managing and storing data using Azure Blob Storage, Data Lakes, and other Azure Storage options
- Sharpen your SQL skills by learning query techniques for managing and retrieving data from relational databases on Azure
- Deploy and manage databases and resources using Azure Resource Manager (ARM) templates
- Create HDInsight clusters and Azure Databricks for big data processing to manage Azure workloads.
This course comes with:
Curriculum
- 2 Sections
- 0 Lessons
- 26 Weeks
Expand all sectionsCollapse all sections
- Lesson Plan
1. Introduction
- Who Should Read This Course?
- DP-900 Exam Objectives
- Domain 1: Describe Core Data Components
- Domain 2: Describe How to Work with Relational Data on Azure
- Domain 3: Describe How to Work with Nonrelational Data on Azure
- Domain 4: Describe an Analytics Workload on Azure
2. Core Data Concepts
- Describe Types of Core Data Workloads
- Describe Data Analytics Core Concepts
- Summary
- Exam Essentials
3. Relational Databases in Azure
- Relational Database Features
- Relational Database Offerings in Azure
- Management Tasks for Relational Databases in Azure
- Query Techniques for SQL
- Summary
- Exam Essentials
4. Nonrelational Databases in Azure
- Nonrelational Database Features
- Azure Cosmos DB
- Management Tasks for Azure Cosmos DB
- Summary
- Exam Essentials
5. File, Object, and Data Lake Storage
- File and Object Storage Features
- Azure Storage
- Management Tasks for Azure Storage
- Summary
- Exam Essentials
6. Modern Data Warehouses in Azure
- Analytical Workload Features
- Modern Data Warehouse Components
- End-to-End Analytics with Azure Synapse Analytics
- Summary
- Exam Essentials
7. Reporting with Power BI
- Power BI at a Glance
- Summary
- Exam Essentials
0 - Hands-on LAB Activities
1. Relational Databases in Azure
- Creating a SQL Server VM in the Azure Portal
- Creating an Azure SQL Database
- Viewing Access with RBAC for a Resource Group
- Using an ARM Template in the Portal
- Deploying an ARM Template
- Creating an Azure Database for PostgreSQL Servers
2. Nonrelational Databases in Azure
- Creating a Table in Azure Table Storage
- Creating a Cosmos DB Account and Getting the ARM Template
- Creating a Cosmos DB Account from the Azure Portal Using the ARM Template
3. File, Object, and Data Lake Storage
- Creating a Storage Account, Container, and Storage Blob Directory
- Creating a Blob Container
4. Modern Data Warehouses in Azure
- Creating an HDInsight Cluster
- Provisioning an Azure Databricks Workspace and Creating a Cluster
0
