In this chapter, you’ll learn what data engineering is and why demand for them is increasing. You’ll then discover where data engineering sits in relation to the data science lifecycle, how data engineers differ from data scientists, and have an introduction to your first complete data pipeline.

Data engineering and big data

Data science workflow

Go with the flow

Options

Data engineering tasks

Not data engineering tasks

Not responsible

True

False

Big time

Data engineers vs. data scientists

Tell me the truth

Data engineer

Data scientist

Who is it

The data pipeline

It's not true

Pipeline

What is data engineering?

It’s time to talk about data storage—one of the main responsibilities for a data engineer. In this chapter, you’ll learn how data engineers manage different data structures, work in SQL—the programming language of choice for querying and storing data, and implement appropriate data storage solutions with data lakes and data warehouses.

Data structures

Structures

What's the difference

SQL databases

We can work it out

Columns

Different breeds

Data warehouses and data lakes

Tell the truth

Our warehouse (in the middle of our street)

Storing data

Data engineers make life easy for data scientists by preparing raw data for analysis using different processing techniques at different steps. These steps need to be combined to create pipelines, which is when automation comes into play. Finally, data engineers use parallel and cloud computing to keep pipelines flowing smoothly.

Processing data

Connect the dots

Scheduling data

Schedules

One or the other

Parallel computing

Whenever, whenever

Parallel universe

Cloud computing

Obscured by clouds

Somewhere I belong

We are the champions

Moving and processing data

Lexicon

Course Glossary: Understanding Data Engineering

In 2019, the average salary for data engineers overtook data scientists. How did this happen? Companies wanting to find the gold within their data realized it wasn’t possible if they hadn’t yet built the mine. Data engineers lay the foundations that make data science possible.
<br /> <br />
In this course, you’ll learn about a data engineer’s core responsibilities, how they differ from data scientists, and facilitate the flow of data through an organization. Through hands-on exercises you’ll follow Spotflix, a fictional music streaming company, to understand how their data engineers collect, clean, and catalog their data. By the end of the course, you’ll understand what your company's data engineers do, be ready to have a conversation with a data engineer, and have a solid foundation to start your own data engineer journey.

The videos contain live transcripts, which can be accessed by clicking "Show transcript" at the bottom left of the videos.

The course glossary can be found on the right in the resources section.

To obtain CPE credits you need to complete the course and reach a score of 70% on the qualified assessment. You can navigate to the assessment by clicking on the CPE credits callout on the right.

<h2> Understand the Basics of Data Engineering </h2>
<br>
In this course, you’ll learn about a data engineer’s core responsibilities, how they differ from data scientists, and facilitate the flow of data through an organization. Through hands-on exercises you’ll follow Spotflix, a fictional music streaming company, to understand how their data engineers collect, clean, and catalog their data. 
<br><br>
<h2> Apply in Personal Cases</h2>
<br>
By the end of the course, you’ll understand what your company's data engineers do, be ready to have a conversation with a data engineer, and have a solid foundation to start your own data engineer journey.

Discover how data engineers lay the groundwork that makes data science possible. No coding involved!

Data Engineering for Everyone

Understanding Data Engineering

Associate Data Engineer in SQL

Data Analyst in Databricks

Understanding Data Topics

Extract the songs Julian listened to the most over the past month

Find other users who listened to these same songs a lot as well

Load only the 10 top songs these users listened to the most over the past week  into a table called "Similar profiles"

Extract only songs these other users listen to that are of the same genre as the ones in Julian's listening sessions. These are our recommendations.

Load the recommended songs into a new table. That's Julian's Weekly Playlist!

Pipeline

Understanding Data Engineering

Praktische interactieve oefening