I started using SQL some years back and like all things in life, I’m going full circle to brush up and hopefully be more proficient. The motivation this time is to learn SQL well enough to perform some data analsys as part of my PhD research.
My aim is to have intermediate to advanced SQL skills to perform multi-table queries and use of parameters for filtering.
My dataset are stored in GCP BigQuery and I have experiemented with Superset and Redash as a visualisation tool. I’m currently leaning towards Redash as the open source visualisation tool of choice (more on this later).
To kick off my studies with SQL, I bought a book called ‘Learning SQL - Third Edition’ by Alan Beaulieu. I’ll be using mysql as the SQL database as it is easily accessible and helps me follow along with the examples in the book. Most importantly MySQL complies with ANSI SQL standard which makes it very useful in transferring most syntax and knowledge on SQL to other SQL compatible Databases like GCP BigQuery and AWS Athena, etc.