Data Science with SQL Server Quick Start Guide
Integrate SQL Server with data science
Published on 31. August 2018
Book
Paperback/Softback
206 pages
978-1-78953-712-3 (ISBN)
Description
Get unique insights from your data by combining the power of SQL Server, R and Python
Key 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
Book DescriptionSQL 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.
What you will 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
Who this book is forSQL Server professionals who want to start with data science, and data scientists who would like to start using SQL Server in their projects will find this book to be useful. Prior exposure to SQL Server will be helpful.
Key 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
Book DescriptionSQL 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.
What you will 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
Who this book is forSQL Server professionals who want to start with data science, and data scientists who would like to start using SQL Server in their projects will find this book to be useful. Prior exposure to SQL Server will be helpful.
More details
Language
English
Place of publication
Birmingham
United Kingdom
Target group
Professional and scholarly
US School Grade: College Graduate Student
Dimensions
Height: 235 mm
Width: 191 mm
Thickness: 12 mm
Weight
395 gr
ISBN-13
978-1-78953-712-3 (9781789537123)
Copyright in bibliographic data and cover images is held by Nielsen Book Services Limited or by the publishers or by their respective licensors: all rights reserved.
Schweitzer Classification
Other editions
Additional editions
E-Book
09/2024
Packt Publishing
€27.49
Available for download
Person
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. He is the founder of the Slovenian SQL Server and .NET Users Group.
Content
Table of Contents
Writing Queries with T-SQL
Introducing R
Getting Familiar with Python
Data Overview
Data Preparation
Intermediate Statistics and Graphs
Unsupervised Machine Learning
Supervised Machine Learning
Writing Queries with T-SQL
Introducing R
Getting Familiar with Python
Data Overview
Data Preparation
Intermediate Statistics and Graphs
Unsupervised Machine Learning
Supervised Machine Learning