Learn how to execute R code directly on SQL Server with Machine Learning Services.
Overview
Syllabus
Introduction
- Analyze SQL Server data with R
- What you should know
- Make the most of the exercise files
- 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
- 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
- Sample a data set
- Parameterize a stored procedure
- Challenge: Write a stored procedure
- Solution: Write a stored procedure
- View installed packages
- Produce graphs and plots
- Create a bar plot
- Challenge: Create a pie chart
- Solution: Create a pie chart
- Install MLS on a standalone server
- Add development tools to a client
- Install and configure RStudio
- Next steps
Taught by
Adam Wilbert