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.

Note: 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!


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

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

Self-Paced

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

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

Create Your First Workspace Using Databricks Express

In this course, you will explore the core features and functionalities of Databricks Express Setup, a streamlined way to get started with Databricks. The course is designed to help you quickly set up and navigate a serverless workspace while providing a comprehensive understanding of the credit-based trial system, including the $400 allowance. Divided into six modules, it starts with an introduction to Databricks Express Setup, followed by an exploration of its key features and benefits. You will learn to create and manage serverless workspaces, perform exploratory data analysis using Unity Catalog, and gain insights into collaboration through data sharing.

Additionally, you’ll be guided through trial management and upgrade options, ensuring you can effectively transition from trial to paid accounts. The course also includes an internal-only module on the evolution of trial credits and account activation methods. By the end of the course, you will have a solid foundation in using Databricks Express Setup for data and AI workloads, enabling you to confidently explore and analyze data, collaborate with peers, and manage your Databricks environment efficiently.

Note: 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!

Free
1h 30m
Introductory

Questions?

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