| title | R tutorials |
|---|---|
| titleSuffix | SQL machine learning |
| description | This article describes R tutorials for SQL machine learning. Learn how to run scripts and build machine learning models. |
| author | VanMSFT |
| ms.author | vanto |
| ms.reviewer | garye, jroth |
| ms.date | 05/07/2021 |
| ms.service | sql |
| ms.subservice | machine-learning |
| ms.topic | tutorial |
| monikerRange | >=sql-server-2016||>=sql-server-linux-ver15||=azuresqldb-mi-current |
[!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
::: moniker range=">=sql-server-2016||>=sql-server-linux-ver15"
| Tutorial | Description |
|---|---|
| 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 |
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 an R model to make predictions from new data. |