Book Overview & Buying
Table Of Contents

Data Science with SQL Server Quick Start Guide

By : Dejan Sarka

4 (1)

Buy this Book

Data Science with SQL Server Quick Start Guide

4 (1)

By: Dejan Sarka

Buy this Book

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.

Preface

Who this book is for

What this book covers

To get the most out of this book

Get in touch

Free Chapter

Writing Queries with T-SQL

Before starting – installing SQL Server

Core T-SQL SELECT statement elements

Advanced SELECT techniques

Summary

Introducing R

Obtaining R

Your first line R of code in R

Learning the basics of the R language

Using R data structures

Summary

Getting Familiar with Python

Selecting the Python environment

Writing your first python code

Using functions, branches, and loops

Organizing the data

Integrating SQL Server and ML

Summary

Data Overview

Getting familiar with a data science project life cycle

Ways to measure data values

Introducing descriptive statistics for continuous variables

Using frequency tables to understand discrete variables

Showing associations graphically

Summary

Data Preparation

Handling missing values

Creating dummies

Discretizing continuous variables

The entropy of a discrete variable

Advanced data preparation topics

Summary

Intermediate Statistics and Graphs

Exploring associations between continuous variables

Measuring dependencies between discrete variables

Discovering associations between continuous and discrete variables

Expressing dependencies with a linear regression formula

Summary

Unsupervised Machine Learning

Installing ML services (In-Database) packages

Performing market-basket analysis

Finding clusters of similar cases

Principal components and factor analyses

Summary

Supervised Machine Learning

Evaluating predictive models

Using the Naive Bayes algorithm

Predicting with logistic regression

Trees, forests, and more trees

Predicting with T-SQL

Summary

Other Books You May Enjoy

Leave a review - let other readers know what you think

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...