Explore Products

Best Sellers

New Releases

Books

Videos

Audiobooks

Learning Hub

Free Learning

You're reading from Hands-On Data Science with SQL Server 2017 Perform end-to-end data analysis to gain efficient data insight

Product type Paperback

Published in Nov 2018

Publisher Packt

ISBN-13 9781788996341

Length 506 pages

Edition 1st Edition

Languages

Python

Tools

SQL Server

Concepts

Data Analysis

Authors (2):

Vladimír Mužný

Marek Chmel

View More author details

Table of Contents (14) Chapters

Preface

1. Data Science Overview FREE CHAPTER

2. SQL Server 2017 as a Data Science Platform

3. Data Sources for Analytics

4. Data Transforming and Cleaning with T-SQL

5. Data Exploration and Statistics with T-SQL

6. Custom Aggregations on SQL Server

7. Data Visualization

8. Data Transformations with Other Tools

9. Predictive Model Training and Evaluation

10. Making Predictions

11. Getting It All Together - A Real-World Example

12. Next Steps with Data Science and SQL

13. Other Books You May Enjoy

Leave a review - let other readers know what you think

Preparing SQL Server

Microsoft SQL Server is very powerful engine for carrying out data science tasks. The server contains ML services that can be used for advanced R or Python analysis. Every feature offered within SQL Server, such as .NET integration or mail-sending, needs to be enabled in order for developers to be able to use them later. Machine learning also has to be enabled and configured correctly. This section shows which options to configure on the SQL Server, how to configure them, and also how to check whether the configuration is correct.

Setting up and configuring ML services

SQL Server's ML Services is based on a feature called satellite queries. The purpose of ML Services is to allow us to use languages...

The rest of the chapter is locked

A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.

Unlock this book and the full library FREE for 7 days

Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of

Start free trial

Renews at $19.99/month. Cancel anytime

Authors (2)

Vladimír Mužný

Vladimír Mužný has been a freelance developer and consultant since 1997. He has been a Data Platform MVP since 2017, and he has earned certifications such as MCSE: Data Management and Analytics and MCT. His first steps with SQL Server were done on version 6.5, and from that time on, he has worked with all following versions of SQL Server. Now Vladimir teaches Microsoft database courses, participates in SQL Server adoption at various companies, and collaborates on projects for production tracking and migrations.

See other products by Vladimír Mužný

Marek Chmel

Marek Chmel is a senior CSA at Microsoft, specializing in data and AI. He is a speaker and trainer with more than 15 years' experience. He has been a Data Platform MVP since 2012. He has earned numerous certifications, including Azure Architect, Data Engineer and Scientist Associate, Certified Ethical Hacker, and several eLearnSecurity certifications. Marek earned his master's degree in business and informatics from Nottingham Trent University. He started his career as a trainer for Microsoft Server courses and later worked as SharePoint team lead and principal database administrator. He has authored two books, Hands-On Data Science with SQL Server 2017 and SQL Server 2017 Administrator's Guide.

See other products by Marek Chmel