DP-900 Azure Data Fundamentals

By Amy Coughlin

Certification Exam Prep for DP-900

15 hours
  • 69 Lessons
  • 10 Hands-On Labs
  • 9 Course Quizzes
  • 1 Practice Exam

About the course

Get Your Data Game On!

Do you want to get started working with data in the cloud? Are you pursuing certification for Azure Data Fundamentals or looking to check the prerequisite box for Azure Data Engineer or Azure Database Administrator certifications? This course will get you up to speed with core data concepts and how they are implemented using Microsoft Azure data services. We cover big data, NoSQL resources and tooling as well as traditional relational databases in the Cloud. Completing this course will prepare you to sit the DP-900 Microsoft Azure Data Fundamentals exam. And you’ll become an expert at Buzzword Bingo, too!

You Before This Course:

  • Hands-on experience performing basic IT or programming tasks.
  • Familiarity with simple data-related concepts, such as reading and interacting with tables and charts in a spreadsheet.
  • Foundational knowledge of cloud concepts and experience in the Azure Portal. (The first chapter of the course includes a brief review of the most course-relevant cloud concepts in Azure as well as an optional lab, Accessing and Using the Azure Portal.)
  • NOTE: While not required, students who have earned the AZ-900 Azure Fundamentals certification, or who have equivalent knowledge and experience, will be at an advantage in preparing for the DP-900 certification exam. Check out our AZ-900 course or shorter Intro to Azure course.

You After This Course:

