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:

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!

--

--

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

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Mark Soro

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