Wrestling with Data

In this lesson, we're going to do a deep dive into the various tools and techniques available for manipulating information and data sources along with showing you at the end of it how you can actually solve some real-world problems.

If you are trying to handle increasingly complex data sets and round out your experience as a professional data engineer, this is a great lesson to get a practical field-based understanding.

Learning Objectives

• Learn to determine when it's appropriate to use a programmatic approach versus pure SQL.
• How to access and manipulate your files and data sources using programming techniques available to you in languages such as Python.

Prerequisites

•  Familiarity with relational databases and other data formats such as CSVs and JSON.
•  Baseline understanding of SQL

If you don't have all of these this lesson will still benefit you, but you might not be able to follow all of the examples.