Data Science with SQL Server Quick Start Guide

More Information
Learn
  • Use the popular programming languages,T-SQL, R, and Python, for data science
  • Understand your data with queries and introductory statistics
  • Create and enhance the datasets for ML
  • Visualize and analyze data using basic and advanced graphs
  • Explore ML using unsupervised and supervised models
  • Deploy models in SQL Server and perform predictions
About

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.

Features
  • Use the features of SQL Server 2017 to implement the data science project life cycle
  • Leverage the power of R and Python to design and develop efficient data models
  • find unique insights from your data with powerful techniques for data preprocessing and analysis
Page Count 206
Course Length 6 hours 10 minutes
ISBN 9781789537123
Date Of Publication 30 Aug 2018
Selecting the Python environment
Writing your first python code
Using functions, branches, and loops
Organizing the data
Integrating SQL Server and ML
Summary
Installing ML services (In-Database) packages 
Performing market-basket analysis
Finding clusters of similar cases
Principal components and factor analyses
Summary

Authors

Dejan Sarka

Dejan Sarka, MCT and Microsoft Data Platform MVP, is an independent trainer and consultant who focuses on the development of database and business intelligence applications. Besides projects, he spends about half his time on training and mentoring. He is the founder of the Slovenian SQL Server and .NET Users Group. He is the main author or co author of many books about databases and SQL Server. The last three books before this one were published by Packt, and their titles were SQL Server 2016 Developer's Guide, SQL Server 2017 Integration Services Cookbook, and SQL Server 2016 Developer's Guide. Dejan Sarka has also developed many courses and seminars for Microsoft, SolidQ, and Pluralsight.