Skip to main content
HomePythonETL and ELT in Python

ETL and ELT in Python

4.6+
13 reviews
Intermediate

This introductory course will help you hone the skills to build effective, performant, and reliable data pipelines.

Start Course for Free
4 Hours15 Videos57 Exercises
9,657 LearnersTrophyStatement of Accomplishment

Create Your Free Account

GoogleLinkedInFacebook

or

By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.
GroupTraining 2 or more people?Try DataCamp For Business

Loved by learners at thousands of companies


Course Description

Empowering analytics with data pipelines

Data pipelines are at the foundation of every strong data platform. Building these pipelines is an essential skill for data engineers, who provide incredible value to a business ready to step into a data-driven future. This introductory course will help you hone the skills to build effective, performant, and reliable data pipelines.

Building and maintaining ETL and ELT solutions

Throughout this course, you’ll dive into the complete process of building a data pipeline. You’ll grow skills leveraging Python libraries such as `pandas` and `json` to extract data from structured and unstructured sources before it’s transformed and persisted for downstream use. Along the way, you’ll grow confidence in tools and techniques such as architecture diagrams, unit-tests, and monitoring that will help to set your data pipelines out from the rest. As you progress, you’ll put your new-found skills to the test with hands-on exercises.

For Business

GroupTraining 2 or more people?

Get your team access to the full DataCamp library, with centralized reporting, assignments, projects and more
Try DataCamp for BusinessFor a bespoke solution book a demo.

In the following Tracks

Certification Available

Data Engineer in Python

Go To Track

Machine Learning Engineer

Go To Track
  1. 1

    Introduction to Data Pipelines

    Free

    Get ready to discover how data is collected, processed, and moved using data pipelines. You will explore the qualities of the best data pipelines, and prepare to design and build your own.

    Play Chapter Now
    Introducing data pipelines
    50 xp
    What is a data pipeline?
    50 xp
    Components of a data pipeline
    100 xp
    Producers and consumers of data pipelines
    100 xp
    Designing data pipelines
    50 xp
    Architecture diagrams for data pipelines
    50 xp
    Reading architecture diagrams
    50 xp
    Data pipeline design process
    100 xp
    Qualities of great data pipelines
    50 xp
    Building quality data pipelines
    50 xp
    Persisting data throughout a pipeline
    50 xp
    Qualities of sound data pipelines
    100 xp
For Business

GroupTraining 2 or more people?

Get your team access to the full DataCamp library, with centralized reporting, assignments, projects and more

In the following Tracks

Certification Available

Data Engineer in Python

Go To Track

Machine Learning Engineer

Go To Track

Datasets

scores.csvschools_modified.csvamazon_sales_cleaned_sql.csvtax_rate_cleaned.csv

Collaborators

Collaborator's avatar
George Boorman
Collaborator's avatar
Arne Warnke
Collaborator's avatar
Katerina Zahradova
Collaborator's avatar
Anastasia Dvoryanchikova
Jake Roach HeadshotJake Roach

Data Engineer

Jake Roach is a Field Data Engineer at Astronomer and DataCamp Instructor. A former Lead Data Engineer, Jake built a a state-of-the-art data platform for a multi-billion dollar organization, powered by Astronomer, Airflow, AWS, and Databricks. His passion for all things data engineering is contagious. Jake loves to write tutorials, teach DataCamp courses, and contribute to open source. Born and raised in Buffalo, NY, when he's not working with data, you can find him out at the golf course playing a quick nine holes before dark!
See More

Don’t just take our word for it

*4.6
from 13 reviews
69%
23%
8%
0%
0%
Sort by
  • Prasad N.
    about 2 months

    Content is nicely designed and explained with good exercises. Found it to be beneficial.

  • Sorin I.
    6 months

    Excellent courses and practice mode, very nice UI/UX and trainer

  • Robert T.
    8 months

    This was a great intro to the concepts. Overall it walked through a lot of key items all through the ETL process. The section on testing felt a bit rushed and didn't have a ton of explanation to it, but it did talk about the importance of testing the work before sending it to prod.

  • Stefan C.
    8 months

    Good course

  • OLAYEMI O.
    9 months

    Good course

"Content is nicely designed and explained with good exercises. Found it to be beneficial."

Prasad N.

"Excellent courses and practice mode, very nice UI/UX and trainer"

Sorin I.

"This was a great intro to the concepts. Overall it walked through a lot of key items all through the ETL process. The section on testing felt a bit rushed and didn't have a ton of explanation to it, but it did talk about the importance of testing the work before sending it to prod."

Robert T.

Join over 14 million learners and start ETL and ELT in Python today!

Create Your Free Account

GoogleLinkedInFacebook

or

By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.