Make sure you try all the exercises to get comfortable with the syntax.

Install SQL on Local Box

We have learned the basics of SQL and now it’s time to go more deep on SQL. Most of the online editors are limited to the challenge/exercise on the website and don’t allow us to practice all the available SQL syntaxes.

Lets install SQL on our local box, so that we can get messy and are not limited to the online website.

Try a SQL Challenge

I came across this great github repo which has different SQL challenges and solutions for you. The repo also has sample data and DDLs which you can use to create dummy tables. You can then try out your local My SQL setup to practice the challenges.

Here is the link to the repo. Try not to look at the solution before attempting the challenges.

Kaggle has its own limitation on the Big Query usage. If you would like to get around that you can create your own Big Query trial account here.

Get a feel of Data Lake – with S3 and Spark-SQL

Here in this post I have installed Apache Spark on AWS- EMR cluster, and queried it via Apache Zeppelin using Spark-SQL. This post talks about saving data on amazon S3, and creating external tables via Spark- SQL.