Skip to main content

Databricks Get Started Days (Data Engineering + SQL Analytics and BI)

Get Started with Databricks for Data Engineering

In this course, you will learn basic skills that will allow you to use the Databricks Data Intelligence Platform to perform a simple data engineering workflow and support data warehousing endeavors. You will be given a tour of the workspace and be shown how to work with objects in Databricks such as catalogs, schemas, volumes, tables, compute clusters and notebooks. You will then follow a basic data engineering workflow to perform tasks such as creating and working with tables, ingesting data into Delta Lake, transforming data through the medallion architecture, and using Databricks Workflows to orchestrate data engineering tasks. You’ll 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.


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. 


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
4h
Prerequisites

Get Started with Databricks for Data Engineering

  • A basic understanding of data engineering principles and topics such as data collection, extraction, ingestion, and transformation.


Get Started with SQL Analytics and BI on Databricks

    • A basic understanding of data analytics principles and topics such as ANSI SQL, statistical analysis, and data preparation and presentation

Outline

Get Started with Databricks for Data Engineering

Databricks Fundamentals
Databricks Architecture
Databricks Products and Features
Exploring the Databricks Platform

Using Databricks for Data Engineering
Introduction and  Overview
Introduction to Data Engineering
Delta Lake Overview
Creating and Working with a Delta Table
Delta Lake Data Ingestion Techniques Overview
Ingesting Data into Delta Lake
Data Transformation Overview
Transforming Data Using the Medallion Architecture
Unified Orchestration Using Databricks Overview
Creating a Simple Databricks Workflow

Get Started with SQL Analytics and BI on Databricks

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
Your Local Time
Language
Price
Oct 20
11 AM - 03 PM (Asia/Singapore)
-
English
Free
Oct 22
01 PM - 05 PM (Europe/London)
-
English
Free
Oct 27
09 AM - 01 PM (America/Los_Angeles)
-
English
Free
Oct 29
11 AM - 03 PM (Asia/Singapore)
-
Mandarin
Free
Nov 17
11 AM - 03 PM (Asia/Singapore)
-
English
Free
Nov 18
11 AM - 03 PM (Asia/Singapore)
-
Mandarin
Free
Nov 18
09 AM - 01 PM (America/Los_Angeles)
-
English
Free
Nov 19
01 PM - 05 PM (Europe/London)
-
English
Free
Dec 08
11 AM - 03 PM (Asia/Singapore)
-
English
Free
Dec 10
09 AM - 01 PM (Europe/Paris)
-
Italian
Free
Dec 10
01 PM - 05 PM (Europe/London)
-
English
Free
Dec 11
09 AM - 01 PM (America/Los_Angeles)
-
English
Free
Jan 19
11 AM - 03 PM (Asia/Singapore)
-
English
Free
Jan 20
11 AM - 03 PM (Asia/Singapore)
-
Mandarin
Free
Jan 20
09 AM - 01 PM (America/Los_Angeles)
-
English
Free
Jan 21
01 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

Get Started with Databricks for Data Engineering - Mandarin Chinese

本课程介绍在 Databricks Data Intelligence Platform 上执行基本数据工程工作流所需的基础技能。您将浏览 workspace,使用 Unity Catalog,并学习数据工程师在 Databricks 上日常使用的核心构建模块。

本课程采用实践路径。您从熟悉 workspace 开始,然后针对每个主题完成配套的演示笔记本和实验室笔记本。演示部分将由讲师或引导式笔记本带您了解相关概念。

课程内容涵盖:

Databricks Data Intelligence Platform,以及 Databricks workspace、Unity Catalog 和笔记本之间的协作关系。

创建和管理 Delta Lake 表。

使用 INSERT、UPDATE 和 DELETE 修改数据。

浏览 UC 表的版本历史与 time travel 功能。

使用 LakeFlow Connect 的多种方式摄取数据:CTAS、上传 UI 以及 COPY INTO。

构建奖章架构管道,将数据依次经过铜牌、银牌和金牌层进行转换。

使用 LakeFlow Jobs 实现管道自动化。

(附加内容)使用 Apache Spark™ Declarative Pipelines 构建声明式管道。

完成本课程后,您将能够熟练创建 Delta Lake 表、向其中摄取数据、通过奖章管道对数据进行转换,并将整个流程自动化为定时任务。

注意:Databricks Academy 正在将 Databricks 环境中的课堂课程转为基于 notebook 的形式,并停止在讲座中使用幻灯片。您可以在 Vocareum 实验环境中访问课程 notebook。

Free
2h
instructor-led
Onboarding

Questions?

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