EP08 - PostgreSQL with Docker Tutorial | Database Containers for Beginners

In this PostgreSQL with Docker tutorial for beginners, we learn how to run PostgreSQL databases inside Docker containers and manage persistent database storage using Docker volumes.

In this video we cover:
- PostgreSQL containers
- Docker volumes
- Environment variables
- Port mapping
- Persistent storage
- Database containers
- Docker networking
- DBeaver database client
- SQL queries inside PostgreSQL
- Real backend workflows

We also demonstrate:
- Running PostgreSQL with Docker
- Connecting with psql
- Connecting with DBeaver
- Creating tables
- Inserting data
- Querying data
- Deleting records
- Restarting containers
- Persistent Docker volumes

Commands used in this tutorial:

docker run -d
--name postgres-demo
-e POSTGRES_PASSWORD=secret
-e POSTGRES_DB=myapp
-p 5432:5432
postgres

docker ps

docker exec -it postgres-demo bash

psql -U postgres -d myapp

docker restart postgres-demo

docker volume ls

SQL commands used:

CREATE TABLE users (
id SERIAL PRIMARY KEY,
name VARCHAR(50)
);

INSERT INTO users (name)
VALUES ('Dali');

SELECT * FROM users;

DELETE FROM users
WHERE name = 'Alex';

This video is part of the DevOps Basic with Dali series focused on Docker, Kubernetes, Terraform, CI/CD, databases, and cloud-native technologies.

#Docker #PostgreSQL #DevOps #Database #Containers #DBeaver #BackendDevelopment #CloudComputing #DockerTutorial #SQL

Видео EP08 - PostgreSQL with Docker Tutorial | Database Containers for Beginners канала Devops Basics with Dali