Data Engineering Foundations

Data Engineering Foundations

1h 4mIntermediate2021-02-17

Authors

Harshit Tyagi

Harshit Tyagi

Data Science Instructor and Mentor

Course details

Data science can be generally defined as the process of making data useful, and data engineering is a key part of how and why. If you think of data science like a race car, the data engineers are the pit crew. They’re not driving the car, but they make the car much easier to drive. Data engineers make sure the data flow is running smoothly, monitor systems, anticipate problems, and repair the data pipeline whenever problems arise. They extract and gather data from multiple sources and load it into a single, easy-to-query database. In short, data engineers make data scientists’ lives easier.

In this course, Harshit Tyagi explains the fundamentals of data engineering. He covers key topics like data wrangling, database schema, and developing ETL pipelines. He also details several data engineering tools like Hive, Hadoop, Spark, and Airflow. By the end of this course, it should be abundantly clear why the data engineer is one of the most valuable people in a data-driven organization.

Skills covered

HiveHadoopVisual Studio CodePostgreSQLApache SparkApacheData EngineeringFoundationsData ScienceOpen SourceMicrosoft

Concepts

Introduction

  • What is data engineering

Introduction to Data Engineering

  • Introduction to data engineering
  • Data engineer vs. data scientist
  • Essential tools for data engineering

Databases and Dataframes

  • Intro to databases and their types
  • Understanding database schema
  • Distributive computing

Data Engineering Tools

  • MapReduce and Hadoop
  • Hive
  • Spark
  • Airflow

ETL Pipelines

  • Sources of data extraction
  • Data extraction from a PostgreSQL database
  • Challenge - Data extraction
  • Solution - Data extraction
  • Transforming data
  • Challenge - Transforming data
  • Solution - Transforming data
  • Loading data into a DB
  • Challenge - Loading data
  • Solution - Loading data
  • Scheduling ETL pipeline using Airflow

Conclusion

  • Next steps
40,000 Toman