SQL Server Machine Learning Services: R

Learn how to execute R code directly on SQL Server with Machine Learning Services.

Introduction

• Analyze SQL Server data with R
• What you should know
• Make the most of the exercise files

1. Get Started with MLS

• What is Machine Learning Services (MLS)?
• Install Machine Learning Services for R
• Enable script execution in SQL Server
• Write your first R script
• R data types

2. Write R Scripts for SQL Server

• Variables in R
• Import a data set from SQL Server
• Query data into an R data frame
• Output data to a result set
• Select values from a data frame
• Create a data frame from vectors
• Subset a data frame
• Challenge: Import data
• Solution: Import data

3. Create a SQL Stored Procedure

• Sample a data set
• Parameterize a stored procedure
• Challenge: Write a stored procedure
• Solution: Write a stored procedure

4. Output Graphics with R

• View installed packages
• Produce graphs and plots
• Create a bar plot
• Challenge: Create a pie chart
• Solution: Create a pie chart

5. Create an External Data Science Client

• Install MLS on a standalone server
• Add development tools to a client
• Install and configure RStudio

Conclusion

• Next steps