Get Started with SQL Analytics and BI on Databricks

This course introduces the Databricks Data Intelligence Platform and the core skills a data analyst needs for day-to-day SQL analytics and BI work. You'll navigate the workspace and Unity Catalog, write SQL queries against governed Delta tables from a Serverless SQL Warehouse, use Genie Code to generate and debug SQL, work with Delta Lake (DML, version history, time travel, and restore), build and publish AI/BI Dashboards, and create Genie Spaces for conversational analytics. Each topic pairs a guided Demo notebook with a hands-on Lab.

Languages Available: English | 日本語 | Português BR | 한국어

Skill Level

Onboarding

Duration

Prerequisites

The content was developed for participants with these skills/knowledge/abilities:

• A basic understanding of data analytics principles and topics such as ANSI SQL, statistical analysis, and data preparation and presentation.

Self-Paced

Custom-fit learning paths for data, analytics, and AI roles and career paths through on-demand videos

Customer registration Partner registration

See all our registration options

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

Instructor-Led

Public and private courses taught by expert instructors across half-day to two-day courses

Blended 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 now

Skills@Scale

Comprehensive training offering for large scale customers that includes learning elements for every style of learning. Inquire with your account executive for details

Upcoming Public Classes

Platform Administrator

Get Started with Databricks Platform Administration

In this course, you will learn the basics of platform administration on the Databricks Data Intelligence Platform. It offers a comprehensive overview of the Unity Catalog, a vital component for effective data governance within Databricks environments. Divided into five modules, it begins with a detailed introduction to Databricks infrastructure and its data intelligence platform, including an in-depth walkthrough of the Databricks Workspace. You will explore data governance principles within Unity Catalog, covering its key concepts, architecture, and roles. The course further emphasizes managing Unity Catalog metastores and compute resources, including clusters and SQL warehouses. Finally, you'll master data access control by learning about privileges, fine-grained access, and how to govern data objects. By the end, you will be equipped with essential skills to administer the Unity Catalog to implement effective data governance, optimize compute resources, and enforce robust data security strategies.

Languages Available: English | 日本語 | Português BR | 한국어

Free

Onboarding

Machine Learning Practitioner

Get Started with Databricks for Machine Learning

In this course, you will develop the foundational skills needed to use the Databricks Data Intelligence Platform for executing machine learning workflows and supporting data science workloads. You will explore the platform from the perspective of a machine learning practitioner, covering topics such as building and managing features with Feature Engineering in Unity Catalog, end-to-end model lifecycle management with MLflow, and pipeline orchestration with Lakeflow Jobs. Additionally, you will learn about real-time model inference with Databricks Model Serving and experience Databricks' transparent, conversational approach to model development through Genie Code - Data Science Agent Mode, where you use natural language prompts to generate, run, and iteratively refine executable ML workflows directly in your notebook. The course includes instructor-led demonstrations, culminating in a comprehensive lab that reinforces the concepts covered throughout.

Languages Available: English | 日本語 | Português BR | 한국어

Free

Onboarding

Data Analyst

SQL Analytics on Databricks

In this course, you'll learn how to effectively use Databricks for data analytics, with a specific focus on Databricks SQL. As a Databricks Data Analyst, your responsibilities will include finding relevant data, analyzing it for potential applications, and transforming it into formats that provide valuable business insights.

You will also understand your role in managing data objects and how to manipulate them within the Databricks Data Intelligence Platform, using tools such as Notebooks, the SQL Editor, and Databricks SQL.

Additionally, you will learn about the importance of Unity Catalog in managing data assets and the overall platform. Finally, the course will provide an overview of how Databricks facilitates performance optimization and teach you how to access Query Insights to understand the processes occurring behind the scenes when executing SQL analytics on Databricks.Note: For SCORM lecture files, please ensure that you close the SCORM window after completing the content. Do not click the ‘Next Lesson’ button, as doing so may prevent the SCORM module from being marked as complete.

Languages Available: English | 日本語 | Português BR | 한국어

Free

Associate