Hands-On Data Science with SQL Server 2017
Perform end-to-end data analysis to gain efficient data insight
|Price||$44.99 - $65.98
|Authors||Marek Chmel, Vladimir Muzny|
|Format||Paper book / ebook (PDF)|
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.
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
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
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
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
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
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
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
by Grant Fritchey
Every Database Administrator, developer, report writer, and anyone else who writes T-SQL to access SQL Server data, must understand how to read and interpret execution plans. My book leads you right from the basics of capturing plans, through how to interrupt them in their various forms, graphical or XML, and then how to use the informati...
Publisher: Self-publishing | Release: 2018