How do I start learning R Engine

Markus Ehrenmüller-Jensen Self-employed

“In any case, the large database manufacturers have recognized the potential of R. For example, Microsoft has integrated an R interpreter into the database engine (you can therefore run an R script on data in the SQL server and in an Azure SQL database without data transfer) and in Power BI Desktop, what is especially interesting for visualizations. "

Are you curious about how to solve problems in R and you may already have some experience with SQL? Then you have come to the right place with this article! We'll start with the basic elements of the language - lots of specific sample code. Then we take a look at how we can handle data (basic SQL knowledge helps here - but is not required). And last but not least, we will look at use cases that can typically be solved with R.

As a programming language, R is strictly but dynamically typed, functional and interpreted (i.e. not compiled). It is popular with so-called data scientists, among other things, because there are (free) packages with which statistical calculations (such as matrix calculations or descriptive statistics) can be carried out. Machine learning (e.g. linear regression, clustering, neural networks, etc.) can also be implemented. The results of the calculations can be visualized efficiently and effectively.

R is the open source successor to the S programming language. A very active community is driving the development of the language and the available packages. At the time of going to press, over 12,000 (in words: twelve thousand!) Packages were available on the Comprehensive R Archive Network (CRAN). This is both a blessing (because, for example, new machine learning models that are being developed in the academic world or by companies are made available very quickly) and a curse (because of course no one has an even remotely complete overview about all packages). You will learn about a handful of packages over the course of this article.

In any case, one thing is certain: when you work with data, you will learn to appreciate R. This gives you many options for accessing, transforming, and cleaning data so that you can ultimately analyze it. And, starting with SQL Server 2016, Microsoft has integrated the R programming language into their data platform.

Create and execute scripts

You can run the examples yourself after you have used R and an Integrated Development Environment (IDE) such as B. RStudio or R Tools for Visual Studio installed on you. Figure 1 shows the basic structure of the IDE. At the top left (framed in red in the figure) you can create a script and execute it entirely or step by step. The input console is at the bottom left (orange).

Read the full article in the issue:

Developer Magazine Special Vol.17: Machine Learning - "Machine Learning"

All information about the magazine