Databricks Performance Optimization
Databricks Performance Optimization teaches data engineers and analysts how to diagnose, measure, and fix performance bottlenecks on the Databricks Data Intelligence Platform, and how to tie performance improvements back to cost. The course follows a measurement-first, platform-first workflow: let the platform's automatic optimizations do the heavy lifting, verify what was applied using Query Profile and system tables, then manually tune where needed.
Learners build a foundation for measuring performance with Query Profile, Performance Insights, and query history system tables. From there, they explore key optimization techniques, including data layout and self-tuning managed tables, liquid clustering, caching and intermediate results, shuffle, skew, spill, row explosions, driver performance, Python UDFs, serverless compute, Photon, and cost attribution.
Throughout the course, learners explore deliberately slow queries over synthetic retail data and see how different optimization techniques affect performance. They use evidence such as file pruning, task execution time, Photon coverage, and cost to evaluate improvements. Two scenario-based labs reinforce the optimization workflow from diagnosis through validation.
Note: Databricks Academy is transitioning to a notebook-based format for classroom sessions within the Databricks environment, discontinuing the use of slide decks for lectures. You can access the lecture notebooks in the Vocareum lab environment.
Languages Available: English | 日本語 | Português BR | 한국어
The content was developed for participants with these skills/knowledge/abilities:
• Navigating the Databricks workspace and running notebooks
• Writing intermediate SQL, including joins and aggregations
• Writing PySpark using DataFrame transformations and actions
• Working with Delta Lake tables and core Unity Catalog concepts, including catalogs, schemas, tables, and managed tables
• Understanding core Spark execution concepts, including partitions, transformations, and lazy evaluation
• Basic familiarity with Lakeflow Jobs, including scheduling and running notebook workloads as jobs
Outline
• Demo: Measure First - Query Profiles and Benchmarks
• Demo: Data Layout
• Demo: Liquid Clustering vs Partitioning
• Demo: Caching and Intermediate Results
• Lab 1: Layout
• Demo: Shuffle, Skew, Spill and Explosion
• Demo: Python, Driver and UDF Pitfalls
• Serverless and Photon
• Demo: Cost & Cost Attribution
• Lab 2: Cost
Upcoming Public Classes
Date | Time | Your Local Time | Language | Price |
|---|---|---|---|---|
Nov 19 | 01 PM - 05 PM (Australia/Sydney) | - | English | $750.00 |
Nov 19 | 09 AM - 01 PM (Europe/Paris) | - | English | $750.00 |
Nov 19 | 09 AM - 01 PM (America/Los_Angeles) | - | English | $750.00 |
Dec 10 | 09 AM - 01 PM (Asia/Kolkata) | - | English | $750.00 |
Dec 10 | 01 PM - 05 PM (Europe/Paris) | - | English | $750.00 |
Dec 10 | 09 AM - 01 PM (America/New_York) | - | English | $750.00 |
Jan 21 | 09 AM - 01 PM (Asia/Singapore) | - | English | $750.00 |
Jan 21 | 09 AM - 01 PM (Europe/Paris) | - | English | $750.00 |
Jan 21 | 01 PM - 05 PM (America/New_York) | - | English | $750.00 |
Public Class Registration
If your company has purchased success credits or has a learning subscription, please fill out the Training Request form. Otherwise, you can register below.
Private Class Request
If your company is interested in private training, please submit a request.
Registration options
Databricks has a delivery method for wherever you are on your learning journey
Self-Paced
Custom-fit learning paths for data, analytics, and AI roles and career paths through on-demand videos
Register nowInstructor-Led
Public and private courses taught by expert instructors across half-day to two-day courses
Register nowBlended Learning
Self-paced and weekly instructor-led sessions for every style of learner to optimize course completion and knowledge retention. Go to Subscriptions Catalog tab to purchase
Purchase nowSkills@Scale
Comprehensive training offering for large scale customers that includes learning elements for every style of learning. Inquire with your account executive for details

