I presume you are familiar with the RSQL and RSQLite packages and their vignettes. Can't offer any help, but a point of clarification: When you say, "teach accomplishing SQL in R," do you explicitly mean using SQL syntax in R to manipulate data or do you mean just doing SQL-like types of data manipulation in R? For the former, I assume you would be using the above-mentioned packages -- or perhaps others that I don't know about like them. For the latter, which I think would be subsumed under "data wrangling in R" there are tons of packages, tutorials, and books out there that one could search for under that rubric. If neither of the above, further clarification might help you get a better answer. Cheers, Bert On Mon, Aug 28, 2023 at 8: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. >[[alternative HTML version deleted]]
On 8/28/23 12:47 PM, Bert Gunter wrote:> I presume you are familiar with the RSQL and RSQLite packages and their > vignettes. > > Can't offer any help, but a point of clarification: > When you say, "teach accomplishing SQL in R," do you explicitly mean using > SQL syntax in R to manipulate data or do you mean just doing SQL-like types > of data manipulation in R? For the former, I assume you would be using the > above-mentioned packages -- or perhaps others that I don't know about like > them. For the latter, which I think would be subsumed under "data wrangling > in R" there are tons of packages, tutorials, and books out there that one > could search for under that rubric. If neither of the above, further > clarification might help you get a better answer. > > Cheers, > Bert > > On Mon, Aug 28, 2023 at 8: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. >> > > [[alternative HTML version deleted]] > > ______________________________________________ > 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, Bert. I appreciate your helpful assistance. This is an academic course. The effort now is to nail down the former. I am pushing against a local db for the students. I prefer they focus on the get-and-analyze efforts and not db administration efforts. Kindest Regards, *Stephen Dawson, DSL* /Executive Strategy Consultant/ Business & Technology +1 (865) 804-3454 http://www.shdawson.com On 8/28/23 13:47, Bert Gunter wrote:> I presume you are familiar with the RSQL and RSQLite packages and > their vignettes. > > Can't offer any help, but a point of clarification: > When you say, "teach accomplishing SQL in R," do you explicitly mean > using SQL syntax in R to manipulate data or do you mean just doing > SQL-like types of data manipulation in R? For the former, I assume you > would be using the above-mentioned packages -- or perhaps others that > I don't know about like them. For the latter, which I think would be > subsumed under "data wrangling in R" there are tons of packages, > tutorials, and books out there that one could search for under that > rubric. If neither of the above, further clarification might help you > get a better answer. > > Cheers, > Bert > > On Mon, Aug 28, 2023 at 8: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 > <http://www.R-project.org/posting-guide.html> > and provide commented, minimal, self-contained, reproducible code. >