Guided Project: Storing Storm Data

In this PostgreSQL course, we explored the fundamentals of Postgres, known as PostgreSQL, for data engineers. 

In this Postgres project, we'll be assisting the International Hurricane Watchgroup in updating their analysis tools and helping them productionize their services. Currently, their method of sharing their data has been to save a CSV file on their local servers and have every analyst pull the data down. Then, each analyst uses a local SQLite engine to store the CSV, run their queries, and send their results around.

In this Postgres project, you will be using the locally installed version of Postgres. You can find the appropriate file to download Postgres for your operating system by clicking here. This is much different than previous Guided Projects, as you will be using your own notebook and your own Python environment instead of Dataquest's environment. 

These projects are meant to be challenging to better prepare you for the real world, so don't be discouraged if you have to refer back to previous lessons. If you haven't worked with Jupyter Notebook before or need a refresher, we recommend completing our Jupyter Notebook Guided Project before continuing.

As with all guided projects, we encourage you to experiment and extend your project, taking it in unique directions to make it a more compelling addition to your portfolio!


  • Learn to apply your Postgres skills to a real world scenario.
  • Learn to balance team and user needs with security and best practices.

Lesson Outline

1. Introduction
2. Downloading the CSV File
3. Exploring the Dataset
4. Creating the Table
5. Create the Users
6. Insert the Data
7. Additional Steps

Take a Look Inside