PostgreSQL Day 1 – Table Creation, Insert, Update, Delete in PG Admin

Welcome to Day 1 of the PG Admin and PostgreSQL Tutorial Series

In this video, we cover SQL basics using PG Admin — the powerful open-source GUI tool for managing PostgreSQL databases. You’ll learn how to create tables, insert and update records, run basic arithmetic, use date and time queries, perform string operations, and apply comparison/logical operators in PostgreSQL.

This is the perfect starting point for beginners in SQL, data science, backend development, or database engineering.

✅ What You Will Learn in Day 1
How to run your first SQL queries

Arithmetic operations using SELECT

Creating a table in PostgreSQL

Inserting multiple records using INSERT INTO

Viewing data with SELECT * and column selection

Updating records using UPDATE and removing data using DELETE

Dropping a table using DROP TABLE

Using date and time functions like NOW() and CURRENT_DATE

String operations using concatenation (||)

Using comparison and logical operators (equals, not equal, greater than, less than, etc.)

🧰 Tools Used
PostgreSQL 16 or later

PG Admin 4 (web-based interface)

MacBook (also works on Windows and Linux)

📥 Useful Resources
PG Admin Download: https://www.enterprisedb.com/downloads/postgres-postgresql-downloads

Practice Scripts (GitHub): https://github.com/abhishekmishraai/Structured-Query-Language/blob/main/Days/Day%201.sql

🙋 Perfect For
SQL Beginners

Data Analysts and Data Scientists

Backend Developers

Students learning database concepts

Anyone starting with PostgreSQL and PG Admin
pgadmin tutorial
postgresql tutorial
pgadmin for beginners
postgresql basics
sql tutorial for beginners
create table sql
insert update delete sql
postgresql on mac
pgadmin step by step
learn sql in pgadmin
#PGAdmin
#PostgreSQL
#SQLTutorial
#DatabaseBasics
#LearnSQL
#DataScience

Видео PostgreSQL Day 1 – Table Creation, Insert, Update, Delete in PG Admin канала Abhishek Mishra