Intro To PostgreSQL Databases With PgAdmin For Beginners - Full Course

In this course I'll teach you how to setup and use PostgreSQL databases with the PgAdmin 4 interface! 

There's a reason why Postgres is so popular, find out why in this course!

You have many databases to choose from, and even many free databases to choose from. But Postgresql is constantly ranked a top database for everything from data analytics to basic web development - and everything in between. 

Postgres is pretty easy to use!  You'll be amazed at how quick and easy it is to dive in and get started!

In this course, you learn to:

✅ Install pgAdmin and PostgreSQL

✅ What Is A Database

✅ pgAdmin Overview

✅ Create Table Columns

✅ Add Data To A Table

✅ PostgreSQL Select Statements

✅ PostgreSQL Where Clause

✅ PostgreSQL Wildcards

✅ PostgreSQL AND OR NOT

✅ PostgreSQL Order By

✅ PostgreSQL Insert Into

✅ PostgreSQL Update

✅ PostgreSQL Delete

✅ PostgreSQL Limit

✅ pgAdmin Menu Walkthru

✅ PostgreSQL Foreign Keys

✅ PostgreSQL Inner Join

✅ PostgreSQL Join Where Hack

✅ PostgreSQL Delete Table

✅ PostgreSQL Import and Export Tables

✅ PostgreSQL Backup and Restore Database

✅ And More!

This course is perfect for anyone just starting out, you don't need any special skills or prior knowledge to take this course.

What are you waiting for, let's learn some PostgreSQL database wizardry!

-John Elder

Take $22 off with coupon code: youtube

✅ Get The Full Course On Udemy for $9.99

▶️ Join My Facebook Group:

✅ Subscribe To My YouTube Channel:

[rupam]

Finally Walter White comes to teaching SQL

[ArtLoverDaiana]

skip the install part if you already have the setup in place: 12:12

[petercampbell]

Awesome! It's so difficult to find tutorials that don't spend most of the time explaining the product benefits!

[JK-nxwd]

This is beyond good. Every time i get stuck with something and look online, up you pop. Thanks loads as have been using mysql, now switching to postgresql to use ArrayField and hit with another new admin setup to tinker with and get familiar with.

[deprsul]

Спасибо! Очень хорошо рассказано, понятно что и как делать !!!!

[gurunathrao]

This is a good introductory tutorial for PostgresSQL and the tools which enforce it. Good job here Codemy.

[conradlewis]

Very well done! Keep up the good work!

[ltomic]

Informative and easy to understand. Thank you!

[urtohjs]

How can I see the datatype length like (VARCHAR(30)) along with attribute name in

[jig]

nice work.. this was very helpful. At first glance, PGAdmin looks very complicated. As you mentioned all of the options under database can be very overwhelming. I really wanted to know how to use the tool as an IDE. Thanks for the insight.

[JBGeckoyt]

Great video! I will be sharing it and adding it to one of my play lists

[mariaheirich]

What is the rule for when the parenthesis should be used? Also, why the double quotes in one place and the query and single quotes in another part? Is there a rule for this as well?

[joselitoreyes]

How do I input: films that start with the letters S and T? Thank you for your help.

[SisiNifemi]

I just started my journey into data and I stumbled on your video, it was a good watch thank you for putting dis out there 🤗🤗🤗

[sandeepkumar-bhde]

If sql coding dialog box move in other place then how i set it on its default place?

[mishalbisharat]

Hi John I cannot add my data in the colums ?

[hanadraskovic]

hm, i installed everything and when i try to start pdAdmin it just freezes and reports Fatal Error. I am on Windows 10 pro. i tried everything i could find online, mostly on stackoverflow and nothing helped? i unnstalled pgAdmin only from the whole postgres installation and installed pgAdmin separately. that didn't help eather. i added the sqlite3 path to my env paths and it only gave me another error - (sqlite3.OperationalError) unable to open database file

[testeteste]

Thank you very much. Couldn't find it anywhere else.

[johanapolinarioveliz]

My autocompletion ctrl + space doesn't work, I am using Chrome, Windows 10, and I check preferences into the pgadmin and the autocomplete is True. I don't know what is wrong. :( Could you help me, please Codemy?

[learningchannel]

Hi There I am having issues setting up my access to my works database through my mac. I think the tunnel is the issue. I am not able to find information on the issue. Do you have any recommendations?