Unlocking the power of Postgres on Docker: A step-by-step guide | #tipsandtricks



Unlocking the power of Postgres on Docker: A step-by-step guide | #tipsandtricks

Unlocking the power of Postgres on Docker: A step-by-step guide | #tipsandtricks

πŸš€ Welcome back to Nilesh Gule’s tech explorations! In today’s video, we’re diving into the world of PostgreSQL, using pgAdmin to connect to our server running as a Docker container and run some basic queries. We’ll be creating sample tables. πŸ’»

pgAdmin is an incredible tool for managing PostgreSQL databases, and we’ll be walking through its features step-by-step. Whether you’re a seasoned database pro or just getting started, this video has something for you.

Remember, understanding databases is a crucial part of tech literacy, and PostgreSQL is one of the most popular options out there. So, let’s get started!

Don’t forget to like πŸ‘, comment πŸ’¬, and subscribe if you haven’t already! Every interaction helps us grow and bring more quality content to you. Stay tuned for more tech explorations! 🌐

#postgres #dockerdesktop #pgadmin #postgresql

β–¬β–¬β–¬β–¬β–¬β–¬ πŸ”— Additional Info πŸ”— β–¬β–¬β–¬β–¬β–¬β–¬

– πŸ”— Postgresql official Docker Hub image – https://hub.docker.com/_/postgres/
– πŸ”— pgAdmin tool – https://www.pgadmin.org/
– πŸ”— Postgres create table script – https://github.com/NileshGule/spring-boot-conference-app/blob/master/src/main/resources/Database/postgres/create_tables.sql
– πŸ”— Postgres insert data script – https://github.com/NileshGule/spring-boot-conference-app/blob/master/src/main/resources/Database/postgres/insert_data.sql

β–¬β–¬β–¬β–¬β–¬β–¬ ⏱ Chapters⏱ β–¬β–¬β–¬β–¬β–¬β–¬

00:00 – Introduction
00:15 – Postgres official image and supported tags
00:50 – Run Postgres 15 using Docker run command
02:28 – Connect to Postgres server using pgAdmin
04:40 – Create database, tables and insert data
06:00 – Summary

β–¬β–¬β–¬β–¬β–¬β–¬ πŸ‘‹ Contact me πŸ‘‹ β–¬β–¬β–¬β–¬β–¬β–¬
Connect with me here:
– πŸ”— Subscribe: https://www.youtube.com/channel/UCJOvQz55Ly-Rkr_ldE8pMEQ
– πŸ”— YouTube : https://www.YouTube.com/@nilesh-gule/
– πŸ”— GitHub: https://github.com/nileshgule
– πŸ”— Twitter: https://twitter.com/nileshgule
– πŸ”— Website: https://www.HandsOnArchitect.com/
– πŸ”— LinkedIn : https://www.linkedin.com/in/nileshgule/