Back to ETL and Data Pipelines with Shell, Airflow and Kafka
IBM

ETL and Data Pipelines with Shell, Airflow and Kafka

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. In this course, you will learn about the different tools and techniques that are used with ETL and Data pipelines. Both ETL and ELT extract data from source systems, move the data through the data pipeline, and store the data in destination systems. During this course, you will experience how ELT and ETL processing differ and identify use cases for both. You will identify methods and tools used for extracting the data, merging extracted data either logically or physically, and for loading data into data repositories. You will also define transformations to apply to source data to make the data credible, contextual, and accessible to data users. You will be able to outline some of the multiple methods for loading data into the destination system, verifying data quality, monitoring load failures, and the use of recovery mechanisms in case of failure. By the end of this course, you will also know how to use Apache Airflow to build data pipelines as well be knowledgeable about the advantages of using this approach. You will also learn how to use Apache Kafka to build streaming pipelines as well as the core components of Kafka which include: brokers, topics, partitions, replications, producers, and consumers. Finally, you will complete a shareable final project that enables you to demonstrate the skills you acquired in each module.

IntermediateCourse18 hours

Featured reviews

SK

5.0Reviewed Jan 21, 2025

Relevant information in recordings, good recap of every video and hand-on lesson in the end to concrete the knowledge.

JJ

5.0Reviewed Jul 23, 2023

Labs in this course are very helpful and to the point. It took me a while to complete this course but i learned a lot.

YC

4.0Reviewed Jan 17, 2022

Love the labs, but do not like the robotic lectures.

RS

5.0Reviewed Mar 14, 2022

Succinctly presented. Labs really hammered the point home :)

TK

5.0Reviewed Jul 23, 2023

Great hands-on (alike the others in the pack)! Practical and interactive.

KB

5.0Reviewed Apr 24, 2022

Nice intro to ETL and Data Pipelines. Beginner level easy to follow hands on Airflow and Kafka.

RR

5.0Reviewed Aug 28, 2024

Muy satisfecho con el contenido del curso, y los laboratorios. Thank you very much!

DS

5.0Reviewed Jun 14, 2022

Excellent introduction to this topics. Labs contain all you need to know how to start using this type of technologies. Highly recommended.

PM

4.0Reviewed Mar 24, 2023

it was good course should have also given an information on industry related solution and they can implement the same.

OH

4.0Reviewed Jan 26, 2022

It's great introduction for airflow and kafka but still an introduction it is shallow doesn't offer much but at the end you will understand what you need to continue further in both technologies.

DR

4.0Reviewed Jun 4, 2022

Good introduction to Airflow and Kafka however only one airflow operator is explored

MD

5.0Reviewed Mar 12, 2023

Great learning course for Kafka/ Airflow, well presented

All reviews

Showing: 20 of 98

Chris Barton
2.0
Reviewed Apr 21, 2022
Dmitry Kisselev
2.0
Reviewed Sep 18, 2021
Benjamin Anton Andrew
1.0
Reviewed Aug 20, 2022
Tal Melamed
2.0
Reviewed Jul 18, 2022
Nataliya Sashnikova
5.0
Reviewed Oct 13, 2021
RLee
5.0
Reviewed Jan 13, 2022
Евгений Дериглазов
5.0
Reviewed Sep 30, 2021
Santiago Zuluaga Ayala
3.0
Reviewed Sep 16, 2022
bengisu pınar
3.0
Reviewed Aug 17, 2023
Ilya Kolobov
5.0
Reviewed Jan 14, 2022
Gorana Bosic
4.0
Reviewed Oct 6, 2024
Omar Hegazy
4.0
Reviewed Jan 27, 2022
YANGYANG CAI
4.0
Reviewed Jan 18, 2022
BO WANG
1.0
Reviewed Jul 9, 2022
Harald Männle
5.0
Reviewed Sep 30, 2024
David Arango Sampayo
5.0
Reviewed Jun 14, 2022
Natale Foata
5.0
Reviewed Dec 15, 2021
Hugo Adrian Osorio Ortiz
5.0
Reviewed Dec 7, 2021
Chris Weaver
4.0
Reviewed Apr 3, 2022
Sina Salemi Sarmast
4.0
Reviewed May 7, 2022