Implement a Data Analytics Solution with Azure Databricks (DP-3011)

 

Course Overview

This course explores how to use Databricks and Apache Spark on Azure to take data projects from exploration to production. You’ll learn how to ingest, transform, and analyze large-scale datasets with Spark DataFrames, Spark SQL, and PySpark, while also building confidence in managing distributed data processing. Along the way, you’ll get hands-on with the Databricks workspace—navigating clusters and creating and optimizing Delta tables.   You’ll also dive into data engineering practices, including designing ETL pipelines, handling schema evolution, and enforcing data quality. The course then moves into orchestration, showing you how to automate and manage workloads with Lakeflow Jobs and pipelines. To round things out, you’ll explore governance and security capabilities such as Unity Catalog and Purview integration, ensuring you can work with data in a secure, well-managed, and production-ready environment.

Who should attend

​Before taking this course, learners should already be comfortable with the fundamentals of Python and SQL. This includes being able to write simple Python scripts and work with common data structures, as well as writing SQL queries to filter, join, and aggregate data. A basic understanding of common file formats such as CSV, JSON, or Parquet will also help when working with datasets. In addition, familiarity with the Azure portal and core services like Azure Storage is important, along with a general awareness of data concepts such as batch versus streaming processing and structured versus unstructured data. While not mandatory, prior exposure to big data frameworks like Spark, and experience working with Jupyter notebooks, can make the transition to Databricks smoother.

Prerequisites

Before starting this learning path, you should already be comfortable with the fundamentals of Python and SQL. This includes being able to write simple Python scripts and work with common data structures, as well as writing SQL queries to filter, join, and aggregate data. A basic understanding of common file formats such as CSV, JSON, or Parquet will also help when working with datasets.

In addition, familiarity with the Azure portal and core services like Azure Storage is important, along with a general awareness of data concepts such as batch versus streaming processing and structured versus unstructured data. While not mandatory, prior exposure to big data frameworks like Spark, and experience working with Jupyter notebooks, can make the transition to Databricks smoother.

Course Content

Explore Azure Databricks

  • Introduction
  • Get started with Azure Databricks
  • Identify Azure Databricks workloads
  • Understand key concepts
  • Data governance using Unity Catalog and Microsoft Purview
  • Exercise - Explore Azure Databricks
  • Module assessment
  • Summary

Perform data analysis with Azure Databricks

  • Introduction
  • Ingest data with Azure Databricks
  • Data exploration tools in Azure Databricks
  • Data analysis using DataFrame APIs
  • Exercise - Explore data with Azure Databricks
  • Module assessment
  • Summary

Use Apache Spark in Azure Databricks

  • Introduction
  • Get to know Spark
  • Create a Spark cluster
  • Use Spark in notebooks
  • Use Spark to work with data files
  • Visualize data
  • Exercise - Use Spark in Azure Databricks
  • Module assessment
  • Summary

Manage data with Delta Lake

  • Introduction
  • Get started with Delta Lake
  • Create Delta tables
  • Implement schema enforcement
  • Data versioning and time travel in Delta Lake
  • Data integrity with Delta Lake
  • Exercise - Use Delta Lake in Azure Databricks
  • Module assessment
  • Summary

Build Lakeflow Declarative Pipelines

  • Introduction
  • Explore Lakeflow Declarative Pipelines
  • Data ingestion and integration
  • Real-time processing
  • Exercise - Create a Lakeflow Declarative Pipeline
  • Module assessment
  • Summary

Deploy workloads with Lakeflow Jobs

  • Introduction
  • What are Lakeflow Jobs?
  • Understand key components of Lakeflow Jobs
  • Explore the benefits of Lakeflow Jobs
  • Deploy workloads using Lakeflow Jobs
  • Exercise - Create a Lakeflow Job
  • Module assessment
  • Summary

Prices & Delivery methods

Online Training

Duration
1 day

Price
  • £ 940.—
Classroom Training

Duration
1 day

Price
  • United Kingdom: £ 940.—

Schedule

Instructor-led Online Training:   This computer icon in the schedule indicates that this date/time will be conducted as Instructor-Led Online Training. If you have any questions about our online courses, feel free to contact us via phone or Email anytime.
This is a FLEX course, which is delivered both virtually and in the classroom. Please note, local pricing is applicable.

English

European Time Zones

Online Training Course language: English
Online Training This is a FLEX course.
Online Training This is a FLEX course.

5 hours difference to British Summer Time (BST)

Online Training Time zone: Eastern Daylight Time (EDT) Course language: English
Online Training Time zone: Eastern Daylight Time (EDT) Course language: English

8 hours difference to British Summer Time (BST)

Online Training Time zone: Pacific Daylight Time (PDT) Course language: English
Online Training Time zone: Pacific Daylight Time (PDT) Course language: English
This is a FLEX course, which is delivered both virtually and in the classroom. Please note, local pricing is applicable.

Europe

Germany

Munich This is a FLEX course.   Book now:
Book online training
Book classroom training

Netherlands

Utrecht This is a FLEX course.   Course language: English Book now:
Book online training
Book classroom training
Utrecht This is a FLEX course.   Course language: English Book now:
Book online training
Book classroom training

Poland

Warsaw This is a FLEX course.   Book now:
Book online training
Book classroom training
Warsaw This is a FLEX course.   Book now:
Book online training
Book classroom training

Ukraine

Kiev This is a FLEX course.   Course language: Ukrainian Book now:
Book online training
Book classroom training
Kiev This is a FLEX course.   Course language: Ukrainian Book now:
Book online training
Book classroom training

If you can't find a suitable date, don't forget to check our world-wide FLEX training schedule.