SQL Server Machine Learning Services: R

SQL Server now includes support for direct execution of R code. This integration allows complex data science analyses to be performed quickly in a secure environment, without having to export data sets first. In this course, database expert Adam Wilbert walks through the steps of enabling the required components—including Machine Learning Services for R—and writing basic R scripts. He also shows how to retrieve and work with data stored in SQL Server tables, create data visualizations with external R libraries, and package scripts as stored procedures. At the end of the course, traditional SQL Server users will be able to dive deeper into using R and traditional R developers will be able to take advantage of using SQL Server as the source of data to create higher-performing analyses.

Topics include:

Installing Machine Learning Services
Writing your first R script
Importing data
Querying data
Outputting data to a result set
Creating a data frame
Creating SQL stored procedures from R scripts
Producing graphs, plots, and charts
Creating an external data science client