insert_data.sh: Script to insert data from courses.csv and students.csv into students database.
student_info.sh: More advanced script to print various students info using JOINS, AGGREGATES, REGEX etc.
bike-shop.sh: CLI to use Bike Rental Shop (data stored in the bikes.sql)
To recreate database from the dump, first you must create database from the PSQL prompt: CREATE DATABASE bikes;
Then from bash use:
$ psql -U bikes < bikes.sql
You may then add additional rows to the database within all the constraints.