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 at 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 at 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.-- http://hadley.nz
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 at 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 at 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.
>
>
>
Thanks, Hadley. 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 14:48, 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 at 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 at 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. > >