SQL Tutorial on Data Analysis in R
Introduction
Many people are pursuing data science as a career (to become a data scientist) choice these days. With the recent data deluge, companies are voraciously headhunting people who can handle, understand, analyze, and model data.
What most people fail to understand is that the data science/analytics industry isn't just limited to using Python or R. There are several other coding languages which companies use to run their businesses.
Among all, the most important and widely used language is SQL (Structured Query Language). You must learn it.
I've realized that, as a newbie, learning SQL is somewhat difficult at home. After all, setting up a server enabled database engine isn't everybody's cup of tea. Isn't it? Don't worry!
In this article, we'll learn all about SQL and how to write its queries in R. I've use the fantastic sqldf package to execute sql queries. Also, I've listed some amazing and free SQL tutorials (online).
Note: This article is meant to help R users who wants to learn SQL from scratch. Even if you are new to R, you can still check out this tutorial as the ultimate motive is to learn SQL here.
Table of Contents
- Why learn SQL ?
- What is SQL?
- Getting Started with SQL
- Data Selection
- Data Manipulation
- Strings & Dates
- Practising SQL in R