[R] Book Recommendation

[Stephen H. Dawson, DSL]

Thanks, Spencer. I appreciate your helpful assistance.


Kindest Regards,
*Stephen Dawson, DSL*
/Executive Strategy Consultant/
Business & Technology
+1 (865) 804-3454
http://www.shdawson.com


On 8/28/23 15:42, Spencer Graves wrote:
> 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.
>>
>>
>>