Introduction to PostgreSQL Tutorial - Part 1
📝 Get my free SQL Cheat Sheets: https://databasestar.mykajabi.com/lpk...
🎓 Master SQL Fundamentals: https://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: https://github.com/bbrumm/databasesta...
Install Postgres on MacOS: • How to Install Postgres on MacOS
Install Postgres on Windows: coming soon
On this page of the site you can watch the video online Introduction to PostgreSQL Tutorial - Part 1 with a duration of hours minute second in good quality, which was uploaded by the user Database Star 18 April 2023, share the link with friends and acquaintances, this video has already been watched 145,579 times on youtube and it was liked by 2.3 thousand viewers. Enjoy your viewing!
