SciPy 2025

Alex Monahan

Hello, I'm Alex! I am a customer software engineer at MotherDuck and I blog for DuckDB Labs. My background is Industrial and Systems Engineering from Virginia Tech, but I've decided I prefer working with data!

I joined MotherDuck 2 years ago after 9 years at Intel. I started at Intel as an industrial engineer, later became a technical analyst, and then jumped into a data scientist role. Back in 2020 I discovered DuckDB while building an internal self service analytics platform and became one of DuckDB's biggest Twitter fans! I have been diving deeper into Duck-themed databases ever since.

The speaker's profile picture

Sessions

07-07
08:00
240min
All the SQL a Pythonista needs to know: an introduction to SQL and DataFrames with DuckDB
Guen Prawiroatmodjo, Alex Monahan

Structured Query Language (or SQL for short) is a programming language to manage data in a database system and an essential part of any data engineer’s tool kit. In this tutorial, you will learn how to use SQL to create databases, tables, insert data into them and extract, filter, join data or make calculations using queries. We will use DuckDB, a new open source embedded in-process database system that combines cutting edge database research with dataframe-inspired ease of use. DuckDB is only a pip install away (with zero dependencies), and runs right on your laptop. You will learn how to use DuckDB with your existing Python tools like Pandas, Polars, and Ibis to simplify and speed up your pipelines. Lastly, you will learn how to use SQL to create fast, interactive data visualizations, and how to teach your data how to fly and share it via the Cloud.

Tutorials
Room 318