Lesson 1: Introduction to ETL with Dagster

• About this course
• What is ETL?
• ETL and Dagster
• Project preview

Lesson 2: Installation & Setup

• Requirements
• Set up local
• Set up Codespace

Lesson 3: Loading Static Data into DuckDB

• Overview
• File import
• Data integrity
• Partitions
• Complex partitions
• Triggering partitions

Lesson 4: ETL with APIs

• Overview
• APIs
• API resource
• ETL with API
• API Dagster
• Triggering API jobs
• Backfilling from APIs

Lesson 5: Embedded ETL

• Overview
• dlt
• Basic dlt
• Dagster and dlt
• Refactoring static data with dlt
• Refactoring APIs with dlt

Lesson 6: Database replication

• Overview
• Database replication
• dlt database replication set up
• dlt database assets
• Executing pipeline

Lesson 7: ETL with Components

• Overview
• Dagster Components
• dlt with components
• Using components