R for the SQL Server Developer
WARNING!
This presentation is now obsolete. The information in this talk has not been updated in a while and could be outdated. Use the information in this presentation at your own risk and be sure to double-check things to ensure that any information you use is accurate.ABSTRACT
R is the premiere language for data analysis. If the world of data science sounds fun and exciting, now is the time to get into R. We will walk through the core constructs of R, learn how to retrieve data from flat files and databases, and get a peek at the power behind R. This session will also give resources on where to go in order to become more familiar with statistics, R the language, and the R package ecosystem.
ADDITIONAL MEDIA
No recordings or additional media are available for this talk.SLIDES
Click here to access the slides for this presentation.
The slides are licensed under Creative Commons Attribution-ShareAlike.
DEMO CODE
Click here to access demo code for this presentation.
The source code is licensed under the terms offered by the GPL.
LINKS & FURTHER INFO
Basic Links
- Jamie Dixon gave me the inspiration for this talk with his R for the .NET Developer. Check out his links and book recommendations. Also see his NDC version of this talk.
- Check out my posts on R.
- If you want to see how to create the charts I showed in the Motivation section, I have a blog post on the topic.
- SQL and R by Casimir Saternos
- Making Data Analytics Simpler: SQL Server and R by Feodor Georgiev
- Translating between R and SQL: the basics
- Date Formats in R
- Handling Date-Times in R (PDF)
- Data Import
- GGPlot2 Cheat Sheet (PDF)
- R Bloggers is a great resource for learning what's going on in the world of R.
- Matthew Renze has two great Pluralsight courses on R: Exploratory Data Analysis with R and Beginning Data Visualization with R. I recommend both.
Notebooks
- I show how to install Jupyter on Windows.
- I also show how to install Jupyter on Linux.