Module 02 of 10

Python & SQL for Data

Lessons

About This Module

Almost every data pipeline is built from two languages. Python is the glue: it pulls data from APIs and files, reshapes it, and ties systems together. SQL is how you ask questions of data that lives in databases and warehouses. If you can write both well, you can build most of what a data engineer is asked to build.

You'll start with Python for data engineering: the language fundamentals, then working with real datasets using pandas. You'll practice the everyday job of cleaning messy data, including removing duplicates, handling missing values, and standardizing columns.

Then you'll move past the basics of SQL. The lessons cover joins and CTEs for building readable multi-step queries, and window functions such as ranking, running totals, and comparing a row with the rows around it, without collapsing your results.

With both languages in hand, you'll be ready for the next module, Linux, Git & the Command Line, where you learn to run, version, and automate the code you write.

Lessons

5 videos
01

Python Full Course for Data Engineers

A long-form, all-in-one course that teaches Python with data engineering in mind, leading into PySpark and big data. Watch it in sections and code along as you go.

02

How to Clean Data in Python (Step-by-Step Pandas Tutorial)

Take a messy dataset and clean it the way a working data professional would, using pandas to fix the problems real data always has.

03

Advanced SQL Tutorial: JOIN, CTE, Window Functions & More

A fast tour of the SQL concepts that matter most once you're past the basics: joins, CTEs, window functions, aggregation, and query optimization.

04

SQL Window Functions Basics (Visually Explained)

A visual explanation of how window functions work, using PARTITION BY, ORDER BY, and the window frame to analyze data across rows.

05

SQL Window Functions for Beginners

A hands-on introduction to window functions in DuckDB, covering ROW_NUMBER, LEAD, LAG, and the WINDOW clause on a real dataset.