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.

Related Content you might be interested in

Current Title:

Small book image
Data Science with SQL Server Quick Start Guide
Dejan Sarka
Aug, 2018 | 206 pages
Small book image
SQL Server 2017 Machine Learning Services with R
Julie Koesmarno | Tomaž Kaštrun
Feb, 2018 | 338 pages
Small book image
Hands-On Data Science with SQL Server 2017
Vladimir Muzny | Marek Chmel
Nov, 2018 | 506 pages
Small book image
SQL Server 2017 Integration Services Cookbook
Dejan Sarka | Christo Olivier | Samuel Lester | David Peter Hansen | Christian Cote | Matija Lah
Jun, 2017 | 558 pages
Table of Contents (15 chapters)
Title Page
Title Page
Copyright and Credits
Copyright and Credits
Packt Upsell
Packt Upsell
Contributors
Contributors
Preface
Preface
Free Chapter
1
Writing Queries with T-SQL
Writing Queries with T-SQL
Before starting – installing SQL Server
Core T-SQL SELECT statement elements
Advanced SELECT techniques
Summary
2
Introducing R
Introducing R
Obtaining R
Your first line R of code in R
Learning the basics of the R language
Using R data structures
Summary
3
Getting Familiar with Python
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
4
Data Overview
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
5
Data Preparation
Data Preparation
Handling missing values
Creating dummies
Discretizing continuous variables
The entropy of a discrete variable
Advanced data preparation topics
Summary
6
Intermediate Statistics and Graphs
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
7
Unsupervised Machine Learning
Unsupervised Machine Learning
Installing ML services (In-Database) packages 
Performing market-basket analysis
Finding clusters of similar cases
Principal components and factor analyses
Summary
8
Supervised Machine Learning
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
Other Books You May Enjoy
Leave a review - let other readers know what you think
Index
Index

Appendix 1. Other Books You May Enjoy

If you enjoyed this book, you may be interested in these other books by Packt:

SQL Server 2017 Developer's Guide Dejan Sarka, Miloš Radivojević, William Durkin

ISBN: 978-1-78847-619-5

  • Explore the new development features introduced in SQL Server 2017
  • Identify opportunities for In-Memory OLTP technology
  • Use columnstore indexes to get storage and performance improvements
  • Extend database design solutions using temporal tables
  • Exchange JSON data between applications and SQL Server
  • Use the new security features to encrypt or mask the data
  • Control the access to the data on the row levels Discover the potential of R and Python integration 
  • Model complex relationships with the graph databases in SQL Server 2017

SQL Server 2017 Machine Learning Services with R Tomaž Kaštrun, Julie Koesmarno

ISBN: 978-1-78728-357-2

  • Get an overview of SQL Server 2017 Machine Learning Services with R
  • Manage SQL Server Machine Learning Services from installation to configuration and maintenance
  • Handle and operationalize R code
  • Explore RevoScaleR R algorithms and create predictive models
  • Deploy, manage, and monitor database solutions with R
  • Extend R with SQL Server 2017 features
  • Explore the power of R for database administrators
Previous Section
End of Section
Next Section