Introduction to PostgreSQL Tutorial - Part 1

📝 Get my free SQL Cheat Sheets: www.databasestar.com/get-sql-...
🎓 Learn and become confident in SQL: databasestar.mykajabi.com/sql...
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:
Queries used in this video: github.com/bbrumm/databasesta...
Install Postgres on MacOS: • How to Install Postgre...
Install Postgres on Windows: coming soon

[@DatabaseStar]

Get my free PostgreSQL Cheat Sheet to help you remember commands and keywords when reading and writing SQL here: www.databasestar.com/postgres-cheat-sheet/

[@totonk793]

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

[@DatabaseStar]

Thanks! I'm glad you like it.

[@rajeshrathod3113]

Looking forward for the complete series. Thanks

[@DatabaseStar]

Awesome! I'll aim to have part 2 out in a few weeks.

[@yannaingkyaw6310]

I've seen and watched a lot of tutorials on RUclips 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.

[@DatabaseStar]

Thanks for the comment, and I’m glad you like it. Yeah I’ll be creating the rest of this series starting with lesson 2 soon.

[@bonsayeb9620]

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

[@DatabaseStar]

Thanks! Part 2 is coming in a couple of weeks and the next one soon after that.

[@andrewgraves9007]

thank you for this. Looking forward to the rest.

[@DatabaseStar]

Awesome!

[@annalutini]

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

[@DatabaseStar]

Glad it was helpful!

[@kostiantynkarzhanov9216]

Awesome tutorial! Thank you so much! 💛

[@DatabaseStar]

Glad it was helpful!

[@DevThought]

Awesome! please continue!

[@DatabaseStar]

Thanks! Glad you like it.

[@vylonygo7410]

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

[@DatabaseStar]

Thanks! Yeah I have part 3 coming out soon, and I plan to continue the series.

[@frantzp1718]

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.

[@DatabaseStar]

Thanks for the kind words! I'm glad you found the video useful!

[@kristofermetusala8859]

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

[@DatabaseStar]

Thanks! Glad to hear it

[@shwepwinthlwaroo9699]

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

[@DatabaseStar]

Glad it was helpful!

[@investwisely5043]

Well explained and very easy to understand. Thank you

[@DatabaseStar]

Thanks! Glad you liked it.

[@billywilliam7747]

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

[@DatabaseStar]

Thanks, glad you liked it! Sure, I can look into creating project examples.

[@englui]

Very helpful ,thank you

[@DatabaseStar]

Glad it was helpful!

[@MohammadLsk]

Great 💥

[@DatabaseStar]

Thanks!

[@raykhonayorieva7156]

thank u I opened easily !

[@DatabaseStar]

You're welcome!

[@vijeshnk1355]

this Tutorial is awesome

[@DatabaseStar]

Thanks!

[@darijozivkovic7931]

More Postgres tutorials please.

[@DatabaseStar]

Sure, I'm planning some soon.

[@rubensorianojr.flores7132]

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

[@DatabaseStar]

Thanks! Yes there will be a part 2, I'm working on that video now, so it should be out in a couple of weeks.
It's not necessary to know what a schema is to get started, but as you learn more, it could be good to know.
A schema is a named collection of different tables and other objects in a database. It's a way to organise different areas of the database, which is especially helpful for larger databases.

[@kehindefagbohungbe]

Thank you

[@DatabaseStar]

You're welcome

[@berkayaydn4913]

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

[@DatabaseStar]

What do you mean by automatically add sentences in the middle of writing? Do you mean the keywords like Create that automatically complete? Or something else?
I’m not using any extensions. This is just plain pgAdmin.

[@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

[@DatabaseStar]

I'm not sure what the USE command and Parse All are doing here. You should be able to use pgAdmin like I have in this video to access your database, and the next video will show you how to start with SQL.

[@hyperannatv3387]

Do u have PHP and postges installation?

[@DatabaseStar]

No, not for these videos. It's just Postgres.

[@hyperannatv3387]

@@DatabaseStar sir how to connect php and postgres? Any videos?

[@oguzturkyilmaz543]

Thank you

[@DatabaseStar]

You're welcome

[@ginikadaily]

Thank you

[@DatabaseStar]

You're welcome