learning SQL



Categories: sql Tags: sql

Learning SQL FTW

I’ve been handling my data in R solely. Since sql is highly recommended by experts I followed on twitter, I think it’s worth a shot.

So I went to datacamp and started the intro tutorial and finished in about 4 hrs.


After learning about the basic grammars. It seems that dplyr offers all the features for data manipulation.

Here is what I learned:

The full grammar is sth like this: pretty simple and straightforward

SELECT column
FROM table
WHERE condition
GROUP BY group condition
HAVING grouped condition


At least next time I saw some sql query, I could understand what’s going on.