Skip to main content

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 Unity Catalog managed 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 Agents for conversational analytics.


You can create a Databricks Free Edition account and try the follow-along demos in a hands-on environment.


Languages Available: English | 日本語 | Português BR | 한국어 | Español | française

Skill Level
Onboarding
Duration
2h
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.

Outline

Databricks Overview

• Databricks Data Intelligence Platform

• Databricks Workspace Walkthrough


Using Databricks for Data Analysis

• Writing Queries in Databricks

• Lab: Query the Sales Table

• Using Databricks Genie Code with Lakehouse

• Lab: Generate and Debug Queries with Genie Code

• Working with Delta Lake

• Lab: Manage a Book Inventory with Delta Lake


Databricks AI/BI

• Creating Dashboards in Databricks

• Lab: Build a Customer Growth Dashboard

• Creating Genie Agents

• Lab: Build Your Own Genie Agent

Upcoming Public Classes

Date
Time
Your Local Time
Language
Price
Aug 20
09 AM - 11 AM (America/Los_Angeles)
-
English
Free
Aug 25
09 AM - 11 AM (Europe/London)
-
English
Free
Aug 26
09 AM - 11 AM (America/Los_Angeles)
-
English
Free
Aug 28
12 PM - 02 PM (Asia/Singapore)
-
English
Free
Sep 01
09 AM - 11 AM (America/Los_Angeles)
-
English
Free
Sep 02
12 PM - 02 PM (Asia/Singapore)
-
English
Free
Sep 04
03 PM - 05 PM (Europe/London)
-
English
Free
Sep 09
09 AM - 11 AM (America/Los_Angeles)
-
English
Free
Sep 16
09 AM - 11 AM (Europe/London)
-
English
Free
Sep 18
09 AM - 11 AM (America/Los_Angeles)
-
English
Free
Sep 22
12 PM - 02 PM (Asia/Singapore)
-
English
Free
Sep 24
09 AM - 11 AM (America/Los_Angeles)
-
English
Free
Oct 06
09 AM - 11 AM (America/Los_Angeles)
-
English
Free
Oct 08
12 PM - 02 PM (Asia/Singapore)
-
English
Free
Oct 09
03 PM - 05 PM (Europe/London)
-
English
Free
Oct 16
09 AM - 11 AM (America/Los_Angeles)
-
English
Free
Oct 22
09 AM - 11 AM (Europe/London)
-
English
Free
Oct 29
12 PM - 02 PM (Asia/Singapore)
-
English
Free
Oct 29
09 AM - 11 AM (America/Los_Angeles)
-
English
Free

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.

See all our registration options

Registration options

Databricks has a delivery method for wherever you are on your learning journey

Runtime

Self-Paced

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

Register now

Instructors

Instructor-Led

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

Register now

Learning

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

Scale

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

Questions?

If you have any questions, please refer to our Frequently Asked Questions page.