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: Install PostgreSQL Install PGAdmin 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?