Coding Vignettes on Joins and Databases and a SQL Lecture

Click here for a link to a code vignette and a youtube video of a coding demo focused on debugging and reprex
Author

George I. Hagstrom

Published

October 6, 2025

Hello,

There are 3 additional videos this week.

  1. The first video covers some material on R and SQL that we won’t be able to cover in tonight’s meetup. I talk about what databases are and when you should use them instead of regular files, and I introduce the concept of database normalization and explain what it is for. Then I show some tools for working with SQL using R and use it to go over some basic SQL queries.

Click here to watch the video and click here for the slides

  1. The second video is a coding practice session using joins. We practice joins on the Lahman database of baseball statistics. We use joins to combine information from different tibbles to determine how salary and award status relates to homeruns hit.

Click here to watch the Joins Coding Vignette and download the R that I used in the vignette here

  1. In the third video, I convert the billboard dataset which contains songs and their billboard rankings into a database, using duckdb. Forgive me for the weird confusion at the end of the video where I realize that the read_csv interpreted read my time in with unexpected units, you can skip that part if you like as I don’t finish resolving it.

Click here to watch the billboard vignette . If you want to download the data, click here for billboard.csv and you can find the code at DatabasePrepBillboardVignette.R