Free e-book: Data Science with SQL Server 2016
Want to share your content on R-bloggers? click here if you have a blog, or here if you don't.
There's a new e-book available to download free from Microsoft Academy: Data Science with Microsoft SQL Server 2016.
This 90-page e-book is aimed at data scientists who already have some experience in R, but want to learn how to use R wirth SQL Server. The book was written by some of my most experienced colleagues from Microsoft's data science team at Microsoft: Buck Woody, Danielle Dean, Debraj GuhaThakurta, Gagan Bansal, Matt Conners, and Wee-Hyong Tok, and begins with an introduction by Joseph Sirosh. It includes everything you need to know to use R and SQL Server:
- How to install and configure your data science tool-set: SQL Server 2016, Microsoft R Client, RStudio/RTVS, etc.
- How to download data from SQL Server into a local R client
- How to create and update tables in SQL Server from R
- Use a remote SQL Server instance as an R compute engine, driven from your local R client
- Write SQL Server stored procedures that run R code on the server, and how to share them with others.
(If you're new to R or data science, there are also links to learning resources in Chapter 1.) The book also includes several fully-worked examples following the data science process, with links to data and code so you can try them out yourself:
- Creating a model to predict whether a tip is given for a taxi ride in New York City
- Building a customer churn model to find customers likely to switch to a competing service provider
- Analyzing “Internet of Things” data as part of a predictive maintenenance program
Data Science with Microsoft SQL Server 2016 is available now as a download from Microsoft Academy. (Desktop and mobile PDF formats available. Free registration required.)
R-bloggers.com offers daily e-mail updates about R news and tutorials about learning R and many other topics. Click here if you're looking to post or find an R/data-science job.
Want to share your content on R-bloggers? click here if you have a blog, or here if you don't.