SQL Workshops

Learn SQL for database querying and data management

Workshop Catalog

These workshops are not currently scheduled but materials are available.

Python SQL Fundamentals
120 minutes
Intermediate

Learn the basics of SQL, with a focus on using SQLite for data science tasks.

Builds on:
Python Fundamentals: Parts 1-3 Python Fundamentals: Parts 4-6
Python Fundamentals: Parts 1-3 Python Fundamentals: Parts 4-6 Python Data Wrangling and Manipulation with Pandas: Parts 1-2
Access Materials
Python SQL Intermediate
120 minutes
Intermediate

Build stronger SQL skills for real-world analysis by learning joins, subqueries, CTEs, and window functions in Python.

Builds on:
Python Fundamentals: Parts 1-3 Python Fundamentals: Parts 4-6
Python Fundamentals: Parts 1-3 Python Fundamentals: Parts 4-6 Python Data Wrangling and Manipulation with Pandas: Parts 1-2 Python SQL Fundamentals
Access Materials
R SQL Fundamentals
120 minutes
Intermediate

Learn how to use SQL in R to access and query relational databases with DBI and dbplyr.

Builds on:
R Fundamentals: Parts 1-4 R Data Wrangling and Manipulation: Parts 1-2
R Fundamentals: Parts 1-4 R Data Wrangling and Manipulation: Parts 1-2 R Data Visualization
Access Materials