The dataset is limited to storms located in the North Atlantic and Eastern Pacific basins between 1851 and 2008. The storm data contained in the csv file can be found on the National Hurricane Center website (www.nhc.noaa.gov/).
This project started out on dataquest.io with a PostgreSQL DB set up on a local machine. No solution was provided. After launching this DB on Amazon RDS and reading a few articles on the subject, I began analysing the storm data.
Table of Contents
I) Creating a PostgreSQL DB Instance on Amazon RDS
II) Creating a Table in the PostgreSQL DB
III) DB Management
IV) Loading the Storm Data into the PostgreSQL DB
V) Updating the PostgreSQL DB
VI) Analysing the Storm Data on Amazon RDS