Skip to main content

Get Started with SQL Analytics and BI on Databricks

This course introduces you to the Databricks Data Intelligence Platform, covering essential skills for data analytics and warehousing. Learn to navigate the workspace, work with data objects, run SQL queries, use Delta Lake features, and create dashboards.


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

1. Databricks Overview
• Databricks Data Intelligence Platform
• Demo: Databricks Workspace Walkthrough


2. Using Databricks for Data Analysis
• Introduction to Data Analysis on Databricks
• Demo: Writing Queries in Databricks
• Demo: Using Databricks Assistant with Databricks SQL
• Delta Lake Overview
• Demo: Using Delta Lake features with Databricks SQL


3. Databricks AI/BI
• Introduction to AI/BI
• Demo: Creating a Dashboard in Databricks
• Demo: Creating Genie Spaces


Upcoming Public Classes

Date
Time
Your Local Time
Language
Price
Jul 28
09 AM - 11 AM (Europe/London)
-
English
Free
Jul 30
09 AM - 11 AM (America/Los_Angeles)
-
English
Free
Aug 04
09 AM - 11 AM (America/Los_Angeles)
-
English
Free
Aug 05
12 PM - 02 PM (Asia/Singapore)
-
English
Free
Aug 07
03 PM - 05 PM (Europe/London)
-
English
Free
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

Upcoming Public Classes

Data Engineer

Automated Deployment with Declarative Automation 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 Declarative Automation 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 Declarative Automation 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 Declarative Automation 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 Declarative Automation Bundles.

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

Note: 

1. Databricks Academy is transitioning from video lectures to a more streamlined PDF format with slides and notes for all self-paced courses. Please note that demo videos will still be available in their original format. We would love to hear your thoughts on this change, so please share your feedback through the course survey at the end. Thank you for being a part of our learning community!

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

Languages Available: English | 日本語 | 한국어

Free
2h
Professional

Questions?

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