How To Download/Restore/Load Sample Database In PostgreSQL Using pgAdmin4 || pgAdmin Tutorial

#knowledge360 #akramsohail #akramsohailproject
You Are Hearty Welcomed To My Channel Knowledge 360.
Here I post technical videos, mainly related to computer science and programming.
I am posting project videos with coding explanations. I make tutorial videos on Technical Topics.
Stay Connected, Stay Tuned, Study Smart.

- Knowledge 360 ( Akram Sohail )

Only 3.9% of viewers are subscribing to my channel 😓.
I request you to please give click on Subscribe button.
It really helps me grow 😢.

Please Like, Comment, and Subscribe to my channel. ❤

Follow me on Social Media
--------------------------------------------------

XDM Download Manager

Download Sample Database

Topics
---------
Oracle
MySQL
PostgreSQL
SQL Server
PHP
C
C++
Python
Java
JavaScript
HTML/CSS
jQuery
Ajax
Bootstrap
Angular
Linux
Ubuntu
Windows
Miscellaneous

Description
------------------
How To Download Sample Database In PostgreSQL Using pgAdmin4
How To Restore Sample Database In PostgreSQL Using pgAdmin4
How To Load Sample Database In PostgreSQL Using pgAdmin4

We will use the DVD rental database for demonstrating the features of PostgreSQL.

The DVD rental database represents the business processes of a DVD rental store. The DVD rental database has many objects including:

15 tables
1 trigger
7 views
8 functions
1 domain
13 sequences

PostgreSQL Sample Database Tables
There are 15 tables in the DVD Rental database:

actor – stores actors' data including first name and last name.
film – stores film data such as title, release year, length, rating, etc.
film_actor – stores the relationships between films and actors.
category – stores film’s categories data.
film_category- stores the relationships between films and categories.
store – contains the store data including manager staff and address.
inventory – stores inventory data.
rental – stores rental data.
payment – stores customer’s payments.
staff – stores staff data.
customer – stores customers' data.
address – stores address data for staff and customers
city – stores the city names.
country – stores the country names.

You can use the pgAdmin tool to restore the sample database from the downloaded database file using the following steps:

First, launch the pgAdmin tool and connect to the PostgreSQL server.

Next, right-click on the DVD rental database and choose Restore… menu item as shown:

After that, wait for a few seconds to let the restoration process complete.

Finally, open the DVD rental database from the object browser panel, you will see the tables in the public schema and other database objects as shown.

We have shown you how to load the DVD rental sample database into the PostgreSQL database server for learning and practicing PostgreSQL.

Let’s start learning PostgreSQL and have fun!

[KnowledgeChannel]

*Please help me get that beautiful YouTube Silver button. Do subscribe to the channel if my video was helpful.* ❤

[rickyALH]

This was very useful to know, as I was used to just using MySQL and am learning how to interact with PostgreSQL. Thank you showing how to do this!

[cowhunters]

Thank you very much!!!! It is best instruction ever.

[technicalescola]

I was stuck at this from many days... this was very useful bro.. thank a lot

[bob]

Thank you so much! very easy and clear explanation! Used this for Western Governors University course after having spent a few hours trying to figure it out on my own! This is great!!!

[debabratasahoo]

Tq Sir, This video is more helpful for me.Thanks a lot

[vishwajeetgohokar]

A perfect information about the postgres great work

[algoan]

I used online conversion from zip to tar and did not work. I followed same steps u took and it worked successfully. only difference, I used Mac and the tool I used called izip unarchiver. thanks

[Yogeshn]

Hi bro. Once I click on restore I'm getting utility not found error saying 'C:\Program Files\PostgreSQL\13\pgAdmin 4\runtime\pg_restore.exe' file not found. Please correct the Binary Path in the Preferences dialog'
Help please.

[sharyujamodkar]

hi, Sir i was able to restore the data successfully, but I want it edited too. Would you able to instruct me ?

[mohamadehtheshams]

Bro where to download more these .tar database files