learning SQL

tc

2017/09/04

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.


Notes

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

Summary

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

comments powered by Disqus