dbt（数据构建工具） - 分析工程师的 dbt

上次更新时间：2024-10-31

课程售价: 2.9 元

联系右侧微信客服充值或购买课程

课程内容

1. dbt(data build tool) Connections

1. dbt Introduction (免费)
1.1 dbtOverview (免费)
2. Create a GitHub Repository
3. Free Trial Account
4. Data loading From AWS S3 Bucket
5. Python Installation
6. dbt Cloud connection with Snowflake and Github
7. dbt Core Installation

2. dbt(data build tool) Data Warehouse Fundamentals

1. Data Warehouse Concepts
2. Benefits and Limitation of Data Warehouse
3. ETL in Data Warehouse
4. ETL vs ELT
5. Overview of OLTP

3. dbt(data build tool) Models, Sources & Seeds

1. Create your First Models
2. Creating a Sample Tables for Models
3. Use of Ref Function in dbt Model
4. Creating a Python Model in dbt
5. Creating a Second Python Model in dbt
6. Sources in dbt(data build tool)
7. Source Freshness in dbt
8. Seeds in dbt(data build tool)

4. Materialization in dbt(data build tool)

1. Ephemeral Model
2. Incremental Model Part-01
3. Incremental Model Part-02
4. Incremental Model Part-03
5. delete+Insert Model

5. Snapshots in dbt(data build tool)

1. Slowly Changing Dimensions Concepts
2. Timestamp Strategy SCD TYPE 2
3. CHECK STRATEGY SCD TYPE 2

6. Jinja Basic Fundamentals

1. Jinja Introduction
2. Jinja Basics - Control Structures
3. Use of Jinja in dbt model Part-01
4. Use of Jinja in dbt Part-02

7. dbt(Data build tool) Macros and Hooks

1. Macro in dbt(data build tool) Part-1
2. Macros in dbt(data build tool) Part-2
3. dbt Hooks
4. dbt documentation

8. dbt Testing

1. dbt testing
2. Singular Testing
3. Generic Testing Part-01
4. Severity Test in dbt
5. dbt Store failure and limit Config
6. Custom Generic Test
7. dbt_utils
8. dbt_expectations
9. Audit_helper

网站首页 > 编程开发 > 其他

dbt（数据构建工具） - 分析工程师的 dbt

上次更新时间：2024-10-31 09:33

课程售价：2.9元

联系客服微信，购买课程或充值

请登录网站 , 没有账号点击这里注册

课程内容

8个章节 , 46个讲座

1. dbt(data build tool) Connections

1. dbt Introduction (免费)
1.1 dbtOverview (免费)
2. Create a GitHub Repository
3. Free Trial Account
4. Data loading From AWS S3 Bucket
5. Python Installation
6. dbt Cloud connection with Snowflake and Github
7. dbt Core Installation

2. dbt(data build tool) Data Warehouse Fundamentals

1. Data Warehouse Concepts
2. Benefits and Limitation of Data Warehouse
3. ETL in Data Warehouse
4. ETL vs ELT
5. Overview of OLTP

3. dbt(data build tool) Models, Sources & Seeds

1. Create your First Models
2. Creating a Sample Tables for Models
3. Use of Ref Function in dbt Model
4. Creating a Python Model in dbt
5. Creating a Second Python Model in dbt
6. Sources in dbt(data build tool)
7. Source Freshness in dbt
8. Seeds in dbt(data build tool)

4. Materialization in dbt(data build tool)

1. Ephemeral Model
2. Incremental Model Part-01
3. Incremental Model Part-02
4. Incremental Model Part-03
5. delete+Insert Model

5. Snapshots in dbt(data build tool)

1. Slowly Changing Dimensions Concepts
2. Timestamp Strategy SCD TYPE 2
3. CHECK STRATEGY SCD TYPE 2

6. Jinja Basic Fundamentals

1. Jinja Introduction
2. Jinja Basics - Control Structures
3. Use of Jinja in dbt model Part-01
4. Use of Jinja in dbt Part-02

7. dbt(Data build tool) Macros and Hooks

1. Macro in dbt(data build tool) Part-1
2. Macros in dbt(data build tool) Part-2
3. dbt Hooks
4. dbt documentation

8. dbt Testing

1. dbt testing
2. Singular Testing
3. Generic Testing Part-01
4. Severity Test in dbt
5. dbt Store failure and limit Config
6. Custom Generic Test
7. dbt_utils
8. dbt_expectations
9. Audit_helper