Hands-On Data Science with SQL Server 2017: Perform end-to-end data analysis to gain efficient data insight

Marek Chmel, Vladimir Muzny

  • 出版商: Packt Publishing
  • 出版日期: 2018-11-30
  • 售價: $1,940
  • 貴賓價: 9.5$1,843
  • 語言: 英文
  • 頁數: 506
  • 裝訂: Paperback
  • ISBN: 1788996348
  • ISBN-13: 9781788996341
  • 相關分類: MSSQLSQLData Science
  • 海外代購書籍(需單獨結帳)

商品描述

Find, explore, and extract big data to transform into actionable insights

Key Features

  • Perform end-to-end data analysis―from exploration to visualization
  • Real-world examples, tasks, and interview queries to be a proficient data scientist
  • Understand how SQL is used for big data processing using HiveQL and SparkSQL

Book Description

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.

What you will learn

  • Understand what data science is and how SQL Server is used for big data processing
  • Analyze incoming data with SQL queries and visualizations
  • Create, train, and evaluate predictive models
  • Make predictions using trained models and establish regular retraining courses
  • Incorporate data source querying into SQL Server
  • Enhance built-in T-SQL capabilities using SQLCLR
  • Visualize data with Reporting Services, Power View, and Power BI
  • Transform data with R, Python, and Azure

Who this book is for

Hands-On Data Science with SQL Server 2017 is intended for data scientists, data analysts, and big data professionals who want to master their skills learning SQL and its applications. This book will be helpful even for beginners who want to build their career as data science professionals using the power of SQL Server 2017. Basic familiarity with SQL language will aid with understanding the concepts covered in this book.

Table of Contents

  1. Data Science Overview
  2. SQL Server 2017 as a Data Science Platform
  3. Data Sources for Analytics
  4. Data Transforming and Cleaning with T-SQL
  5. Data Exploration and Statistics with T-SQL
  6. Custom Aggregations on SQL Server
  7. Data Visualization
  8. Data Transformations with Other Tools
  9. Predictive Model Training and Evaluation
  10. Making Predictions
  11. Getting It All Together - A Real-World Example
  12. Next Steps with Data Science and SQL

商品描述(中文翻譯)

尋找、探索和提取大數據,轉化為可行動的洞察力

主要特點



  • 從探索到可視化,進行端到端的數據分析

  • 通過真實世界的例子、任務和面試問題,成為熟練的數據科學家

  • 了解如何使用HiveQL和SparkSQL進行大數據處理的SQL

書籍描述


SQL Server是一個關聯式數據庫管理系統,它使您能夠使用各種內置服務和功能進行端到端的數據科學流程。


《Hands-On Data Science with SQL Server 2017》從概述SQL的數據科學開始,以了解數據科學的核心任務。您將學習中級到高級的概念,使用SQL Server執行數據分析任務。本書採用獨特的方法,涵蓋最佳實踐、任務和挑戰,以測試您在每章結束時的能力。您將探索各種關鍵任務的細節,例如數據收集、清理、操作、聚合和過濾技術。隨著您逐步深入各章,您將使用T-SQL從數據庫中整理和提取數據,將原始數據轉化為可行動的洞察力。您將掌握準備和呈現有意義數據的方法,使用Power BI揭示隱藏的模式。在結尾章節中,您將使用SQL Server集成服務將數據轉化為有用的格式,並深入探討使用真實世界例子進行預測分析等機器學習概念。


通過閱讀本書,您將能夠處理不斷增長的數據量,並執行數據科學專業人員的日常活動。

您將學到什麼



  • 了解數據科學是什麼,以及如何使用SQL Server進行大數據處理

  • 使用SQL查詢和可視化分析傳入數據

  • 創建、訓練和評估預測模型

  • 使用訓練過的模型進行預測,並建立定期重新訓練課程

  • 將數據源查詢整合到SQL Server中

  • 使用SQLCLR增強內置的T-SQL功能

  • 使用報告服務、Power View和Power BI對數據進行可視化

  • 使用R、Python和Azure進行數據轉換

本書適合對象


《Hands-On Data Science with SQL Server 2017》適用於數據科學家、數據分析師和大數據專業人士,他們希望通過學習SQL及其應用來掌握自己的技能。即使是初學者,也可以通過使用SQL Server 2017的強大功能來建立自己的數據科學專業生涯。對SQL語言的基本熟悉將有助於理解本書中涵蓋的概念。

目錄



  1. 數據科學概述

  2. SQL Server 2017作為數據科學平台

  3. 分析的數據源

  4. 使用T-SQL進行數據轉換和清理

  5. 使用T-SQL進行數據探索和統計

  6. 在SQL Server上進行自定義聚合

  7. 數據可視化

  8. 使用其他工具進行數據轉換

  9. 預測模型的訓練和評估

  10. 進行預測

  11. 將所有內容結合在一起-一個真實世界的例子

  12. 數據科學和SQL的下一步