https://www.canva.com/design/DAGGQI3jsQo/aZYZy0_PSEFsRfFUMNZx2g/edit

https://youtu.be/cnzka7kF5Zk

SQL - Structure Query Language

this generally talk to our database.

ex- SELECT * FROM person_db

After Installation

After installation It generally give us 2 things

1 - pg admin (a frontend)

2 - SQL Shell (basically a command-line tool that lets you interact directly with your PostgreSQL database using SQL commands.)

SOME COMMANDS

• \list shows all database in my PostgreSQL Server.
• \! cls simply clear the terminal.
• \q for quite
• exit for exit from that database

Now to create a database we can simply write

CREATE DATABASE <DATABASE NAME>;

semicolon is must REMEMBER

and after that we can see this in our server list which can be shown by using Syntax “ \list ”.