PostgreSQL Tutorial: Build Your First Database & Tables from Scratch (CLI + pgAdmin4)

Thapa Technical
Thapa Technical
63 followers
7 Video Views·May 21, 2026

Day 3 of PostgreSQL Series 🚀

In this video, we will learn everything about PostgreSQL databases and tables from scratch. You'll understand database theory, create and drop databases using PostgreSQL CLI (psql) and pgAdmin4, connect databases, list all databases, create tables properly, understand rows and columns, and learn important PostgreSQL best practices developers actually use.

🔥 What you will learn:

✅ What is a database and table in PostgreSQL
✅ Create database in PostgreSQL using CLI
✅ Connect and list databases in PostgreSQL
✅ Drop database safely
✅ Create database using pgAdmin4
✅ Create tables in PostgreSQL
✅ Table creation syntax explained
✅ Hidden trick to show all tables
✅ Best practices while designing tables
✅ PostgreSQL tips beginners never learn

This tutorial is beginner-friendly and perfect for students, developers, React developers learning backend, and future full-stack engineers.

PostgreSQL Playlist: [Add Playlist Link]
Source Code: [Add Link]

------------------------------------------------------------------------------------
🔗 Useful Playlists

📘 Next.js Full Stack Playlist:
https://youtube.com/playlist?list=PLwGdqUZWnOp0lwvSBaIzzgV9X0ZiZ-42O&si=aQ_TNBNNx5L7V_bn

⚛️ React.js Playlist:
https://youtube.com/playlist?list=PLwGdqUZWnOp1Rab71vx2zMF6qpwGDB2Z1&si=sDZRxsYNetYmojKd

💻 TypeScript Playlist:
https://youtube.com/playlist?list=PLwGdqUZWnOp0xfHQFmlL52b_6-QZ0mnk_&si=c4jfsd5ElDC1p0A5
------------------------------------------------------------------------------------
💸 Get All My YouTube Videos' Source Code for just ₹199! Grab Now - https://thapatechnical.shop/source-code

📺 Watch the complete Node.JS Playlist here :https://youtube.com/playlist?list=PLwGdqUZWnOp3KELplHtc-RnJ5xTUPqdgH&si=_ob8F88HYxCdspup

🔥 Access Source Code, PPT & Notes here for Free : https://www.thapatechnical.com/2024/11/introduction-to-nodejs.html
------------------------------------------------------------------------

🚀 Boost Your Skills with these Pre-Requisite Videos:

🔗 Best HTML Course - https://youtu.be/5ccq_nLHneE
🔗 Best CSS Course - https://youtu.be/MSICFljRcb4
🔗 JavaScript Basics Course Part 1 - https://youtu.be/13gLB6hDHR8
🔗 JavaScript Advanced Course Part 2 - https://youtu.be/YwsOCN8woA8

------------------------------------------------------------------------
💸 Build Your Own E-commerce Website for Free! - https://www.thapatechnical.com/2024/03/build-complete-ecommerce-website-using.html

------------------------------------------------------------------------
✌️ Join Us!

🚀 Become a Member: Unlock perks, free source code, and more Join Now : https://www.youtube.com/channel/UCwfaAHy4zQUb2APNOGXUCCA/join
📷 Connect on Instagram: https://www.instagram.com/thapatechnical
🗨️ Join Our Discord Server: Hang out with fellow programmers Discord Link: https://discord.gg/MdScmCsua6

------------------------------------------------------------------------

⌛TIMELINE⏳
0:00 Introduction — Database & Tables Explained
0:30 Database Theory: What Actually Happens Behind the Scenes
1:50 Connect & List Databases using psql
2:40 Create & Drop Database Without Connecting
3:20 Support the Channel ❤️
3:45 Create and Drop Database using PostgreSQL CLI
5:30 PostgreSQL Secret Nobody Tells Beginners
7:10 Connect to a Specific Database
8:10 Create Database Using pgAdmin4
9:50 Delete Database using CLI & pgAdmin
12:10 Database Tables Theory — Row, Column & Schema
14:50 PostgreSQL CREATE TABLE Syntax Explained
15:30 Best Practices Before Creating Tables
18:15 Create Tables in pgAdmin4
21:18 Hidden Trick — Show All Tables in PostgreSQL
23:40 Important PostgreSQL Tips Developers Follow
25:35 Practice Task For You