Introduction to PostgreSQL Tutorial - Part 1

If you're interested in learning PostgreSQL, or even SQL in general, then this is the video for you.

In this video, you'll learn:
- how to connect to a Postgres database using a tool called pgAdmin (which comes with the Postgres database)
- how to create a table to store some data
- how to add data to a table
- how to see the data in a table
- how to fix a couple of errors you may find as part of this process

This is the first of a series of PostgreSQL tutorial videos, so if you like this one, you should enjoy the next videos as well.

Let me know in the comments below what you think and if you have any questions.

⏱ TIMESTAMPS:
00:00 - What we will cover
01:14 - Open pgAdmin
02:21 - Connect to the database
03:46 - Create a table
09:20 - Run our statement
10:10 - Error and solution
10:51 - Insert data
14:33 - View our data
15:55 - Insert more data

🔗 VIDEO LINKS:
Install Postgres on Windows: coming soon

[totonk]

Thank you, dear! It's priceless! Your manner of giving the info is just what a man needs

[bonsayeb]

Really like your teaching style, looking forward to part 2, 3, 4, 5 etc :D

[yannaingkyaw]

I've seen and watched a lot of tutorials on Youtube about PostgreSQL, but this is a geek explanation. I'm self- learner, so I'm afraid to do mistake what if I press wrong button, what will happen if I do that. Finally, I know what if situation with demonstrative explanation. Thank you so much! Keep going and looking forward for the complete series.

[rajeshrathod]

Looking forward for the complete series. Thanks

[frantzp]

Hello kind sir, I just wanted to say thank you for such an amazing and simple video. This is my first experience using SQL and I am not tech savvy and you made this entire first lesson incredibly easy for a beginner like me to follow. Kudos to you and thank you. I will be watching all your SQL videos.

[annalutini]

Amazing! Lots of useful information in short time! Thank you so much :)

[andrewgraves]

thank you for this. Looking forward to the rest.

[kristofermetusala]

i love hearing your voice. It calms me down while trying to figure out my code :D

[kostiantynkarzhanov]

Awesome tutorial! Thank you so much! 💛

[vylonygo]

You are really good at this, please don't forget this series

[shwepwinthlwaroo]

This is very clear and easy to understand. Thanks for sharing with us.

[billywilliam]

THANKS for the clarity and good pace - you look very patient that not everyone has 👍
Can you also discuss project examples of using PostgreSQL? Starting from simplest one - I beleive most people need them

[investwisely]

Well explained and very easy to understand. Thank you

[rubensorianojr.flores]

Will there be a part two soon? Loved the explanations! Also, is it necessary to know what a schema is?

[berkayaydn]

whıch extantion are you using in order to automaticly add sentences in the middle of writing??

[IProrok_]

Hi I don't know if you could help me but I am following some instructions for creating a game server and after instalation postreSQL next steps are:
Use update-database
Parse all
I don't know if i should type as a code or it is in options. I'm not even novice in programing and all code stuff but I want to try even if I fail.
Watching your tutorials it should be easier. :D

[hyperannatv]

Do u have PHP and postges installation?