Hands-On Data Science with SQL Server 2017

Perform end-to-end data analysis to gain efficient data insight



Bookstore > Books > Hands-On Data Science with SQL Server 2017

Price$44.99 - $65.98
Rating
AuthorsMarek Chmel, Vladimir Muzny
PublisherPackt Publishing
Published2018
Pages506
LanguageEnglish
FormatPaper book / ebook (PDF)
ISBN-101788996348
ISBN-139781788996341
EBook Hardcover Paperback

SQL Server is a relational database management system that enables you to cover end-to-end data science processes using various inbuilt services and features.

Hands-On Data Science with SQL Server 2017 starts with an overview of data science with SQL to understand the core tasks in data science. You will learn intermediate-to-advanced level concepts to perform analytical tasks on data using SQL Server. The book has a unique approach, covering best practices, tasks, and challenges to test your abilities at the end of each chapter. You will explore the ins and outs of performing various key tasks such as data collection, cleaning, manipulation, aggregations, and filtering techniques. As you make your way through the chapters, you will turn raw data into actionable insights by wrangling and extracting data from databases using T-SQL. You will get to grips with preparing and presenting data in a meaningful way, using Power BI to reveal hidden patterns. In the concluding chapters, you will work with SQL Server integration services to transform data into a useful format and delve into advanced examples covering machine learning concepts such as predictive analytics using real-world examples.

By the end of this book, you will be in a position to handle the growing amounts of data and perform everyday activities that a data science professional performs.




Similar Books


Data Science with SQL Server Quick Start Guide

Data Science with SQL Server Quick Start Guide

by Dejan Sarka

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 w...

Price:  $34.99  |  Publisher:  Packt Publishing  |  Release:  2018

SQL Server 2017 Administration Inside Out

SQL Server 2017 Administration Inside Out

by William Assaf, Randolph West, Sven Aelterman, Mindy Curnutt

Dive into SQL Server 2017 administration - and really put your SQL Server DBA expertise to work. This supremely organized reference packs hundreds of timesaving solutions, tips, and workarounds - all you need to plan, implement, manage, and secure SQL Server 2017 in any production environment: on-premises, cloud, or hybrid. Four SQL Serve...

Price:  $34.23  |  Publisher:  Microsoft Press  |  Release:  2018

Hands-On Data Visualization

Hands-On Data Visualization

by Jack Dougherty, Ilya Ilyankou

Tell your story and show it with data, using free and easy-to-learn tools on the web. This introductory book teaches you how to design interactive charts and customized maps for your website, beginning with simple drag-and-drop tools such as Google Sheets, Datawrapper, and Tableau Public. You'll also gradually learn how to edit open ...

Price:  $44.99  |  Publisher:  O'Reilly Media  |  Release:  2021

Practical Data Science with R, 2nd Edition

Practical Data Science with R, 2nd Edition

by Nina Zumel, John Mount

Practical Data Science with R, Second Edition takes a practice-oriented approach to explaining basic principles in the ever expanding field of data science. You'll jump right to real-world use cases as you apply the R programming language and statistical analysis techniques to carefully explained examples based in marketing, business...

Price:  $39.99  |  Publisher:  Manning  |  Release:  2019

Productive and Efficient Data Science with Python

Productive and Efficient Data Science with Python

by Tirthajyoti Sarkar

This book focuses on the Python-based tools and techniques to help you become highly productive at all aspects of typical data science stacks such as statistical analysis, visualization, model selection, and feature engineering.You'll review the inefficiencies and bottlenecks lurking in the daily business process and solve them with ...

Price:  $49.99  |  Publisher:  Apress  |  Release:  2022

Hands-On Data Science with R

Hands-On Data Science with R

by Vitor Bianchi Lanzetta, Nataraj Dasgupta, Ricardo Anjoleto Farias

R is the most widely used programming language, and when used in association with data science, this powerful combination will solve the complexities involved with unstructured datasets in the real world. This book covers the entire data science ecosystem for aspiring data scientists, right from zero to a level where you are confident eno...

Price:  $39.99  |  Publisher:  Packt Publishing  |  Release:  2018

SQL Server 2017 Query Performance Tuning

SQL Server 2017 Query Performance Tuning

by Grant Fritchey

Identify and fix causes of poor performance. You will learn Query Store, adaptive execution plans, and automated tuning on the Microsoft Azure SQL Database platform. Anyone responsible for writing or creating T-SQL queries will find valuable the insight into bottlenecks, including how to recognize them and eliminate them.This book covers ...

Price:  $53.39  |  Publisher:  Apress  |  Release:  2018

PolyBase Revealed

PolyBase Revealed

by Kevin Feasel

Harness the power of PolyBase data virtualization software to make data from a variety of sources easily accessible through SQL queries while using the T-SQL skills you already know and have mastered.PolyBase Revealed shows you how to use the PolyBase feature of SQL Server 2019 to integrate SQL Server with Azure Blob Storage, Apache Hadoo...

Price:  $21.73  |  Publisher:  Apress  |  Release:  2020