Delve into the two different approaches to converting raw data into analytics-ready data. One approach is the Extract, Transform, Load (ETL) process. The other contrasting approach is the Extract, Load, and Transform (ELT) process. ETL processes apply to data warehouses and data marts. ELT processes apply to data lakes, where the data is transformed on demand by the requesting/calling application.

ETL and Data Pipelines with Shell, Airflow and Kafka
Ends in 5 days! Save 40% on your access to 10,000+ programs and make a real impact in your career. Save now.

ETL and Data Pipelines with Shell, Airflow and Kafka
This course is part of multiple programs.

Instructor: Yan Luo
71,001 already enrolled
Included with Learn more
461 reviews
Recommended experience
What you'll learn
Describe and contrast Extract, Transform, Load (ETL) processes and Extract, Load, Transform (ELT) processes.
Explain batch vs concurrent modes of execution.
Implement ETL workflow through bash and Python functions.
Describe data pipeline components, processes, tools, and technologies.
Skills you'll gain
Details to know

Add to your LinkedIn profile
See how employees at top companies are mastering in-demand skills

Build your subject-matter expertise
- Learn new concepts from industry experts
- Gain a foundational understanding of a subject or tool
- Develop job-relevant skills with hands-on projects
- Earn a shareable career certificate

Explore more from Data Management
Status: Free Trial
Status: Free Trial
Status: Preview
Status: Free Trial
Why people choose Coursera for their career

Felipe M.

Jennifer J.

Larry W.

Chaitanya A.
Learner reviews
- 5 stars
71.58%
- 4 stars
17.35%
- 3 stars
6.29%
- 2 stars
2.38%
- 1 star
2.38%
Showing 3 of 461
Reviewed on Mar 30, 2023
Overall it's a good course. I wish I could use dos2unix, tr, or sed for removing ^M from the toll_data.tsv. The Final Assignment Instructions could have been clearer.
Reviewed on Jun 3, 2022
Good introduction to Airflow and Kafka however only one airflow operator is explored
Reviewed on Mar 13, 2022
Succinctly presented. Labs really hammered the point home :)
¹ Some assignments in this course are AI-graded. For these assignments, your data will be used in accordance with Coursera's Privacy Notice.




