TidyTuesday: Using SQL with R Markdown and Tidyverse

In this week's #TidyTuesday video, I go over the basics of connecting to a database using R Studio. I then go over multiple ways to query a database. I also show how to query data using R Markdown code chunks and the helpful features that comes with the R Markdown cells. Lastly, I create a database/data frame and query the data using Dplyr. I also show how to convert the existing Dplyr pipeline into a useable SQL query. Then, using the queried data I create a simple ELO model and examine the ELO history.
#Tidyverse #SQL
Connect with me on LinkedIn: / andrew-couch
Q&A Submission Form: forms.gle/6EzU...
Code for this video: github.com/and...
TidyTuesday: github.com/rfo...
PC Setup (Amazon Affiliates)
Keyboard: amzn.to/3Bbbk3T
Mouse: amzn.to/3BcRGVo
Microphone: amzn.to/3ePo9JS
Audio Interface: amzn.to/3qTAmjz
Webcam: amzn.to/3L9Ql6j
CPU: amzn.to/3qGa6Zu
GPU: amzn.to/3DnhMHL
RAM: amzn.to/3LdTxh7