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

SQL Server evolution

Let's get started with a brief overview of the features that are currently available with SQL and then skim over a brief history of SQL Server.

What's available in the pack?

The main core of the SQL Server is a DBMS (database management system), which is used to store the data in the databases. Through time and the various versions available, Microsoft has added other services as a part of the SQL Server that we can deploy and use for other data-related tasks. While these services are not necessary and required for database operations, they add value to your installation.

Without specifying any particular order for the services that expand the feature set of SQL Server beyond plain DBMS, the...

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 AU $24.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