Book Image

Data Science with SQL Server Quick Start Guide

By : Dejan Sarka
Book Image

Data Science with SQL Server Quick Start Guide

By: Dejan Sarka

Overview of this book

SQL Server only started to fully support data science with its two most recent editions. If you are a professional from both worlds, SQL Server and data science, and interested in using SQL Server and Machine Learning (ML) Services for your projects, then this is the ideal book for you. This book is the ideal introduction to data science with Microsoft SQL Server and In-Database ML Services. It covers all stages of a data science project, from businessand data understanding,through data overview, data preparation, modeling and using algorithms, model evaluation, and deployment. You will learn to use the engines and languages that come with SQL Server, including ML Services with R and Python languages and Transact-SQL. You will also learn how to choose which algorithm to use for which task, and learn the working of each algorithm.
Table of Contents (15 chapters)
Title Page
Copyright and Credits
Packt Upsell
Contributors
Preface
Index

Integrating SQL Server and ML


Of course, you already know that you can execute R and Python code from the T-SQL code. With SQL Server 2016 and 2017, you get a highly scalable ML engine. You install this engine with SQL Server installation by selecting the ML Services (In-database), as I explained in Chapter 1, Writing Queries with T-SQL. With Microsoft libraries, you get a lot of parallelized functions that utilize this scalable engine. You can use these functions for huge datasets. You can store a machine-learning model created with R or Python in a SQL Server table in a binary column. You use the stored models for predictions on new data. If you save an R or Python graph to a binary column, you can use it in SQL Server Reporting Services (SSRS) reports. Besides SQL Server, other Microsoft products and services support Python and R Power BI Desktop, Power BI Service, and Azure Machine Learning, or Azure ML, support both languages.

 

 

You can acquire two versions of the Microsoft ML:

  • ML Services...