Skip to content

r-tutorials.md

Latest commit

 

History

History
63 lines (50 loc) · 4.16 KB

r-tutorials.md

File metadata and controls

63 lines (50 loc) · 4.16 KB
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.
ms.prod sql
ms.technology machine-learning
ms.topic tutorial
author cawrites
ms.author chadam
ms.reviewer garye, davidph
ms.date 05/04/2020
ms.custom seo-lt-2019
monikerRange >=sql-server-2016||>=sql-server-linux-ver15||=sqlallproducts-allversions

R tutorials for SQL machine learning

[!INCLUDEappliesto-ss-xxxx-xxxx-xxx-md]

::: moniker range=">=sql-server-ver15||>=sql-server-linux-ver15||=sqlallproducts-allversions" 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||=sqlallproducts-allversions" This article describes the R tutorials and quickstarts for SQL Server Machine Learning Services. ::: moniker-end ::: moniker range="=sql-server-2016||=sqlallproducts-allversions" This article describes the R tutorials and quickstarts for SQL Server 2016 R Services. ::: moniker-end

  • Learn how to run R scripts.
  • Build, train, and deploy R models to SQL Server.
  • Learn about remote and local compute contexts.
  • Explore the Microsoft R packages for data science and machine learning.

R tutorials

Tutorial Description
Predict ski rental with decision tree Use R and a decision tree model to predict the number of 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 Server, this tutorial explains how to perform common data science tasks in SQL Server. Load and visualize data, train and save a model to SQL Server, and use the model for predictive analytics.
In-database R analytics for SQL developers Build and deploy a complete R solution, using only [!INCLUDEtsql] tools. Focuses on moving a solution into production. You'll learn how to wrap R code in a stored procedure, save an R model to a [!INCLUDEssNoVersion] database, and make parameterized calls to the R model for prediction.

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.
Link Description
Build a predictive model using R and SQL Server Learn how a ski rental business might use machine learning to predict future rentals, which helps the business plan and staff to meet future demand.
Perform customer clustering using R and SQL Server Use unsupervised learning to segment customers based on sales data.

Next steps