sqlseries

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....

To get started with setting up my mac for using MySQL, I downloaded a copy of MySQL for mac at dev.mysql.com. After installation I need to modify ‘.zshrc’ and ‘.zprofile’ with the following settings below so terminal could recognise ‘mysql’ command. PATH=${PATH}:/usr/local/mysql/bin :bulb: Tip! If you decide use root account for MySQL, be sure to change password to something different otherwise you may bump into db connection issues with tools like VS Code....

SQL uses the structure for how assets are related from hierarchy viewpoint. An SQL instance hold databses, whilst databases contain table schemas and tables with actual data in it. A good illustration of this is depicted below: (https://www.slideserve.com/booth/sql-server-for-the-oracle-dba-sept-16-th-2009) Anytime we start to work with a database we need to make sure it is loaded into our SQL instance. To load a database into MySQL, we can use the following command:...