Lesson 1: Introduction

• 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

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

Lesson 4: ETL with APIs

• Overview
• APIs
• API resource
• ETL with API
• API Dagster assets
• 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
• Sling
• Sling database replication set up
• Dagster and Sling
• Managing Sling assets

Lesson 7: ETL with Components

• Overview
• Dagster Components
• Sling with Components
• Using Components
• Organizing our project