SQL Programming and Procedural Logic - Mandarin Chinese

在本课程中，您将在 Databricks 中探索核心 SQL 编程与过程逻辑技能，重点学习如何构建模块化、可维护且可用于生产的分析工作流。您将首先了解关键 SQL 构造——例如公用表表达式（包括高级递归 CTE）、会话作用域对象（如临时视图和临时表）以及用户定义函数——这些构造可使您的 SQL 开发更加简洁且可复用。随后，课程将引导您学习使用复合语句、变量、控制流、条件语句、循环以及完善的错误处理等高级 SQL 脚本编写技术，以创建结构化且灵活的 SQL 流程。您还将学习如何在这些多步骤管道中使用符合 ACID 规范的多语句事务来保证数据一致性。最后，您将了解如何将逻辑封装到 SQL 存储过程中，并使用 Lakeflow Jobs 和迁移策略编排复杂工作流，将遗留任务转换为模块化、自动化的管道，充分发挥 Databricks 平台的全部能力。

注意：对于 SCORM 讲授文件，请确保在完成内容后关闭 SCORM 窗口。请勿点击“Next Lesson”按钮，否则可能导致 SCORM 模块无法被标记为已完成。

Skill Level

Associate

Duration

Prerequisites

本课程内容面向具备以下技能/知识/能力的学员：

• 对 SQL 工作区、数据仓库和 Databricks 笔记本（SQL、Python 和 markdown）有基本了解 - 具备使用 Databricks Lakehouse 架构的实践经验，包括使用 Delta Lake 和 Unity Catalog 进行数据管理和数据治理

• 熟悉为数据管道和编排创建及管理工作流

• 具备在关系型数据库中使用 SQL 查询和分析数据的先前经验，包括使用存储过程以及动态或参数化查询

• 具备数据迁移或现代化项目的实践经验，涵盖核心数据仓库概念，如 ETL、架构设计、数据建模和 BI 报告

• 了解数据管道编排和合规最佳实践，并理解 ANSI SQL 标准

Self-Paced

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

Customer registration Partner registration

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

Machine Learning Practitioner

Data Preparation for Machine Learning

This course focuses on the fundamentals of preparing data for machine learning using Databricks. Participants will learn essential skills for exploring, cleaning, and organizing data tailored for traditional machine learning applications. Key topics include data visualization, feature engineering, and optimal feature storage strategies. Through practical exercises, participants will gain hands-on experience in efficiently preparing data sets for machine learning within the Databricks. This course is designed for associate-level data scientists and machine learning practitioners. and individuals seeking to enhance their proficiency in data preparation, ensuring a solid foundation for successful machine learning model deployment.

Note:

1. This is the first course in the 'Machine Learning with Databricks’ series.

2. For SCORM lecture files, please ensure that you close the SCORM window after completing the content. Do not click the ‘Next Lesson’ button, as doing so may prevent the SCORM module from being marked as complete.

Paid & Subscription

Lab

Associate

Platform Administrator

Get Started with Data Governance on Databricks

In this course, you will explore Unity Catalog and fine-grained access controls on Databricks with hands-on demos and a capstone lab. You will learn about table types, catalog and schema configuration, group-based access management, and access control migration strategies. The course includes demos on applying Fine-Grained Access Controls with Row Level Security and Column Masking, Attribute based access control, combining controls, migrating controls, and a lab for comprehensive governance implementation.

Languages Available: English | 日本語 | 한국어

Paid & Subscription

Lab

Onboarding

Introduction to Lakebase: What and Why

Establishes what Lakebase is and why it exists as fully managed Postgres on the lakehouse with unified governance. Built on the lecture-demo pattern (teach a concept, immediately run it), the course anchors four canonical use cases — each proven with a named customer story — and a three-signal decision framework for choosing between Lakebase, Delta, and the Lakehouse. It is the entry point for the Lakebase pathway; the use cases and decision tree introduced here are expanded by every later course in the series.

Paid & Subscription

Lab

Associate