Using SQL Server Machine Learning Services
Lab
Beginner
1 h 0 m
2018-10-31
Lab Overview
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.
Objectives
  • 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
Pre-Requisites
  • Basic experience with Microsoft SQL Server
  • Basic experience with the R programming language
Exercises
In this exercise, you will review the data science virtual machine and leverage the pre-installed Jupyter notebook server to execute R code.
´╗┐In this exercise, you will setup and configure Machine Learning Server and SQL Server Machine Learning Services.
In this exercise, you will learn how to execute remote commands to Machine Learning Services.
In this exercise, you will learn how to leverage R and Python scripts in SQL Server.
Real-Time Lab
Not Registered?
Create Account
Already Registered?
Login
What are Labs?

Labs are where you can get hands on experience from what you have learned from lectures. You get to work in real time in virtual machines at your pace.