You can restore the toy dataset "parch and posey" to your local machines from the file parch_and_posey_db using the following steps:
- Create a new database -
CREATE DATABASE parch_and_posey;
- Restore into the database -
pg_restore -d parch_and_posey /path/to/parch_and_posey_db
Now, SQL commands can be used to explore the dataset and run queries on it.
Here is the schema of the database used for all the queries.
I have also included the screenshots from the videos for some important and useful concepts that may need revision in future.
For the remaining ones, please refer these SQL Tutorials (by MODE as well).