Udemy
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Data Engineering: From Zero to Hero
Rating: 4.1 out of 5(9 ratings)
40 students

Data Engineering: From Zero to Hero

Learn data engineering from scratch: ETL/ELT data pipelines, data modeling, SQL in Snowflake, Python and Apache Airflow
Last updated 10/2026
English
English [Auto],

What you'll learn

  • Explain what data engineering is and what a data engineer does day to day, from building data pipelines to serving analytics and BI
  • Extract data from a REST API with Python (requests and pandas) and export it to CSV, in a real-world earthquake data project
  • Compare data warehouses, data lakes, lakehouses, data marts and NoSQL databases, and choose the right one for each use case
  • Design ETL and ELT data pipelines and decide when to use batch processing vs real-time streaming
  • Model data for analytics with the star schema, snowflake schema, Data Vault and the medallion architecture (bronze, silver, gold)
  • Design fact and dimension tables with surrogate keys and slowly changing dimensions (SCD Type 0, 1, 2 and 3)
  • Write SQL in Snowflake from scratch: filtering, aggregations, joins, subqueries, CTEs and window functions
  • Build a star schema sales data mart in Snowflake with an ELT pipeline using stages, COPY INTO, tasks and stored procedures
  • Clean, transform and validate datasets with SQL and Python pandas: duplicates, missing values, standardization and data quality checks
  • Orchestrate data pipelines with Apache Airflow: DAGs, scheduling, tasks, dependencies, operators, sensors and the Airflow UI
  • Understand the cloud data stack (AWS, Azure, GCP), OLTP vs OLAP, and file formats such as CSV, JSON, Parquet and Avro
  • Confidently discuss data engineering concepts in job interviews and with data teams

Course content

8 sections • 123 lectures • 7h 4m total length
  • Welcome to the Course0:59

    Welcome to Data Engineering: From Zero to Hero, a hands-on course that takes you from the basics to building real data pipelines. Find out what you will build, which tools you will use (SQL, Python, Snowflake and Apache Airflow) and how to get the most out of each section.

  • About Me, You and this Course2:19

    Meet your instructor, a data professional with 10+ years of experience as a data analyst, data scientist and data engineer. See who this data engineering course is for, from complete beginners and career changers to junior data engineers, and what you will be able to do by the end.

  • Course Outline1:38

    A walkthrough of the full data engineering curriculum: the data ecosystem, data sources and destinations, data modeling, SQL with Snowflake, data wrangling with Python, and pipeline orchestration with Airflow. Use it as a roadmap to plan your learning path.

  • Things you will need0:44

    The software and free accounts you need to follow along: Python, VS Code, a virtual environment, Jupyter Notebooks and a free Snowflake trial. Everything in the setup lectures is optional, so you can skip what you already have installed.

  • [OPTIONAL] Installing Python on MacOS1:45

    tep-by-step guide to installing Python on MacOS for data engineering work. You will install the latest Python 3 version, check it from the terminal and get ready to run the scripts used throughout the course.

  • [OPTIONAL] Installing VSCode on MacOS6:22

    Install Visual Studio Code on MacOS and set it up as your Python and SQL editor. Learn which VS Code extensions help data engineers write, run and debug code more efficiently.

  • [OPTIONAL] Creating a Virtual Environment on MacOS2:26

    Learn how to create and activate a Python virtual environment (venv) on MacOS. Virtual environments keep each data project's libraries isolated, a best practice every data engineer should follow.

  • [OPTIONAL] Installing Relevant Python Libraries on Virtual Environment on MacOS2:00

    Install the core Python libraries for data engineering, such as pandas and requests, inside your virtual environment using pip. You will also learn how to keep a requirements file so your setup is reproducible.

  • [OPTIONAL] Testing Setup on MacOS4:14

    Run a quick test script to confirm Python, VS Code, your virtual environment and pandas all work together on MacOS. Fix common setup errors now so nothing blocks you in the hands-on lectures.

  • [OPTIONAL] Jupyter Notebooks4:14

    In this lecture, I go through Jupyter Notebooks, a useful tool for a Data Engineer

Requirements

  • No data engineering experience needed: everything is explained from the basics
  • No SQL experience required: SQL is taught from scratch, from your first SELECT to window functions
  • Basic Python knowledge is helpful but not mandatory
  • A computer with internet access where you can install Python and VS Code (free)
  • A free Snowflake trial account; the course shows you how to create one

Description

Learn data engineering from scratch and build the skills to design, build and orchestrate real data pipelines, with no prior data engineering experience required.


Data Engineering: From Zero to Hero is a hands-on course for anyone who wants to understand how data is collected, stored, modeled, transformed and delivered in modern companies. You will learn the concepts, then apply them with the tools used in real data teams: SQL, Snowflake, Python (pandas) and Apache Airflow.


Whether you are a data analyst moving into engineering, a software engineer curious about data, or a career changer starting from zero, this course gives you a clear, practical path into one of the most in-demand roles in tech.


What you will learn

  • Data engineering fundamentals: what a data engineer does, the core skills and the modern data stack

  • The data ecosystem: cloud computing (AWS, Azure, GCP), structured vs unstructured data, file formats like JSON, Parquet and Avro, and OLTP vs OLAP

  • Data sources and destinations: operational databases, REST APIs, data warehouses, data lakes, lakehouses, data marts and NoSQL

  • Data pipelines: ETL vs ELT, and batch vs real-time streaming with Kafka and pub/sub

  • Data modeling: star schema, snowflake schema, fact and dimension tables, slowly changing dimensions, Data Vault and the medallion architecture

  • SQL with Snowflake: from SELECT basics to joins, subqueries, CTEs and window functions, ending with a star schema sales data mart

  • Data wrangling with SQL and Python: deduplication, missing values, standardization, transformations and data validation

  • Pipeline orchestration with Apache Airflow: DAGs, scheduling, tasks and dependencies, operators, sensors and the Airflow UI


Learn by doing

Every major topic has a practical example, a hands-on assignment with a full video solution, and a quiz. You will pull earthquake data from a real API with Python, write SQL in your own free Snowflake account, clean and transform datasets with pandas, and build an Airflow DAG.


Taught by a practitioner

Your instructor has more than 10 years of experience working as a data analyst, data scientist and data engineer, and focuses on what you will actually use on the job.

By the end of this course you will understand how data flows through an organization, and you will be ready to build your own data pipelines or take the next step toward a data engineering role. Enroll now and start your data engineering journey.

Who this course is for:

  • Beginners who want to start a career in data engineering from zero
  • Data analysts and BI developers who want to move into data engineering
  • Software engineers curious about data pipelines, SQL and Airflow
  • Data scientists who want to build and own the pipelines behind their models
  • Junior data engineers who want a solid foundation in data modeling, SQL and orchestration
  • Students and career changers preparing for data engineering job interviews