(Online Delivery) DP-3011 Implementing a Data Analytics Solution with Azure Databricks Training

DP-3011 Implementing a Data Analytics Solution with Azure Databricks Training

Description

Course Overview

Organizations today rely on data-driven decision-making, but managing massive datasets across cloud platforms can be complex. DP-3011 Implementing a Data Analytics Solution with Azure Databricks equips data professionals to prepare, analyze, and govern data at scale using Apache Spark’s distributed computing capabilities.

In this one-day training, you’ll gain hands-on experience with Delta Lake for versioning and data integrity, automate data pipelines with Delta Live Tables, and implement governance with Unity Catalog. You’ll also explore Spark for large-scale data analysis, orchestrate workflows for production deployments, and collaborate in Python and SQL notebooks to deliver high-quality analytics-ready data.

What Is Included

  • Expert-led training with real-world scenarios
  • Official Microsoft curriculum (MOC) and supplemental materials
  • Certificate of completion
  • Hands-on labs with Azure Databricks
  • Free course retake option
  • Access to class recordings for 90 days
  • Flexible rescheduling options
  • Free retakes (see conditions)

Course Objectives

By the end of this course, participants will have the confidence to prepare and analyze data in Azure Databricks while applying governance and automation best practices. You will learn to:

  • Explore Azure Databricks workloads and core components
  • Perform large-scale data analysis with Spark and DataFrame APIs
  • Manage transactions, schema enforcement, and versioning with Delta Lake
  • Build automated data pipelines using Delta Live Tables
  • Implement governance using Unity Catalog and Microsoft Purview
  • Deploy production workloads with Azure Databricks Workflows

Who Should Attend?

This course is ideal for data analysts and data professionals who work with large datasets and want to leverage Azure Databricks for advanced analysis and pipeline automation. It is especially valuable for those responsible for preparing data for downstream analytics, applying governance to data lakes, and collaborating in notebook-based environments.

Course Prerequisites

  • Familiarity with SQL and basic Python
  • Working knowledge of Azure fundamentals
  • Basic understanding of data engineering or analytics workflows

Agenda

Lesson 1 - Explore Azure Databricks

  • Introduction to Azure Databricks
  • Identify common Azure Databricks workloads
  • Review essential concepts
  • Apply data governance with Unity Catalog and Microsoft Purview
  • Module assessment

Lesson 2 - Perform Data Analysis with Azure Databricks

  • Ingest data into Azure Databricks
  • Use built-in tools for data exploration
  • Perform analysis with DataFrame APIs
  • Module assessment

Lesson 3 - Use Apache Spark in Azure Databricks

  • Introduction to Apache Spark
  • Configure and create a Spark cluster
  • Work with Spark inside notebooks
  • Process various data files with Spark
  • Visualize data using Spark
  • Module assessment

Lesson 4 - Manage Data with Delta Lake

  • Introduction to Delta Lake
  • Work with ACID transactions
  • Enforce schema rules
  • Apply data versioning and time travel in Delta Lake
  • Ensure data integrity with Delta Lake
  • Module assessment

Lesson 5 - Build Data Pipelines with Delta Live Tables

  • Introduction to Delta Live Tables
  • Manage data ingestion and integration
  • Enable real-time data processing
  • Module assessment

Lesson 6 - Deploy Workloads with Azure Databricks Workflows

  • Overview of Azure Databricks Workflows
  • Understand the core components of workflows
  • Examine the benefits of Azure Databricks Workflows
  • Deploy workloads through Azure Databricks Workflows
  • Module assessment

Similar courses

Activities for this class are conducted in either SQL Online Lite or SQL Server Express, but the skills and fundamentals can be applied in any vendor environment – Microsoft, Oracle, and others.

More Information

Activities for this class are conducted in either SQL Online Lite or SQL Server Express, but the skills and fundamentals can be applied in any vendor environment – Microsoft, Oracle, and others.

More Information

90%+ of those who are new to Azure or just starting formal Azure training start here!

More Information

If you are someone with existing SQL or SQL Server knowledge (or someone highly versed in different data repositories), this is the Power BI course for you. This course is best for students with high PC skills and are experienced/comfortable with technology - if that isn't you, our one or two day Power BI classes might be a better fit for you.

More Information

This is a great class for an overview of Power BI/if Power BI isn't a central part of your job role.

More Information

Doing data analysis work is about more than learning a software program (Excel, Power BI, Tableau, etc.) - you need to understand the concepts and theory too. This one day course gets you up to speed (and can be useful either before or after your software classes). Please note - this is NOT a class that focuses on Microsoft Excel, Power BI, or any other software. Microsoft Excel will likely be used in class to illustrate core concepts, but the class is not designed to help students use software.

More Information

Activities for this class are conducted in either SQL Online Lite or SQL Server Express, but the skills and fundamentals can be applied in any vendor environment – Microsoft, Oracle, and others.

More Information

Activities for this class are conducted in either SQL Online Lite or SQL Server Express, but the skills and fundamentals can be applied in any vendor environment – Microsoft, Oracle, and others.

More Information

This is a great class for an overview of Power BI/if Power BI isn't a central part of your job role.

More Information

If you are someone with existing SQL or SQL Server knowledge (or someone highly versed in different data repositories), this is the Power BI course for you. This course is best for students with high PC skills and are experienced/comfortable with technology - if that isn't you, our one or two day Power BI classes might be a better fit for you.

More Information

Understanding DAX is critical for Power BI users. It is required that you are familiar with Power BI and (if attending virtually) that you have Power BI on the PC to be used for this training event in order to take this class.

More Information

90%+ of those who are new to Azure or just starting formal Azure training start here!

More Information

AZ-400T00 Designing and Implementing Microsoft DevOps Solutions

More Information

Explore the power of this robust toolset that enables advanced distributed search, analytics, logging, and visualization of data, enabled by new features in Elastic Stack 7.0.

More Information

DP-3014 Build machine learning solutions using Azure Databricks

More Information

DP-3028 Implement Generative AI engineering with Azure Databricks

More Information