Install PostgreSQL and pgadmin4 on windows 11(mine) in 2023 | Load data | IIT Madras BSC Degree
Learn how to install PostgreSQL and pgadmin4, set up pgadmin4, and load the database in this video. Relevant for 2023 and beyond!
BIO??
Hello everyone?,
I am a student of @IITMadrasBSDegreeProgramme pursuing an Online BS Degree in Data Science and Programming. I Hope my videos will help you.
About:
PostgreSQL also known as Postgres, is a free and open-source relational database management system (RDBMS) emphasizing extensibility and SQL compliance. One can access PostgreSQL with pgAdmin package that is a free and open-source graphical user interface (GUI) administration tool for PostgreSQL, which is supported on many computer platforms.
In this video, we will explore the process of installing Postgres SQL on various operating systems, including Windows 11, Mac, and Linux. Additionally, we will address common errors that may arise during the installation. Furthermore, we will demonstrate how to load a Postgres database and configure pgAdmin4.
Other Resources:
Dataset Link:
Ace End Term:
Computational Thinking:
Timeline
00:00 – Introduction
00:05 – Download Postgres
01:13 – Install PostgreSQL & pgadmin (Window 11)
03:19 – Setup PG-Admin
04:45 – Download Database (IITM Owned)
05:53 – Load / Restore Database
08:46 – Fix Common Error (port error)
09:39 – Fix Common Error 2 (integrity error)
09:56 – Tip 1 Check Data
10:29 – Tip 2 Access & Write Query
11:02 – Conclusion & Thanks
Note: Dataset Content owned by IITM.
Hashtags
#postgres #postgresql #iitmadras #computerscience #querying
[ad_2]
source
