Python SQL Fundamentals

This workshop introduces the fundamentals of SQL, with a focus on using SQLite (the most ubiquitous database on the planet) for data science tasks. We'll explore how SQL can be used to query and manipulate relational databases, leveraging pandas to interact with the results in Python. This hands-on workshop includes exercises based on real-world datasets.

Key Topics Covered:

Introduction to SQL and relational databases

SQLite setup and integration with Python (pandas)

Basic SQL operations: SELECT, WHERE, JOIN, GROUP BY, and more

Querying SQLite databases with pandas Working with real-world datasets