Data Management With R (latest version)

(click here for spring24 version of this website)

Relational databases and SQL (no dplyr knowledge needed)
36 36. SQL "window" functions

Intro
Some computer basics
Into to Coding With AI
- 4 4. AI in Everyday Use
- 5 5. Coding with AI - an overview
Intro to R packages
- 6 6. Intro to R packages
Intro to Quarto
- 7 7. Intro to Quarto
Intro to tidyverse
Working with files
- 12 12. Working with files
JSON data and APIs
Regular Expressions
- 19 19. regular expressions (regex)
- 20 20. Practice with Regular Expressions
Bash
Intro to dplyr
- 24 24. dplyr - getting and viewing the data
- 25 25. dplyr - select
visualizations with ggplot2
- 26 26. Intro to ggplot2
Intro to SQL
- 27 27. SQL Select
Relational databases and SQL (no dplyr knowledge needed)
Web Scraping
Questions
- 43 43. "Cleaning" data
Appendices

Relational databases and SQL (no dplyr knowledge needed)
36 36. SQL "window" functions

36 36. SQL “window” functions

See the following for more info:

https://learnsql.com/blog/why-should-i-learn-sql-window-functions/

35 35. other commands: update/delete, create/drop/insert

37 37. Working directly with databases in R