Digital Lounge
SQL Workshop

Use SQL to answer questions about a dataset

Construct basic SQL queries

Use more advanced queries to join data and augment information

Visit this link to sign up for Hex, the free data notebook tool we'll be using during this class: https://app.hex.tech/link/xw4oAfZSP9mENm-HvIgQT7

IMPORTANT: Sign in using your @usc.edu email

Go to Projects, next to Spring 2026 Week 1 hit ‘...’ then Duplicate

Name your project with your name, e.g. "Rachel W - Week 1"

To load your dataset, click into the first cell ("Code 1") and hit Run in the upper right, or Command-Enter on your keyboard

Feedback Form: https://bit.ly/s26feedback

Email me: [email protected]

Hit the button below for recommended resources to learn more!

Review SQL 101

Data modeling

Joining data frames

Casting data types

Visit this link to sign up for Hex, the free data notebook tool we'll be using during this class: https://app.hex.tech/link/xw4oAfZSP9mENm-HvIgQT7

IMPORTANT: Sign in using your @usc.edu email

If you already have a Hex account from a previous week, just sign in to https://app.hex.tech

Go to Projects, next to Spring 2026 SQL Part 2 hit ‘...’ then Duplicate

Name your project with your name, e.g. "Rachel W - SQL Part 2"

To load your dataset, click into the first cell ("Code 1") and hit Run in the upper right, or Command-Enter on your keyboard

Feedback Form: https://bit.ly/s26feedback

If you loved this class, please consider leaving a testimonial!

Email me: [email protected]

Hit the button below for recommended resources to learn more!

What python can do for data analysis, and how to identify when to use it

How to read python code and understand what it’s doing

How to write and edit simple python code for data analysis

How to figure out what functions you need, when you need them

If this is your first time in this workshop: Visit this link to sign up for Hex, the free data notebook tool we'll be using during this class: https://app.hex.tech/link/YuNAZ7MlJ--Xoozuspf0fq6- (IMPORTANT: Sign in using your @usc.edu email)

If you already have a Hex account from a previous week, just sign in to https://app.hex.tech

Go to Projects, next to Fall 2025 Week 3 hit ‘...’ then Duplicate

Name your project with your name, e.g. "Rachel W - Week 3"

To load your dataset, click into the first cell ("Code 1") and hit Run in the upper right, or Command-Enter on your keyboard

Feedback Form: https://bit.ly/fall25feedback

Email me: [email protected]

Refresher on navigating dataframes

How to write your own functions

How to use Hex Magic to assist with writing code

Two ways to apply a function to a dataframe

If this is your first time in this workshop: Visit this link to sign up for Hex, the free data notebook tool we'll be using during this class: **https://app.hex.tech/link/YuNAZ7MlJ--Xoozuspf0fq6- (IMPORTANT: Sign in using your @usc.edu email)

If you already have a Hex account from a previous week, just sign in to https://app.hex.tech

Go to Projects, next to Fall 2025 Week 4 hit ‘...’ then Duplicate

Name your project with your name, e.g. "Rachel W - Week 4"

To load your dataset, click into the first cell ("Code 1") and hit Run in the upper right, or Command-Enter on your keyboard

Feedback Form: https://bit.ly/fall25feedback

Email me: [email protected]

Designing data visualizations

Dashboards, reports, and interactive components

Try out Hex’s visualization tools

Data visualization process using python and SQL

If this is your first time in this workshop: Visit this link to sign up for Hex, the free data notebook tool we'll be using during this class: https://app.hex.tech/link/YuNAZ7MlJ--Xoozuspf0fq6- (IMPORTANT: Sign in using your @usc.edu email)

If you already have a Hex account from a previous week, just sign in to https://app.hex.tech

Go to Projects, next to Fall 2025 Week 5 hit ‘...’ then Duplicate

Name your project with your name, e.g. "Rachel W - Week 5"

To load your dataset, click into the first cell ("Code 1") and hit Run in the upper right, or Command-Enter on your keyboard

Feedback Form: https://bit.ly/fall25feedback

Email me: [email protected]

See recordings posted to annenbergdl.org/events/category/data-analytics

learn.hex.tech

Learn SQL via a Murder Mystery: mystery.knightlab.com

sqlbolt.com for a more standard tutorial

Subscribe to my newsletter, The Pivot Pages, for advice on data learning and careers! buttondown.com/rachelw

Follow on LinkedIn: linkedin.com/in/rachelrwhaley

If you loved this class, please consider leaving a testimonial!

Video recordings from the Fall 2024 Excel workshop are here

Video recordings from the Fall 2024 SQL and Python workshop are here