library(sos)
(sql <- findFn('SQL'))
# This opened two tabs in the default browser on my computer just now.
The second tab lists 298 different packages with help pages containing
"SQL", sorted to put the package with the most matches first. The first
tab lists 1900 different help pages, sorted to put the highest ranking
package first.
installPackages(sql)
# This installs the highest ranking packages, because the 'sos' code
knows how to get more information about installed packages than about
ones that are not installed. To get that information, I followed this
"installPackages(sql)" with:
sqo
# Hadley Wickham is listed as an author on 14 of those packages. The
RSQL and RSQLite are numbers 22 and 50 on that list. RMySQL and
RPostgreSQL are numbers 48 and 31, respectively.
If you are looking for course content, I suggest you consider using
findFn with SQL and applications of greatest interest to your target
audience.
Spencer Graves
p.s. DISCLAIMER: I'm the lead author and maintainer of the sos package.
On 8/28/23 1:48 PM, Hadley Wickham wrote:
You might find this chapter of R for Data Science helpful:
https://r4ds.hadley.nz/databases
Hadley
On Tue, Aug 29, 2023 at 3:47 AM Stephen H. Dawson, DSL via R-help
<r-help@r-project.org> wrote:
Good Morning,
I am doing some research to develop a new course where I teach. I am
looking for a book to use in the course content to teach accomplishing
SQL in R.
Does anyone know of a book on this topic to recommend for consideration?
Thank You,
--
*Stephen Dawson, DSL*
/Executive Strategy Consultant/
Business & Technology
+1 (865) 804-3454
http://www.shdawson.com
______________________________________________
R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
______________________________________________
R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
