If you are taking Udacity’s SQL lessons and find the sql environment too compact and would like to install it locally then this article is for you.

Note that this set up is done in Mac.

Here are the steps:

  1. Install PostgreSQL
  2. Install PGAdmin
  3. Download Parch and Posey database

For step 1, step 2 and step 3 :

I’ve covered those in this article with step by step walk through and helpful screenshots → How did I install Postgres.app and PgAdmin and build the Chinook Database?

and for the database, download this parch-and-posey.sql file to create the database refer to the above link as well.

Hope this helps!



Mark Soro

Selected for a 12-month Cybersecurity training sponsored by National Security Agency, graduating in 2022. Purchasing Supervisor for a Luxury Hotel.