Building ETL Pipelines with SQL - Mandarin Chinese

本课程讲授如何在 Databricks Data Intelligence Platform 上使用纯 SQL 构建生产就绪的 ETL 管道。学员将学习以下内容：使用 Auto Loader 的流式处理表（用于增量摄取）、具有增量刷新功能的物化视图（用于白银到黄金的转换）、AUTO CDC（FLOW AUTO CDC）（用于声明式 SCD Type 1 和 Type 2 维度管理），以及 Apache Spark Declarative Pipelines（SDP）——将上述对象组合成具有数据质量期望、PRIVATE 表和统一监控功能的生产多表管道。本课程以一个真实的零售数据集为例，贯穿金银铜架构（铜 → 白银 → 黄金）的完整流程。使用 Lakeflow Jobs 进行编排作为附加模块提供。

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

Skill Level

Associate

Duration

Prerequisites

本课程的内容面向具备以下技能、知识和能力的学员:

• 导航 Databricks 工作区（侧边栏、Catalog Explorer、SQL Editor）

• Unity Catalog 基础知识（目录、模式、表、卷）

• 中级 SQL（SELECT、JOIN、GROUP BY、CAST、COALESCE、CREATE TABLE）

• 数据仓库概念（事实表/维度表、星型模式、金银铜架构）

• 对 ETL 工作流的基本了解

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.

Customer registration Partner registration

Private Class Request

If your company is interested in private training, please submit a request.

Request Private Training

See all our registration options

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

Instructor-Led

Public and private courses taught by expert instructors across half-day to two-day courses

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

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

Deploying and Monitoring Agent Applications on Databricks

This course covers the end-to-end lifecycle for deploying and monitoring generative AI agents on Databricks. Participants will learn how to deploy agents as Databricks Apps using Declarative Automation Bundles (DABs), integrate tools via the Model Context Protocol (MCP), instrument agents with MLflow Tracing, and evaluate production quality using scorers, multi-turn judges, and online evaluation. Through hands-on demos and labs, participants will gain practical experience building, observing, and monitoring production-grade AI agents on the Databricks platform.

Note: Databricks Academy is transitioning to a notebook-based format for classroom sessions within the Databricks environment, discontinuing the use of slide decks for lectures. You can access the lecture notebooks in the Vocareum lab environment.

Building Agentic Applications on Databricks

This course teaches students how to build production-grade agentic applications on Databricks. Students learn to create governed agent tools using Unity Catalog and MCP, build single and multi-agent systems with the OpenAI Agents SDK, and leverage Agent Bricks and Genie for knowledge-assistant use cases orchestrated with a supervisor agent. The course covers the full progression from tool prototyping to production deployment, with hands-on experience using MLflow tracing to observe agent execution.

Building RAG Agents with Agent Bricks

This course provides hands-on training for building retrieval agents using Databricks Agent Bricks. Participants will learn to explore and query Knowledge Assistants, parse unstructured documents into structured data using AI Functions, chunk text for semantic retrieval, build Vector Search indexes, and create production-ready Knowledge Assistants backed by multiple knowledge sources.