Скачать или смотреть SQL & PostgreSQL Tutorial Series – Introduction for Absolute Beginners

Welcome to the introduction video of my SQL & PostgreSQL tutorial series!

In this video, we start with the basics of SQL, understand how data is managed in real applications, and then connect to PostgreSQL using simple commands.

🔥 Topics Covered:
-----------------------------------
✔ What is SQL?
✔ Why SQL is used
✔ How relational databases work
✔ Introduction to PostgreSQL
✔ Creating a database using psql
✔ Creating users and assigning permissions
✔ Connecting to PostgreSQL from the terminal
✔ Verifying database connection

💻 Commands Used in This Video:
-----------------------------------
psql -U postgres

CREATE DATABASE tuto;
CREATE USER username WITH PASSWORD 'yourpassword';
ALTER DATABASE tuto OWNER TO tutorials;
ALTER USER username WITH SUPERUSER;

psql -h localhost -p 5432 -U username -d dbname

Actual Terminal Demo Output:
-----------------------------------
psql -U postgres
Password for user postgres:

psql (17.2)
WARNING: Console code page (437) differs from Windows code page (1252)
8-bit characters might not work correctly.

postgres=# CREATE DATABASE tuto;
postgres=# CREATE USER tutorialuser WITH PASSWORD '123';
postgres=# ALTER DATABASE tuto OWNER TO tutorialuser;
postgres=# ALTER USER tutorialuser WITH SUPERUSER;
postgres=# exit

C:\Users\akhau ▶ psql -h localhost -p 5432 -U tutorialuser -d tuto
Password for user tutorialuser:

tuto=# \d
Did not find any relations.

This confirms our PostgreSQL database is created successfully and ready for tables.

📌 Next videos in this series:
-----------------------------------
• Installing PostgreSQL properly
• SQL basic queries (SELECT, INSERT, UPDATE, DELETE)
• Understanding WHERE, ORDER BY, GROUP BY
• Creating tables and relationships
• Real-world SQL examples
• Joins explained in the simplest way
• SQL interview questions

If you found this helpful, LIKE this video and SUBSCRIBE to follow the complete SQL & PostgreSQL series.


#sql #postgresql #sqltutorial #psql #postgres #databasetutorial #learnsql #sqlforbeginners #postgresqltutorial