Relational databases and SQL (no dplyr knowledge needed)
22
SQL "window" functions
Data Management With R
Intro
1
Intro to Quarto
2
Intro to R packages
Bash
3
Intro to Command Line Interfaces (CLIs)
4
How to run the Bash Shell
5
Working with the Bash Shell.
Regular Expressions
6
regular expressions (regex)
7
Practice with Regular Expressions
Intro to tidyverse
8
What is the "tidyverse"
9
Using pipes, i.e. %>% and |>
10
stringr tutorial
visualizations with ggplot2
11
Intro to ggplot2
Intro to dplyr and to SQL
12
Intro to dplyr
13
SQL Select
Relational databases and SQL (no dplyr knowledge needed)
14
"databases" and "database management systems"
15
Relational Databases and SQL (using R)
16
The "books database"
17
Inner Joins.
18
aggregate functions, group by, having
19
more joins (cross/left/right/full), subqueries, set operations, case, self joins
20
Common Table Expressions (CTE)
21
other commands: update/delete, create/drop/insert
22
SQL "window" functions
23
Working directly with databases in R
24
What is a Database?
Web Scraping
25
Internet Architecture.
26
Web Scraping with R
27
Scraping Dynamic (JavaScript) Websites
28
CSS Selector questions and answers
Questions
29
"Cleaning" data
Appendices
30
Topics
31
Bibliography
32
Where to find datasets
33
Where to find APIs
34
Additional topics
Relational databases and SQL (no dplyr knowledge needed)
22
SQL "window" functions
22
SQL “window” functions
See the following for more info:
https://learnsql.com/blog/why-should-i-learn-sql-window-functions/
21
other commands: update/delete, create/drop/insert
23
Working directly with databases in R