Download Parch and Posey database and query it Postgres and PGAdmin

Photo by Lauren Mancke on Unsplash

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!