Hands-On Data Science with SQL Server 2017
Perform end-to-end data analysis to gain efficient data insight
Price | $44.99 - $65.98
|
Rating | |
Authors | Marek Chmel, Vladimir Muzny |
Publisher | Packt Publishing |
Published | 2018 |
Pages | 506 |
Language | English |
Format | Paper book / ebook (PDF) |
ISBN-10 | 1788996348 |
ISBN-13 | 9781788996341 |
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.
- Marek Chmel
- Vladimir Muzny
Similar Books
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
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
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
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
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
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
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
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