Skip to main content

Get Started with Databricks for Data Warehousing - Mandarin Chinese

本课程提供了对 Databricks 现代数据仓库方法的全面实践概述,重点介绍数据湖仓架构如何将传统数据仓库的优势与云平台的灵活性和可扩展性相结合。通过与虚构零售商(Vintage Audio Co.)的端到端实践,您将浏览 workspace,查询受治理的 Unity Catalog 表,保持 Unity Catalog 托管表的分析读取高效性,使用 Auto Loader 增量加载数据,构建星型模式,并通过 Unity Catalog metric views 提供一致的洞察——所有这些均在单一受治理的环境中完成,并全程内置 AI 驱动功能(Predictive Optimization、Genie Code)。

Skill Level
Onboarding
Duration
3h
Prerequisites

本课程内容专为具备以下技能、知识和能力的学员而设计:

• 对数据仓库领域有基本了解(了解数据仓库、表以及 BI 工具的概念)。

• 掌握 SQL 的实用知识(包括带 WHERE 子句的 SELECT、GROUP BY、聚合函数以及 JOIN)。

• 无需具备 Databricks 相关知识;Databricks 特有概念(Unity Catalog、Delta Lake、SQL Warehouses、metric views)将在涉及时逐一介绍。

Self-Paced

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

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

Databricks Performance Optimization

Databricks Performance Optimization teaches data engineers and analysts how to diagnose, measure, and fix performance bottlenecks on the Databricks Data Intelligence Platform, and how to tie performance improvements back to cost. The course follows a measurement-first, platform-first workflow: let the platform's automatic optimizations do the heavy lifting, verify what was applied using Query Profile and system tables, then manually tune where needed.

Learners build a foundation for measuring performance with Query Profile, Performance Insights, and query history system tables. From there, they explore key optimization techniques, including data layout and self-tuning managed tables, liquid clustering, caching and intermediate results, shuffle, skew, spill, row explosions, driver performance, Python UDFs, serverless compute, Photon, and cost attribution.

Throughout the course, learners explore deliberately slow queries over synthetic retail data and see how different optimization techniques affect performance. They use evidence such as file pruning, task execution time, Photon coverage, and cost to evaluate improvements. Two scenario-based labs reinforce the optimization workflow from diagnosis through validation.

Note: 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
3h
Lab
Professional

Questions?

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