SQL Workshops

Learn SQL for database querying and data management

Currently Available

These workshops have upcoming sessions you can register for.

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

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