Skip to content

Latest commit

 

History

History
62 lines (52 loc) · 4.22 KB

r-tutorials.md

File metadata and controls

62 lines (52 loc) · 4.22 KB
title titleSuffix description author ms.author ms.reviewer ms.date ms.service ms.subservice ms.topic monikerRange
R tutorials
SQL machine learning
This article describes R tutorials for SQL machine learning. Learn how to run scripts and build machine learning models.
VanMSFT
vanto
garye, jroth
05/07/2021
sql
machine-learning
tutorial
>=sql-server-2016||>=sql-server-linux-ver15||=azuresqldb-mi-current

R tutorials for SQL machine learning

[!INCLUDE SQL Server 2016 SQL MI]

::: moniker range=">=sql-server-ver15||>=sql-server-linux-ver15" This article describes the R tutorials and quickstarts for Machine Learning Services on SQL Server and on Big Data Clusters. ::: moniker-end ::: moniker range="=sql-server-2017" This article describes the R tutorials and quickstarts for SQL Server Machine Learning Services. ::: moniker-end ::: moniker range="=sql-server-2016" This article describes the R tutorials and quickstarts for SQL Server 2016 R Services. ::: moniker-end ::: moniker range="=azuresqldb-mi-current" This article describes the Python tutorials and quickstarts for Azure SQL Managed Instance Machine Learning Services. ::: moniker-end

R tutorials

::: moniker range=">=sql-server-2016||>=sql-server-linux-ver15"

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.
::: moniker-end
::: moniker range="=azuresqldb-mi-current"
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.
::: moniker-end

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