Attending the last RStudio conference strengthened my new-year resolution to learn SQL. Over the past few years, I have intermittently integrated ROracle data extract statements or procedures in my workflows, but I have only adapted to R the statements and procedures that were kindly created by my company's DBAs... So, I know how to connect to a DB and execute statements, but I don't know how to write said statements or procedures.
I would like to build my own DBs on my linux machine (a variant of Ubuntu) and learn SQL to interact with them using R
So my questions are the following:
- which DB (preferably free) should I install?
- which "flavor" of SQL would you recommend I learn?
- I have this vague notion that Oracle SQL is different from other flavors of SQL. How much disservice would I do to myself by learning another flavor of SQL if Oracle SQL is the one I end up needing?
- which resources among the gazillions of learning books / tutorials / learning websites would you recommend?
Thanks in advance for you insights.