SQL Server Machine Learning Services

Heads up! This course may be archived and/or unavailable.

SQL Server now includes support for direct execution of R code. This integration allows complex data science analyses to be performed quickly in a secure environment, without having to export data sets first. In this course, database expert Adam Wilbert walks through the steps of enabling the required components—including Machine Learning Services for R—and writing basic R scripts. He also shows how to retrieve and work with data stored in SQL Server tables, create data visualizations with external R libraries, and package scripts as stored procedures. At the end of the course, traditional SQL Server users will be able to dive deeper into using R and traditional R developers will be able to take advantage of using SQL Server as the source of data to create higher-performing analyses.

Contents:

• Introduction
• 1. Get Started with MLS
• 2. Write R Scripts for SQL Server
• 3. Create a SQL Stored Procedure
• 4. Output Graphics with R
• 5. Create an External Data Science Client
• Conclusion