Skip to main content

Get Started with SQL Analytics and BI on Databricks

In this course, you will learn basic skills that will allow you to use the Databricks Data Intelligence Platform to perform a simple data analytics workflow and support data warehousing endeavors. You will be given a tour of the workspace and be shown how to work with data objects in Databricks such as catalogs, schemas, tables, compute clusters, notebooks, and dashboards. You will then follow a basic data analytics workflow to perform tasks such as manipulating data using Databricks SQL, leveraging Delta Lake version logs to time travel, creating dashboards within the platform, and creating Genie Spaces for data exploration using natural language prompts. You will also learn how Databricks supports data warehousing needs through the use of Databricks SQL, Delta Live Tables, and Unity Catalog.


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

Skill Level
Onboarding
Duration
2h
Prerequisites
    • A basic understanding of data analytics principles and topics such as ANSI SQL, statistical analysis, and data preparation and presentation

Outline

Databricks Overview
Databricks Infrastructure
Databricks Data Intelligence Platform
Unity Catalog Overview
Databricks Workspace Walkthrough


Using Databricks for Data Analysis
Introduction to Data Analysis on Databricks
Writing Queries in Databricks
Using Databricks Assistant with Databricks SQL
Delta Lake Overview
Using Delta Lake features with Databricks SQL


Databricks AI/BI
Introduction to AI/BI
Creating a Dashboard in Databricks
Creating Genie Spaces


Upcoming Public Classes

Date
Time
Language
Price
Apr 14
12 PM - 02 PM (Asia/Singapore)
English
Free
Apr 15
02 PM - 04 PM (Asia/Kolkata)
English
Free
Apr 15
03 PM - 05 PM (Europe/London)
English
Free
Apr 17
01 PM - 03 PM (America/New_York)
English
Free
Apr 18
02 PM - 04 PM (Asia/Kolkata)
English
Free
Apr 23
12 PM - 02 PM (Asia/Singapore)
English
Free
Apr 23
03 PM - 05 PM (Europe/London)
English
Free
Apr 29
09 AM - 11 AM (America/Los_Angeles)
English
Free
May 02
09 AM - 11 AM (America/New_York)
English
Free
May 05
02 PM - 04 PM (Asia/Kolkata)
English
Free
May 06
09 AM - 11 AM (America/Los_Angeles)
English
Free
May 09
09 AM - 11 AM (America/Los_Angeles)
English
Free
May 13
12 PM - 02 PM (Asia/Singapore)
English
Free
May 14
03 PM - 05 PM (Europe/London)
English
Free
May 16
12 PM - 02 PM (Asia/Singapore)
English
Free
May 21
10 AM - 12 PM (Asia/Kolkata)
English
Free
May 21
12 PM - 02 PM (Asia/Kolkata)
English
Free
May 21
02 PM - 04 PM (Asia/Kolkata)
English
Free
May 22
09 AM - 11 AM (America/Los_Angeles)
English
Free
May 28
03 PM - 05 PM (Europe/London)
English
Free
May 29
12 PM - 02 PM (Asia/Singapore)
English
Free
May 29
11 AM - 01 PM (Europe/London)
English
Free
Jun 02
02 PM - 04 PM (Asia/Kolkata)
English
Free
Jun 04
12 PM - 02 PM (Asia/Singapore)
English
Free
Jun 04
09 AM - 11 AM (America/Los_Angeles)
English
Free
Jun 06
09 AM - 11 AM (America/Los_Angeles)
English
Free
Jun 18
03 PM - 05 PM (Europe/London)
English
Free
Jun 18
09 AM - 11 AM (America/Los_Angeles)
English
Free
Jun 24
12 PM - 02 PM (Asia/Singapore)
English
Free
Jun 24
02 PM - 04 PM (Asia/Kolkata)
English
Free
Jun 25
12 PM - 02 PM (Asia/Singapore)
English
Free
Jun 25
03 PM - 05 PM (Europe/London)
English
Free
Jun 26
02 PM - 04 PM (Asia/Kolkata)
English
Free
Jun 30
03 PM - 05 PM (Europe/London)
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

Upcoming Public Classes

Data Engineer

Automated Deployment with Databricks Asset Bundles

This course provides a comprehensive review of DevOps principles and their application to Databricks projects. It begins with an overview of core DevOps, DataOps, continuous integration (CI), continuous deployment (CD), and testing, and explores how these principles can be applied to data engineering pipelines.

The course then focuses on continuous deployment within the CI/CD process, examining tools like the Databricks REST API, SDK, and CLI for project deployment. You will learn about Databricks Asset Bundles (DABs) and how they fit into the CI/CD process. You’ll dive into their key components, folder structure, and how they streamline deployment across various target environments in Databricks. You will also learn how to add variables, modify, validate, deploy, and execute Databricks Asset Bundles for multiple environments with different configurations using the Databricks CLI.

Finally, the course introduces Visual Studio Code as an Interactive Development Environment (IDE) for building, testing, and deploying Databricks Asset Bundles locally, optimizing your development process. The course concludes with an introduction to automating deployment pipelines using GitHub Actions to enhance the CI/CD workflow with Databricks Asset Bundles.

By the end of this course, you will be equipped to automate Databricks project deployments with Databricks Asset Bundles, improving efficiency through DevOps practices.

Note: This course is the fourth in the 'Advanced Data Engineering with Databricks' series.

Free
2h
Professional

Questions?

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