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
Sep 22
01 PM - 05 PM (Europe/London)
-
English
Free
Sep 24
09 AM - 01 PM (America/Los_Angeles)
-
English
Free
Sep 25
11 AM - 03 PM (Asia/Singapore)
-
Mandarin
Free
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

Data Engineer

Data Ingestion with Lakeflow Connect - Mandarin Chinese

本课程全面介绍 LakeFlow Connect——一种可扩展且简便的解决方案,用于将来自各种来源的数据摄取到 Databricks 中。您将首先浏览 LakeFlow Connect 连接器的不同类型(标准型和托管型),并学习各种数据摄取技术,包括批处理摄取、增量批处理摄取和流式处理摄取。您还将了解使用 Delta 表和金银铜架构的主要优势。

接下来,您将培养使用 LakeFlow Connect 标准连接器从云对象存储摄取数据的实践技能。这包括使用 CREATE TABLE AS SELECT(CTAS)、COPY INTO 和 Auto Loader 等方法,并重点介绍每种方法的优势和注意事项。您还将学习如何在将数据摄取到 Databricks Data Intelligence Platform 的过程中,向铜层表追加元数据列。课程随后介绍如何使用救援数据列处理与表架构不匹配的记录,以及管理和分析此类数据的策略。您还将探索摄取和展平半结构化 JSON 数据的技术。

此后,您将探索如何使用 LakeFlow Connect 托管连接器执行企业级数据摄取,以引入来自数据库和软件即服务(SaaS)应用程序的数据。课程还将介绍 Partner Connect,作为将合作伙伴工具集成到摄取工作负载中的一种选项。

最后,课程以替代摄取策略作为总结,包括 MERGE INTO 运营以及利用 Databricks Marketplace,为您奠定坚实的基础,以支持现代数据工程用例。

注意:对于 SCORM 课程文件,请确保完成内容后关闭 SCORM 窗口。请勿点击“下一课”按钮,否则可能导致 SCORM 模块无法标记为已完成。

Free
2h
Associate
Data Engineer

DevOps Essentials for Data Engineering - Mandarin Chinese

本课程探讨软件工程最佳实践与 DevOps 原则,专为使用 Databricks 的数据工程师量身设计。学员将在代码质量、版本控制、文档编写和测试等关键主题上打下坚实基础。课程重点介绍 DevOps,涵盖其核心组件、优势,以及持续集成与持续交付(CI/CD)在优化数据工程工作流中所发挥的作用。

您将学习如何在 PySpark 中应用模块化原则,以创建可复用组件并高效组织代码结构。实践环节包括:使用 pytest 框架为 PySpark 函数设计并实现单元测试,以及使用 Spark Declarative Pipeline 和 Jobs 对 Databricks 数据管道进行集成测试,以确保其可靠性。

课程还涵盖 Databricks 中的基本 Git 运营操作,包括使用 Databricks Git Folders 集成持续集成实践。最后,您将从宏观层面了解 Databricks 资产的多种部署方式,例如 REST API、CLI、SDK 以及 Declarative Automation Bundles(DABs),从而掌握部署和管理管道的相关技术知识。

完成本课程后,您将熟练掌握软件工程与 DevOps 最佳实践,从而能够构建可扩展、易维护且高效的数据工程解决方案。

注意:

1. 这是“Data Engineering with Databricks”系列课程中的第四门课程。

2. 对于 SCORM 课程文件,请确保完成内容后关闭 SCORM 窗口。请勿点击“Next Lesson”按钮,否则可能导致 SCORM 模块无法标记为已完成。

Free
2h
Associate

Questions?

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