Get Started with SQL Analytics and BI on Databricks
Please note: This course was formerly titled 'Get Started with Databricks for Data Analysis,' but the course content remains unchanged.
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. With the purchase of a Databricks Labs subscription, the course also closes out with a comprehensive lab exercise to practice what you’ve learned in a live Databricks Workspace environment.
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 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
Data Analysis Comprehensive Lab
Self-Paced
Custom-fit learning paths for data, analytics, and AI roles and career paths through on-demand videos
Registration options
Databricks has a delivery method for wherever you are on your learning journey
Self-Paced
Custom-fit learning paths for data, analytics, and AI roles and career paths through on-demand videos
Register nowInstructor-Led
Public and private courses taught by expert instructors across half-day to two-day courses
Register nowBlended 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 nowSkills@Scale
Comprehensive training offering for large scale customers that includes learning elements for every style of learning. Inquire with your account executive for details