Title: Building ETL and Data Pipelines with Bash, Airflow and Kafka

Location: US

Company: IBM

About this course:

Well-designed and automated data pipelines and ETL processes are the foundation of a successful Business Intelligence platform. Defining your data workflows, pipelines and processes early in the platform design ensures the right raw data is collected, transformed and loaded into desired storage layers and available for processing and analysis as and when required.

This course is designed to provide you the critical knowledge and skills needed by Data Engineers and Data Warehousing specialists to create and manage ETL, ELT, and data pipeline processes.

Upon completing this course you’ll gain a solid understanding of Extract, Transform, Load (ETL), and Extract, Load, and Transform (ELT) processes; practice extracting data, transforming data, and loading transformed data into a staging area; create an ETL data pipeline using Bash shell-scripting, build a batch ETL workflow using Apache Airflow and build a streaming data pipeline using Apache Kafka.

You’ll gain hands-on experience with practice labs throughout the course and work on a real-world inspired project to build data pipelines using several technologies that can be added to your portfolio and demonstrate your ability to perform as a Data Engineer.

This course pre-requisites that you have prior skills to work with datasets, SQL, relational databases, and Bash shell scripts.

Describe and differntiate between Extract, Transform, Load (ETL) and Extract, Load, Transform (ELT) processes

Define data pipeline components, processes, tools and technologies

Create ETL processes using Bash shell scripts

Develop batch data pipelines using Apache Airflow

Create streaming data pipelines using Apache Kafka

This course provides you with practical skills to build and manage data pipelines and Extract, Transform, Load (ETL) processes using shell/python scripts, Airflow and Kafka.

Duration: 5 weeks

Skills:

- Apache Airflow

- Apache Kafka

- Bash (Scripting Language)

- Business Intelligence

- Data Pipelines

- Data Warehousing

- Extract Transform Load (ETL)

- Python (Programming Language)

- Relational Databases

- SQL (Programming Language)

- Scripting

- Shell Script

- Staging Area

- Workflow Management

- Workflows

Curriculum:

- Describe and differntiate between Extract, Transform, Load (ETL) and Extract, Load, Transform (ELT) processes

- Define data pipeline components, processes, tools and technologies

- Create ETL processes using Bash shell scripts

- Develop batch data pipelines using Apache Airflow

- Create streaming data pipelines using Apache Kafka