- Популярные видео
- Авто
- Видео-блоги
- ДТП, аварии
- Для маленьких
- Еда, напитки
- Животные
- Закон и право
- Знаменитости
- Игры
- Искусство
- Комедии
- Красота, мода
- Кулинария, рецепты
- Люди
- Мото
- Музыка
- Мультфильмы
- Наука, технологии
- Новости
- Образование
- Политика
- Праздники
- Приколы
- Природа
- Происшествия
- Путешествия
- Развлечения
- Ржач
- Семья
- Сериалы
- Спорт
- Стиль жизни
- ТВ передачи
- Танцы
- Технологии
- Товары
- Ужасы
- Фильмы
- Шоу-бизнес
- Юмор
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
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
Комментарии отсутствуют
Информация о видео
25 июля 2025 г. 16:30:12
00:29:38
Другие видео канала




















