In this lab, you learn to leverage Machine Learning Server and SQL Server Machine Learning Services to execute R code. You will use pre-installed tools of the Data Science Virtual Machine to execute Jupyter Notebooks and execute remote R code against Machine Learning Server. You will then leverage SQL Server Machine Learning Services to execute R code in SQL Server.
Estimated time required to complete: 1 hours, 0 minutes
You will have access to this environment for 4 hours, 0 minutes
Learning Credits Required: 5
Who this lab is designed for
Understand how to configure SQL Server to support Machine Learning Services
Learn how to execute R scripts on remote Machine Learning Servers
Learn how to execute R scripts in T-SQL
Visualize data using R
Basic experience with Microsoft SQL Server
Basic experience with the R programming language
Exercise 1: Explore the Data Science virtual machine
In this exercise, you will review the data science virtual machine and leverage the pre-installed Jupyter notebook server to execute R code.
Exercise 2: Prepare SQL Server Machine Learning Services and Machine Learning Server
In this exercise, you will setup and configure Machine Learning Server and SQL Server Machine Learning Services.
Exercise 3: Use a remote R session
In this exercise, you will learn how to execute remote commands to Machine Learning Services.
Exercise 4: Execute R scripts inside T-SQL statements
In this exercise, you will learn how to leverage R and Python scripts in SQL Server.
Login to Start Lab
Not Registered?Already Registered?
Real Time Labs allow you to learn technology in an isolated environment without the hassle or cost of setting up a dedicated learning environment.