Students will:
- Learn to describe core data workloads such as transactional and analytical workloads, and their key differences
- Manage and work with relational databases using tools like 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 prepares a student to take the Microsoft DP-900 – Azure Data Fundamentals national certification exam.
Course Outline:
Lesson 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
Lesson 2: Core Data Concepts
- Describe Types of Core Data Workloads
- Describe Data Analytics Core Concepts
- Summary
- Exam Essentials
Lesson 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
Lesson 4: Nonrelational Databases in Azure
- Nonrelational Database Features
- Azure Cosmos DB
- Management Tasks for Azure Cosmos DB
- Summary
- Exam Essentials
Lesson 5: File, Object, and Data Lake Storage
- File and Object Storage Features
- Azure Storage
- Management Tasks for Azure Storage
- Summary
- Exam Essentials
Lesson 6: Modern Data Warehouses in Azure
- Analytical Workload Features
- Modern Data Warehouse Components
- End-to-End Analytics with Azure Synapse Analytics
- Summary
- Exam Essentials
Lesson 7: Reporting with Power BI
- Power BI at a Glance
- Summary
- Exam Essentials
All necessary course materials are included.
Certification(s):
This course prepares a student to take the Microsoft DP-900 – Azure Data Fundamentals national certification exam.
