Formatting SQL Statement to look nice
Tricky tips to use group statment in SQL query within R
Some highly-recommended data visulization books
Formatting SQL Statement
SQL statement is so useful that not only analysts are necessarily to get familiar with, also many IT stuff or database adminstrators are using that quite often.
The question is, sometime you get a very long SQL query, and it seems not that readable; Just like the following SQL query, it's really not that clear at the first glance of it.
The good news is that, we have some good tools to format the SQL query, so it's much easy to understand. One of the popular useful SQL formatting websites that LDD(Little Dumb Doctor) highly
recommended is: www.poorsql.com
. Also many
are using this one: http://www.dpriver.com/pp/sqlformat.htm
Some highly-recommended R Tutorial books
Continue to Regression Analysis in R
Back to Use SQL statement in R via package sqldf library