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:
Queries used in this video: https://github.com/bbrumm/databasestar/blob/main/videos/82_intro_postgres_1/queries.sql
Install Postgres on MacOS: https://www.youtube.com/watch?v=Z-iM7hUdBSg
Install Postgres on Windows: coming soon

🔗 RESOURCES:
Get my free SQL Cheat Sheets for Oracle, SQL Server, MySQL, and Postgres here: https://www.databasestar.com/get-sql-cheat-sheets/

SQL Roadmap: an overview of SQL topics, which is a great place to start: https://www.databasestar.com/sql-roadmap/

Contact me here for questions, sponsorship requests, and more: https://www.databasestar.com/contact/

Want to take your database and SQL skills to the next level? Sign up for Database Star Academy, the online platform for database development and SQL. Check it out here: https://www.databasestar.com/dsa/