R tutorials for SQL machine learning

Applies to: yesSQL Server 2016 (13.x) and later YesAzure SQL Managed Instance

This article describes the R tutorials and quickstarts for Machine Learning Services on SQL Server and on Big Data Clusters.

This article describes the R tutorials and quickstarts for SQL Server Machine Learning Services.

This article describes the R tutorials and quickstarts for SQL Server 2016 R Services.

This article describes the Python tutorials and quickstarts for Azure SQL Managed Instance Machine Learning Services.

R tutorials

Tutorial Description
Predict ski rental with decision tree Use R and a decision tree model to predict the number of future ski rentals. Use notebooks in Azure Data Studio for preparing data and training the model, and T-SQL for model deployment.
Categorizing customers using k-means clustering Use R to develop and deploy a K-Means clustering model to categorize customers. Use notebooks in Azure Data Studio for preparing data and training the model, and T-SQL for model deployment.
In-database R analytics for data scientists For R developers new to SQL machine learning, this tutorial explains how to perform common data science tasks in SQL. Load and visualize data, train and save a model in a database, and use the model for predictive analytics.
In-database R analytics for SQL developers Build and deploy a complete R solution, using only SQL tools. Focuses on moving a solution into production. You'll learn how to wrap R code in a stored procedure, save an R model in a database, and make parameterized calls to the R model for prediction.
Tutorial Description
Predict ski rental with decision tree Use R and a decision tree model to predict the number of future ski rentals. Use notebooks in Azure Data Studio for preparing data and training the model, and T-SQL for model deployment.
Categorizing customers using k-means clustering Use R to develop and deploy a K-Means clustering model to categorize customers. Use notebooks in Azure Data Studio for preparing data and training the model, and T-SQL for model deployment.

R quickstarts

If you are new to SQL machine learning, you can also try the R quickstarts.

Quickstart Description
Run simple R scripts Learn the basics of how to call R in T-SQL using sp_execute_external_script.
Data structures and objects using R Shows how SQL uses the R to handle data structures.
Create and score a predictive model in R Explains how to create, train, and use a R model to make predictions from new data.

Next steps