SQL for Data Analysis: Setup

Data

Download this data to your computer: google link.

About the data

For this lesson, we will use rainfall data from eThekwini from December 2017.

Software

SQL is a specialized programming language used with databases. We use a simple database manager called SQLite in our lessons.

We will use SQLite Manager plugin for the Firefox web browser. If you don’t have Firefox installed, you need to install it first and then you will be able to add the plugin. You need Firefox ESR 52.x, a special Extended Support Release version, since some addons are not compatible with the new Firefox Quantum.

Windows

• Download Firefox ESR 52.x
• Install Firefox following the installer instructions
• Install the SQLite Manager add on:
  Within Firefox, go to https://addons.mozilla.org/en-us/firefox/addon/sqlite-manager/.
• Click on the green ‘Add to Firefox’
• When a window pops up, click on ‘Install’
• When the next box pops up, click on ‘Restart Now’ to restart Firefox
• Add SQLite Manager to the menu:
  Menu (the three horizontal lines near the top right corner of Firefox) -> Customize, then drag the SQLite Manager icon to one of the empty menu squares on the right, Exit Customize
• Open SQLite Manager:
  Menu -> SQLite Manager

Mac

• Download Firefox ESR 52.x
• Install Firefox following the installer instructions
• Install the SQLite Manager add on:
  Within Firefox, go to https://addons.mozilla.org/en-us/firefox/addon/sqlite-manager/.
• Click on the green ‘Add to Firefox’
• When a window pops up, click on ‘Install’
• When the next box pops up, click on ‘Restart Now’ to restart Firefox.
• After restart the SQLite Manager will be added ot the Tools menu
• Open SQLite Manager:
  Tools -> SQLite Manager