Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
SQL Server 2016 (13.x) and later
Azure 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.
| 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. |
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. |