Get free YouTube views, likes and subscribers
Get Free YouTube Subscribers, Views and Likes

Introduction to PostgreSQL Tutorial - Part 1

Follow
Database Star

 Get my free SQL Cheat Sheets: https://www.databasestar.com/getsql...
 Learn and become confident in SQL: 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

posted by wynad2g