Book Image

Data Science with SQL Server Quick Start Guide

By : Dejan Sarka
Book Image

Data Science with SQL Server Quick Start Guide

By: Dejan Sarka

Overview of this book

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 with Microsoft SQL Server and In-Database ML Services. It covers all stages of a data science project, from businessand data understanding,through data overview, data preparation, modeling and using algorithms, model evaluation, and deployment. You will learn to use the engines and languages that come with SQL Server, including ML Services with R and Python languages and Transact-SQL. You will also learn how to choose which algorithm to use for which task, and learn the working of each algorithm.
Table of Contents (15 chapters)
Title Page
Copyright and Credits
Packt Upsell
Contributors
Preface
Index

Chapter 2. Introducing R

When you talk about statistics, data mining, and machine learning, many people, especially those working in academic areas, think about R. R is the language that the engine that executes the code. You can use different R distributions, or versions of R engines and development tools; however, there is only one basic R language. Of course, to use it, you need to learn how to program in this language.

Statistics, data mining, and machine learning terms are very similar. You won't make a big mistake if you use them as synonyms. Statistics is the science of analyzing data collections, expressing the relationships as mathematical functions, and presenting and interpreting the results. In statistics, you usually work with sample data, or samples, because the population data, or the census, is not available to you. Data-mining analysis techniques are often derived from statistics, but also from artificial intelligence, biology, and other scientific areas. You use these techniques...