How to install PostgreSQL on windows | create database | restore database
In this tutorial we are going to install PostgreSQL on Windows 10. We will install and configure PostgreSQL, create a database and restore it from a sample database. By the end you will have a fully functional PostgreSQL instance with database so you can explore and practice SQL script on PostgreSQL.
We will download the EnterpriseDB installer designed to make it quick and simple to install PostgreSQL on your computer. The installer provides:
A distribution-independent PostgreSQL installation.
The popular open-source PostgreSQL administration tool, pgAdmin.
We will install the latest version of PostgreSQL 14.1.
PostgreSQL download link: https://www.postgresql.org/download/
Sample database link: https://www.postgresqltutorial.com/postgresql-sample-database/
Subscribe to our channel:
https://www.youtube.com/c/HaqNawaz
———————————————
Follow me on social media!
Github: https://github.com/hnawaz007
Instagram: https://www.instagram.com/bi_insights_inc
LinkedIn: https://www.linkedin.com/in/haq-nawaz/
———————————————
#PostgreSQL #Database #SQL
Topics covered in this video:
0:00 – Introduction PostgreSQL
0:27 – Download PostgreSQL Installer
1:05 – Begin PostgreSQL Server Installation
2:21 – Launch pgAdmin 4 & connect to server
3:07 – Download sample database
3:36 – Create & restore database
4:31 – Query database
Comments are closed.