Invalid Login Attempt

Lab: Using SQL Server Machine Learning Services

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.

Details
  • 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
  • Data Professionals
  • Data Scientists
  • Data Engineers
  • Database Administrators

Learning 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

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?
Benefits
Real Time Labs allow you to learn technology in an isolated environment without the hassle or cost of setting up a dedicated learning environment.

How it works