Lecture 03: Databases in R with tidyverse
- Lecturer
- Janus Valberg-Madsen
<janus@math.aau.dk> - Time
- Apr 01, 08:15-12:00
- Place
- Skjernvej 4A, room 2.120
Contents of lecture
- Data analysis pipelines with
tidyverse - How to connect to a PostgreSQL DB in R
- Reading from and writing to tables in the database
Exercises
Described in the slides here and here [solutions for both]
Extra exercises on SQLzoo:
- 7 More JOIN operations [solutions] (+quiz)
- 8+ Numeric Examples [solutions]
- 9 Self join [solutions] (+quiz)