POSTGRESQL : Installation in Linux and Windows | Create, Read, Update and Delete Tables and Records.

In this video we will see how to install postgresql in windows and linux. Then we will use SQL shell or the terminal to create databases and also how to create, read, update and delete tables and records.

Timestamp
00:00 Install and Setup in Windows
01:17 Install and Setup in Linux
02:23 SQL Shell
03:28 Create and Delete Databases
04:21 Connect to Database
04:43 Tables and Create Table
07:55 Insert data
09:40 Read data – WHERE clause
11:27 Update data
12:56 Delete data.

Postgresql download link:
For Windows https://www.enterprisedb.com/downloads/postgres-postgresql-downloads
For Linux https://www.postgresql.org/download/linux/ubuntu/
Digital Ocean article https://www.digitalocean.com/community/tutorials/how-to-install-and-use-postgresql-on-ubuntu-20-04

Datatypes : https://www.postgresql.org/docs/current/datatype.html
Constraints : https://www.postgresql.org/docs/current/ddl-constraints.html