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

Your first line R of code in R


R engine is an interpreter. Therefore, R is an interpreted language. In addition, R is a case-sensitive and functional language. Instead of typing commands, you call functions to perform an action. For example, to quit an R session, you need to call the q() function. You should extensively comment your code. A comment starts with a hash mark (#); you can use the comment anywhere in the line of code.

Any code after the start of the comment does not execute. A semicolon (;) is a command delimiter if you write more than one command in a single line. A new line is the command delimiter as well. The following code example shows a comment, displays my R version, and lists the authors and other contributors to the language using the contributors() function:

# R version and contributors
R.version.string
contributors()

Here, I am only showing the version I am currently using. Note that by the time you read this book, you might already have a newer version:

"R version 3...