Skip to main content

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.

Skill Level
Associate
Duration
4h
Prerequisites

- A working knowledge of using SQL for data analysis purposes. 

- Be familiar with how data is created, stored, and managed. 

- A basic understanding of statistical analysis.

- Understand the structure and defining characteristics of specific data formats such as CSV, JSON, TXT, and Parquet.

- Be familiar with the user interface of the Databricks Data Intelligence Platform.

Outline

Data Discovery

Using Unity Catalog as a Data Discovery Tool

Understanding Data Object Ownership

Use Unity Catalog to Locate and Inspect Datasets


Data Importing

Ingesting Data into Databricks

Uploading Data to Databricks Using the UI

Programmatic Exploration and Data Ingestion to Unity Catalog

Import Data into Databricks


SQL Execution

Databricks SQL and Databricks SQL Warehouses

The Unified SQL Editor

Manipulate and Transform Data with Databricks SQL

Creating Views with Databricks SQL

Manipulate and Analyze a Table


Query Analysis

Databricks Photon and Optimization in Databricks

Query Insights

Best Practices for SQL Analytics

Upcoming Public Classes

Date
Time
Language
Price
May 13
09 AM - 01 PM (America/New_York)
English
$750.00
Jul 02
09 AM - 01 PM (Europe/London)
English
$750.00
Jul 11
01 PM - 05 PM (America/New_York)
English
$750.00
Aug 11
09 AM - 01 PM (Europe/London)
English
$750.00
Aug 13
09 AM - 01 PM (Asia/Kolkata)
English
$750.00
Aug 15
01 PM - 05 PM (America/New_York)
English
$750.00
Sep 09
01 PM - 05 PM (Europe/London)
English
$750.00
Sep 11
01 PM - 05 PM (Asia/Kolkata)
English
$750.00
Sep 12
09 AM - 01 PM (America/New_York)
English
$750.00
Oct 06
09 AM - 01 PM (Europe/London)
English
$750.00
Oct 07
01 PM - 05 PM (Australia/Sydney)
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.

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

Questions?

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