舉報 
會員
Hands-On Data Science with SQL Server 2017
SQLServerisarelationaldatabasemanagementsystemthatenablesyoutocoverend-to-enddatascienceprocessesusingvariousinbuiltservicesandfeatures.Hands-OnDataSciencewithSQLServer2017startswithanoverviewofdatasciencewithSQLtounderstandthecoretasksindatascience.Youwilllearnintermediate-to-advancedlevelconceptstoperformanalyticaltasksondatausingSQLServer.Thebookhasauniqueapproach,coveringbestpractices,tasks,andchallengestotestyourabilitiesattheendofeachchapter.Youwillexploretheinsandoutsofperformingvariouskeytaskssuchasdatacollection,cleaning,manipulation,aggregations,andfilteringtechniques.Asyoumakeyourwaythroughthechapters,youwillturnrawdataintoactionableinsightsbywranglingandextractingdatafromdatabasesusingT-SQL.Youwillgettogripswithpreparingandpresentingdatainameaningfulway,usingPowerBItorevealhiddenpatterns.Intheconcludingchapters,youwillworkwithSQLServerintegrationservicestotransformdataintoausefulformatanddelveintoadvancedexamplescoveringmachinelearningconceptssuchaspredictiveanalyticsusingreal-worldexamples.Bytheendofthisbook,youwillbeinapositiontohandlethegrowingamountsofdataandperformeverydayactivitiesthatadatascienceprofessionalperforms.
目錄(260章)
倒序
- coverpage
- Title Page
- About Packt
- Why subscribe?
- Packt.com
- Contributors
- About the authors
- About the reviewers
- Packt is searching for authors like you
- Preface
- Who this book is for
- What this book covers
- To get the most out of this book
- Download the example code files
- Conventions used
- Get in touch
- Reviews
- Data Science Overview
- Introducing data science
- Data science project life cycle
- Business understanding
- Getting data
- Modelling and analysis
- Deployment and visualization
- Final acceptance
- Data science domains
- Math and statistics
- Visualizing the types of data
- Statistics 101
- Central tendency
- Skewness
- Variability
- Machine learning
- SQL Server and machine learning
- Choosing the right algorithm
- Big data
- SQL Server and big data
- Summary
- SQL Server 2017 as a Data Science Platform
- Technical requirements
- SQL Server evolution
- What's available in the pack?
- History of SQL Server
- SQL Server in the cloud
- Azure SQL Database
- Azure SQL Data Warehouse
- SQL Server Services and their use with data science
- SQL Server Integration Services
- SQL Server Analysis Services
- Tabular Mode
- Multidimensional mode
- PowerPivot Mode
- Querying languages
- Reporting Services
- Development tools for Reporting Services
- Power BI Report Server
- Machine Learning Services
- Summary
- Data Sources for Analytics
- Technical requirements
- Getting data from databases
- Importing data from SQL Server
- Importing data from other database systems
- Importing flat files
- Working with XML data
- Working with JSON
- Retrieve data as JSON
- Processing stored JSON data
- External data with PolyBase
- Installing and configuring
- Summary
- Data Transforming and Cleaning with T-SQL
- Technical requirements
- The need for data transformation
- Database architectures for data transformations
- Direct source for data analysis
- Staging–target scenario
- Landing–staging–target scenario
- Tools eligible for data movement
- Distributed queries
- SQL Server Integration Services
- Why should we use SSIS?
- What is needed to develop an SSIS solution?
- Where should SSIS be used?
- Is there an alternative to SSIS?
- Transforming data
- Full data load
- Incremental data load
- The MERGE statement
- CHECKSUM
- Temporal tables
- Denormalizing data
- Relational normalization
- First normal form
- Second normal form
- Third normal form
- Need for denormalization
- Ways of denormalization
- Computed columns
- Denormalization using joins
- Using views and stored procedures
- Database applications
- Using views
- Using stored procedures
- Performance considerations
- Writing correct code
- Using indexes
- B-tree indexes
- COLUMNSTORE INDEX
- Summary
- Questions
- Data Exploration and Statistics with T-SQL
- Technical requirements
- T-SQL aggregate queries
- Common properties of aggregate functions
- Aggregate functions
- COUNT COUNT(*) and COUNT_BIG
- MIN and MAX
- SUM
- AVG
- VAR and VARP
- STDEV and STDEVP
- Using groups
- Using the HAVING clause
- Ranking framing and windowing
- Ranking functions
- ROW_NUMBER
- RANK
- DENSE_RANK
- NTILE
- Running aggregates
- Using aggregate functions in running aggregates
- Using aggregate functions
- Using the LEAD and LAG functions
- Calculating with percentiles
- The PERCENT_RANK and CUME_DIST functions
- The PERCENTILE_CONT and PERCENTILE_DISC functions
- Summary
- Questions
- Custom Aggregations on SQL Server
- Technical requirements
- Overview of SQLCLR
- Use cases of using SQLCLR
- How to work with SQLCLR
- Instance and database configurations to use with SQLCLR
- Creating CLR aggregations
- Example goal and assignment
- Skeleton of CLR aggregation
- Implementing methods
- Implementing custom serialization
- Implementing the Init method
- Implementing the Accumulate method
- Implementing the Merge method
- Implementing the terminate method
- Deployment and testing
- Limitations and performance considerations
- Development issues and risks
- Maintenance issues and risks
- Performance issues and risks
- Summary
- Questions
- Data Visualization
- Technical requirements
- Data visualization – preparation phase
- Power BI Report Server
- Starting with Power BI Desktop
- Defining the data source
- Adding visualizations to the Report
- Visual interactions
- Publishing reports
- SQL Server Reporting Services
- Adding charts to Reports
- Using SQL Server Data Tools
- Summary
- Data Transformations with Other Tools
- Technical requirements
- Categorization missing values and normalization
- Categorization
- Missing values
- Normalization
- Z-score
- Feature-scaling
- Using Integration Services for data transformation
- Setting up a SSIS project
- Categorizing the products
- Using R for data transformation
- Preparing client R environment
- R Syntax first steps
- Working example of Z-score computed in R
- Using Data Factory for data transformation
- Creating Azure Data Factory
- Creating simple copy data with ADF
- Summary
- Questions
- Predictive Model Training and Evaluation
- Technical requirements
- Preparing SQL Server
- Setting up and configuring ML services
- Preparing to install our own R packages
- Creating data structures
- The concept of machine learning in databases
- Creating physical data structures
- Creating common objects
- Creating objects using filestreams
- Creating objects using temporal tables
- Deploying training and evaluating a predictive model
- Saving our machine learning model to filestreams
- Saving a machine learning model to temporal tables
- Summary
- Questions
- Making Predictions
- Technical requirements
- Reading models from a database
- Reading the model from a common table
- Reading the model from a temporal table
- Submitting values to an external script
- Submitting values into the external script
- Deserializing a predictive model
- Making the prediction
- Using the PREDICT keyword
- Making the predictive model self-training
- Re-calculating a predictive model regularly
- Re-calculating a predictive model asynchronously
- Creating a message type
- Creating a contract
- Creating queues and services
- Sending a request to train a new model
- Consuming requests and sending responses
- Testing the asynchronous solution
- Summary
- Questions
- Getting It All Together - A Real-World Example
- Technical requirements
- Assignment and preparation
- SQL Server
- Data description
- Data exploration
- Exploring data using T-SQL
- Exploring data using the SSIS Data Profiling Task
- Exploring the SourceData.Actions table
- Exploring data using R
- Data transformation
- Training and using predictive models for estimations
- Preparing the schema for the model
- Training the model
- Using the rxLinMod function and finishing the model
- Using the model in predictions
- Summary
- Questions
- Next Steps with Data Science and SQL
- Data science next steps
- Next steps with SQL Server
- Big data clusters
- Machine learning
- Machine learning services on Linux
- Machine learning high availability
- Data science in the cloud
- Summary
- Other Books You May Enjoy
- Leave a review - let other readers know what you think 更新時間：2021-06-10 19:14:46
推薦閱讀
- 大數據導論：思維、技術與應用
- 自動控制原理
- Getting Started with MariaDB
- 數據中心建設與管理指南
- 工業機器人工程應用虛擬仿真教程：MotoSim EG-VRC
- JMAG電機電磁仿真分析與實例解析
- 計算機圖形圖像處理：Photoshop CS3
- 工業機器人操作與編程
- 工業控制系統測試與評價技術
- 數據掘金
- DevOps Bootcamp
- Salesforce for Beginners
- 氣動系統裝調與PLC控制
- 格蠹匯編
- ESP8266 Robotics Projects
- FANUC工業機器人配置與編程技術
- 工業機器人應用系統三維建模
- Flash CS3動畫制作融會貫通
- 嵌入式系統應用開發基礎
- Hyper-V Security
- Hands-On Neural Networks with TensorFlow 2.0
- IBM Watson Projects
- Hands-On Artificial Intelligence for Search
- Spark MLlib機器學習實踐（第2版）
- IBM主機技術一本通
- 單片機應用技能操作和學習指導
- 計算機數學
- Fedora 31 Essentials
- 計算機網絡
- Scala for Machine Learning
