Recipe
publicShareStar

Overview of ELT/ETL

Collaborators
Reviewers
Total time needed: ~2 hours
Learning Objectives
Introduce about ELT/ETL process and some useful tools. ETL/ETL tools are the first essential step in the data warehousing process, which helps break down data silos and makes it easy for data scientists to access and analyze data, and turn it into business intelligence.
Potential Use Cases
Learning about data management in MLOps
Target Audience
BEGINNERML Engineer
Go through the following annotated items in order:
ARTICLE 1. Data Engineering (CS 329S)
  • What is OLTP and OLAP?
  • What is structured and unstructured data?
  • What is ELT and ETL?
10 minutes
ARTICLE 2. What is Extract, Transform, Load? Definition, Process, and Tools
  • How ETL works?
20 minutes
ARTICLE 3. What is ELT
  • How ELT works?
  • What is the benefits of ELT?
  • What is the different of ELT and ETL?
20 minutes
ARTICLE 4. ELT Tools
  • What are some ELT tools?
20 minutes

Concepts Covered