From the course: SQL Server Machine Learning Services: R

Analyze SQL Server data with R

From the course: SQL Server Machine Learning Services: R

Start my 1-month free trial

Analyze SQL Server data with R

“

- [Adam] The R statistical language provides a number of analysis techniques that are commonly used in data science and academic research. But until recently, it was cumbersome to use with data stored in a SQL server database. A copy of the data would need to be exported outside of the security and protection of the database engine in order to process it with R. And then added complexity and time to any analysis that data scientists wanted to perform. That all changed when Microsoft introduced machine learning services, which paved the way for running R scripts right inside of the same server environment where the data was already stored. Hi my name is Adam Wilbert and I've been introducing people to data bases and the world of data analysis for well over a decade. I'd love to show you how to leverage the power and flexibility of R scripting in SQL server. I'll demonstrate how to enable code execution output status messages, and import data into a script using standard T-SQL queries. Then after processing the data, you'll see how to export the results back to a valid SQL server result set and complete the analysis loop all on a single platform using the database management tools that you already know. So join me in my LinkedIn learning course to see how to process data quickly and securely using R in SQL server.

Contents