Covers: theory of Data Management
Estimated time needed to finish: 10 minutes
Questions this item addresses:
  • What is OLTP and OLAP?
  • What is structured and unstructured data?
  • What is ELT and ETL?
How to use this item?

This lecture notes provides the overview of database type and explain why we have to use ETL/ELT.
Read from "OLTP vs OLAP" section to "ETL to ELT" section. This note is from "CS 329S: Machine Learning Systems Design" course where you can learn more MLOps concepts.

Author(s) / creator(s) / reference(s)
Chip Huyen: https://www.linkedin.com/in/chiphuyen/
0 comment
Recipe
publicShare
Star(0)

Overview Of Elt/etl

Contributors
Total time needed: ~2 hours
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
Who is This For ?
BEGINNERML Engineer
Click on each of the following annotated items to see details.
Resources4/4
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

0 comment