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

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:  $44.98  |  Publisher:  Apress  |  Release:  2018

Getting Started with SQL Server 2014 Administration

Getting Started with SQL Server 2014 Administration

by Gethyn Ellis

The release of SQL Server 2014 has brought with it some great new features and enhancements that database administrators can use to make their database servers faster, highly available, and protected from disaster. As the lines between on-premise and on-cloud based solutions become even more blurred, enterprise database applications such ...

Price:  $16.99  |  Publisher:  Packt Publishing  |  Release:  2014

Hands-On Machine Learning with Azure

Hands-On Machine Learning with Azure

by Thomas K Abraham, Parashar Shah, Jen Stirrup, Lauri Lehman, Anindita Basak

Implementing Machine learning (ML) and Artificial Intelligence (AI) in the cloud had not been possible earlier due to the lack of processing power and storage. However, Azure has created ML and AI services that are easy to implement in the cloud. Hands-On Machine Learning with Azure teaches you how to perform advanced ML projects in the c...

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

Learning SQL Server Reporting Services 2012

Learning SQL Server Reporting Services 2012

by Jayaram Krishnaswamy

In the present day information-centric world we live in, the success of an enterprise depends enormously on how its information is generated, handled, and disseminated. With ample screenshots and over 65 hands-on exercises, this book will guide you effortlessly through creating cutting edge reports using SQL Server Reporting Services 2012...

Price:  $32.99  |  Publisher:  Packt Publishing  |  Release:  2013

A Developer's Guide to Data Modeling for SQL Server

A Developer's Guide to Data Modeling for SQL Server

by Eric Johnson, Joshua Jones

Effective data modeling is essential to ensuring that your databases will perform well, scale well, and evolve to meet changing requirements. However, if you're modeling databases to run on Microsoft SQL Server 2008 or 2005, theoretical or platform-agnostic data modeling knowledge isn't enough: models that don't reflect SQL Server's uniqu...

Price:  $6.70  |  Publisher:  Addison-Wesley  |  Release:  2008

Microsoft SQL Server 2017 on Linux

Microsoft SQL Server 2017 on Linux

by Benjamin Nevarez

This comprehensive guide shows, step-by-step, how to set up, configure, and administer SQL Server 2017 on Linux for high performance and high availability. Written by a SQL Server expert and respected author, Microsoft SQL Server 2017 on Linux teaches valuable Linux skills to Windows-based SQL Server professionals. You will get clear cove...

Price:  $29.93  |  Publisher:  McGraw-Hill  |  Release:  2018