By the end of our time together, you should possess business-level and novice technical knowledge of core data concepts — and have hands-on practice applying those concepts using Azure data resources. You will be prepared to pass the DP-900 exam to earn the Azure Data Fundamentals certification and/or you will be better prepared to study for Microsoft’s Azure Data Engineer Associate or Azure Database Administrator Associate certifications.

  • Chapter 1 4 Lessons Introduction and Pre-Game Warmup 43:23

    Course Overview: What’s In It For You?

    2:55

    A Different Approach to the DP-900 Exam

    3:30

    Review: Relevant Cloud and Azure Concepts

    6:58

    Accessing and Using the Azure Portal

    30:00 Hands-On Lab
  • Chapter 2 13 Lessons Game Rules: Azure Data Essentials 2:28:59

    Buzzword Bingo for Data Gurus

    8:55

    Exploring Data: Beyond Rows and Columns

    6:48

    Storing Data: Forms and Formats

    7:07

    Interacting with Data: Languages and Dialects

    6:16

    Managing Data: Moving, Processing, Securing

    8:47

    Applying Tools of the Data Trade

    7:26

    Use Cloud Shell to Survey Azure Data Resources

    45:00 Hands-On Lab

    Comparing Cloud Data Workloads

    5:55

    Exploring Data Warehouses, Data Lakes, and Data Swamps

    5:40

    Understanding Data Visualization and Analytics

    7:59

    Case Study: Cloud Data Platform for Lowe Classic Games

    6:11

    BINGO! Yes? Collect Your $7!

    2:55

    Azure Data Essentials

    30:00 Quiz
  • Chapter 3 6 Lessons Azure SQL, NoSQL, MySQL, YourSQL: What Shall We Play Today? 42:09

    Can’t We All Just Get Along?

    10:28

    Playing Battleship: Transactional Workloads

    5:27

    Playing Chess: Analytics Workloads

    4:16

    Case Study: Cloud Data Platform for Lowe Classic Games — Options Are Good

    4:03

    Bingo Round 2: Azure Data Offerings and Uses

    2:55

    Data Services in Azure

    15:00 Quiz
  • Chapter 4 7 Lessons Azure Storage: Looks Boring Until You Open the Box 1:08:35

    Reimagining Cloud Storage as a Data Resource

    8:19

    Case Study and Demo: Azure Blob Storage for Cognitive Services

    4:07

    Case Study: Azure Table Storage Provides Flexible Table Schema

    4:28

    Demo: Azure File Share Speeds Cloud Migration

    3:46

    Creating an Azure Storage Table

    30:00 Hands-On Lab

    Bingo Round 3: Azure Storage for the Win

    2:55

    Azure Storage Options

    15:00 Quiz
  • Chapter 5 8 Lessons Four Alternative Rules for Data Resource Management 1:15:57

    Securing Your Data

    11:56

    Demo: Provision and Deploy Data Resources in the Azure Portal

    11:47

    Demo: Provision and Deploy Data Resources Using PowerShell and Azure CLI

    10:51

    Demo: Provision and Deploy Data Resources Using ARM Templates

    5:20

    Case Study: What Is the “Best” Way to Provision Data Resources?

    3:08

    Expire Data Based on Age in Azure Blob Storage

    15:00 Hands-On Lab

    Bingo Round 4: Azure Data Resource Management

    2:55

    Azure Data Resource Management

    15:00 Quiz
  • Chapter 6 12 Lessons Relational Data: When Your Brother’s the Banker 2:53:35

    Features and Benefits of Relational Data

    11:42

    Options for Relational Data Infrastructure: On-Premises, IaaS, and PaaS

    7:50

    Relational Data Services: Flavors in Azure

    6:49

    Case Study: Cloud Data Platform for Lowe Classic Games — Relational Data

    4:54

    Create and Save a Reusable ARM Template from an Existing Azure SQL Database

    15:00 Hands-On Lab

    Bingo Round 5: Azure Relational Data

    3:16

    Exploring the SQL Language

    9:52

    Demo: Azure Data Studio and SQL Server Management Studio

    6:59

    Use Azure Data Studio to Perform 10 fundamental SQL Queries in Azure

    45:00 Hands-On Lab

    Using SQL to Manage Database Objects

    30:00 Hands-On Lab

    Relational Data Summary and Review

    2:13

    Relational Data in Azure

    30:00 Quiz
  • Chapter 7 7 Lessons Cosmos DB: The Game You Want for Your Birthday 1:45:14

    Understanding How Cosmos DB Lives Up to Its Hype

    9:49

    Introducing JSON: JavaScript Object Notation

    6:32

    Admiring the Many Faces of Cosmos DB — Interfaces, That Is

    7:30

    Working with the Core (SQL) API in Azure Cosmos DB

    1:00:00 Hands-On Lab

    Case Study: Cloud Data Platform for Lowe Classic Games — Non-Relational Data Choices

    3:28

    Bingo Round 6: Cosmos DB APIs

    2:55

    Cosmos DB APIs

    15:00 Quiz
  • Chapter 8 5 Lessons Azure Data Factory: “Mousetrap” for Data 47:13

    ETL and ELT: How Data Rolls and Moves

    5:56

    Exploring Batch Data, Micro-Batch Data, and Streaming Data

    5:12

    Demo: Azure Data Factory in Action

    10:21

    Scribbage: Azure Data Factory

    10:44

    ETL and Azure Data Factory

    15:00 Quiz
  • Chapter 9 7 Lessons Azure Synapse Analytics: Revival of a Classic Game 1:05:33

    Exploring Modern Data Warehouses

    7:40

    Trigger and Monitor an Azure Data Factory Pipeline

    30:00 Hands-On Lab

    Understanding Major Components of Azure Synapse Analytics

    4:12

    Demo: Operating Azure Synapse Analytics Using Synapse Studio

    4:02

    Case Study: Cloud Data Platform for Lowe Classic Games — Analytics Assets

    1:44

    Bingo Round 7: Azure Synapse Analytics

    2:55

    Modern Data Warehousing and Azure Synapse Analytics

    15:00 Quiz
  • Chapter 10 6 Lessons Analytics in Power BI (Some Assembly Required) 1:02:07

    Traversing the Workflow to Produce Winning Insights in Power BI

    5:38

    Surveying the Major Components of Power BI

    4:10

    Understanding Analytics Techniques and Associated Visualizations

    4:24

    Create a Compelling Power BI Dashboard Via a Canned App

    30:00 Hands-On Lab

    Final Bingo: Microsoft Power BI

    2:55

    Analytics in Microsoft Power BI

    15:00 Quiz
  • Chapter 11 4 Lessons Conclusion: Winning the Game 1:08:40

    Course Summary and Advanced Game Strategies

    3:14

    DP-900 Azure Data Fundamentals Practice Exam

    1:00:00 Quiz

    Booking Your DP-900 Exam

    2:36

    Beyond the Exam, Resources, and a Short History of Bingo

    2:50

What are Hands-on Labs

What's the difference between theoretical knowledge and real skills? Practical real-world experience. That's where Hands-on Labs come in! Hands-on Labs are guided, interactive experiences that help you learn and practice real-world scenarios in real cloud environments. Hands-on Labs are seamlessly integrated in courses, so you can learn by doing.

Get Started
Who’s going to be learning?
Sign In
Welcome Back!

Psst…this one if you’ve been moved to ACG!