This projects demonstrates matery of SQL querying techniques to:
- Generate insights
- Write complex queries
- Optimize SQL queries
In this poject, I create a local data base using postgreSQL.
The dataset is business data from a dvd rental store.
The database Entity Relationship Diagram (ERD) is shown below [also in this repo (dvd-rental-erd)].
To load the database and run locally, follow the steps below for postgres (using pgadmin):
- Unzip the dvdrental_db.zip file to obtain the dvdrental.tar db file
- Open pgadmin application on you local machine and create a new database
- Right click on the new database and select restore
- Select the format under the General tab to custom or tar
- Select the filename bar and navigate to the file path where the unzipped dvdrental.tar is stored and select it
- Click restore and let it load
To load the database using psql commands instead, follow this guide.