[R] Book Recommendation

[Spencer Graves]

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 using 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 using 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.
> 
> 
>