Subscription

Explore Products

Best Sellers

New Releases

Books

Videos

Audiobooks

Learning Hub

Conferences

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

Next steps with SQL Server

As the new SQL Server 2019 is being introduced by the time of the writing of this book, there are numerous new features that have links to the data science domain too. One of them is the availability of the big data clusters. Big data is a huge phenomenon, and SQL Server entered this world with the version of SQL Server 2016 and its PolyBase feature, which we have discussed in the previous chapters. The new version of SQL Server will allow you to access not only HDFS filesystem but also other external data stored in SQL Server - Oracle, Teradata, and MongoDB, expanding the reach of the SQL Server to other DMBS systems and big data storage systems.

Big data clusters

SQL Server big data clusters allow...

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 ₹800/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