Intro To PostgreSQL Databases With PgAdmin For Beginners - Full Course
HTML-код
- Опубликовано: 25 июл 2024
- 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
Codemy. com
▶️ Learn to Code at Codemy.com
Take $22 off with coupon code: youtube
✅ Get The Full Course On Udemy for $9.99
bit.ly/2WpV50t
▶️ Join My Facebook Group:
bit.ly/2GFmOBz
✅ Subscribe To My RUclips Channel:
bit.ly/2IGzvOR
![SQL Tutorial for Beginners [Full Course]](http://i.ytimg.com/vi/7S_tz1z_5bA/mqdefault.jpg)
![SQL Tutorial for Beginners [Full Course]](/img/tr.png)
Finally Walter White comes to teaching SQL
Almost sounds like Bryan too 🤒
Only for this string it was worth to scroll the comments!
XD
skip the install part if you already have the setup in place: 12:12
Thank you, Daiana!
wish I saw your comment at the beginning . Seeing your comment after the vdo completion XD
Thank you!!
Awesome! It's so difficult to find tutorials that don't spend most of the time explaining the product benefits!
Glad you liked it!
This is a good introductory tutorial for PostgresSQL and the tools which enforce it. Good job here Codemy.
Glad you enjoyed it!
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.
glad you liked it!
Very well done! Keep up the good work!
Thanks! Glad you enjoyed it!
Спасибо! Очень хорошо рассказано, понятно что и как делать !!!!
To skip the install and theory, go straight to: 18:30
Informative and easy to understand. Thank you!
Glad it was helpful!
Great video! I will be sharing it and adding it to one of my play lists
Glad you liked it!
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.
Glad you found it useful!
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 🤗🤗🤗
Glad you enjoyed it!
Perfect! All I needed!
such a good and descriptive tutorial.. Love it!!
Thanks!
Thank you very much. Couldn't find it anywhere else.
Glad you liked it!
Thank you sir. Great video.
You're welcome!
Thanks John, so enlightening!
welcome!
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?
thanks a lot for quick and comprehensive tutorial.
Welcome!
Tnk u. superb. easy to understand
Thanks for simplifying the lesson. It really helped.
Please, how do I save my sql script in case I wanna come back to it later to continue?
What do you mean, just save it. Click the file>save button on the text editor.
Skip to 18:33 if you already have everything installed and already know what a database is...
Great work! How can i find the continue of this lesson in udemy?
thanks
You can find it here at discount today: bit.ly/2MIpwJh
How do I input: films that start with the letters S and T? Thank you for your help.
Thank you teacher !
You're welcome!
This is a great tutorial.
Thanks!
How can I see the datatype length like (VARCHAR(30)) along with attribute name in table.......
Really enjoyed this course
Thanks!
Hi, I enjoyed watching your video tutorial. Do your courses cover basic instructions consist of using SQL language consist of data query language, data definition, or data manipulation language? I appreciate your feedback. Thank you
great work perfect tutorial thank you.
Glad you found it useful!
All of his tutorials are great
@@DamnBoii123 Thanks!
thank you for the video. very helpful! cheers from Israel ✌
Glad you enjoyed it!
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?
In the video, I talk about using one of three different connectors (if one doesn't work). Did you try all three?
Thanks!
Enjoy!
If sql coding dialog box move in other place then how i set it on its default place?
Hi John I cannot add my data in the colums ?
really nice tutorial and clean explanation
Glad you liked it!
@@Codemycom John I have a question to you and I will be very happy if you reply. I try to insert real time data to my database and what I want to do is this:
I had created a postgres database with two columns for testing with double data type with 20 rows as Null at the beginning; but when I use insert, the data is being inserted from the 21st row which it doesn't insert from the first row.
To insert the incoming real-time data to specific row (starting from 1st row to infinite) to the a specific column location in the PostgreSQL. I feed this real time data from Matlab too. Thus, is there a specific command for what I want to achieve in PostgreSQL? thank you.
when i click import/export i get "utility not found. please setup binary path in preferences" or something. In preferences I put c:\Program Files\PosgresSQL\15\bin for the binary path but it says it can't find the 4 files it's looking for there
great informative video, much appreciated
Glad You liked it!
Thank you sir.
You're very welcome!
Im trying to use pgadmin 3 , postgre sql in ubuntu 18.4 version ... I'm getting error as " Access to database denied"
While I'm giving passwrd and user in pg admin
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?
Awesome👍
thanks!
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 - sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) unable to open database file
Nice video, ........ but what happens if you can not connect to your existing database on Linux. And haw to do if your data is on a user defined disk ??
Thank you very much
You are welcome
thank you!
Welcome!
Great informative Video, really appreciate your work!
Thanks!
Thinking of buying a course for intermediate level as I have Data Bases(SQL) class in this semester. Thanks for the video!
Cool!
When I started the pgAdmin4 doesn' t have any preview server. What do I do? (ps: sorry if I wrote wrong, my english is bad)
Make sure you selected postgresql server on port 5432 on install
Should open up localhost connected to pgadmin
I can help you if you're on discord
thank you sir love from Nepal
Welcome!
Hi , I can't edit the data after I started a new database. In view data it is showing a lock symbol in all oclumns
Hello, thank you for making this video!!
I do have a problem. This tutorial was going great for me until 19:50 where I realised i dont have the plus sign beside the 'Server' to continue on to create a database :(
Weird...what did you do differently from my videos?
no :( I did follow everything. I am on MacOS server and even tutorials for macOS installations had the plus sign.
Will try to google and search around :’)
I also faces same issue, go to create server option type localhost in host and you user name and password and click on the save
did you got rectified bro?
same here
Well explained
Thanks!
It is impossible to work with pgAdmin4. It is so slow. I am trying to create the database and is now waiting for 13 minutes for the Create Database screen to show me this field that needs to be entered. I am working on a Windows 10 PC and is connecting to the localhost. I am doing something wrong?
Thanks for your help! What about Mac users?
maybe watch Postico tutorials :))
can i use this for django?
Can you PLEASE do a video on how to create a cluster with a different user different from default user (POSTGRES)
Wondering if anyone has this problem as well;
So, I still running my Windows on the version 8.1
I tried to install the PostgreSQL following the instruction on the video.
However, I got a warning message just before the progress bar finish.
From what I see, it happens when it's installing the database cluster.
About the warning messages:
'Problem running post-install step. Installation may not complete correctly.
The database cluster initialisation failed.'
Been trying looking for the solution on the web, but none actually help me solve this issue.
I am wondering if you can help me fix this problem?
After spending another hour to find the fix, I am happy to inform you that I managed to install it without any error.
Thanks
Welcome
Hi
how could I increase the size of the font of the database tree pannel in pgadmin4?
no clue
nice tutorial. but, when i click on server, it doesn't show me the postgres 13. i created a database in control panel but, i can't find even the postgres 13 on my server. the server is empty. please sir i need your help.
You Rock!
Thanks!
Thank you for the video. My PGADMIN does not open in a browser. Will that be fine.? I am using the latest version of postgresql. I am a complete newbie. Kindy guide.
that's fine
using newest pgadmin... the save icon doesn't seem to be doing anything for me, so after I added Mary Brown, I went back and my other data wasn't there... =-\
I figured it out via stack overflow - use the next icon over, the 3 disk shaped "Save data changes" button, or F6
Hi, I loved this video but it didn't go quite far enough for me. I have 2 tables that are "related" to each other and need to connect them. Do you have a tutorial on that? Thanks!!
look up joins
@@Brian-xb7qv can you give me a LINK to the video please? Thanks!!
perfect
Thanks!
Having some trouble creating extra rows
The id is a primary key, what am I doing wrong? This syntax seems correct
INSERT INTO employees (id, name)
VALUES (1, "John Doe")
Edit: id was type "int" not a serial
Been looking all over , postgres docs, stsckoverflow, etc
What's the error message? Is 1 already taken? Primary keys cannot be used by another row.
Hi John! I have a problem. I'm trying to load a sample database by restoring it on pgAdmin and once I choose the .tar file and hit "restore" I get "Failed (exit code: -6)" message. Any idea what's wrong and how to fix this? Tried Googling these exit codes, but I can't find anything.
tar files aren't database files. Tar files are zip files...you have to unzip it first, then load the unzipped (or I guess un-tarred) file.
@@Codemycom Thanks for the reply. Still no luck though. It was so misleading, because even the pgAdmin says in the restore window that the format would be "custom or tar". I was reading this PostgreSQL tutorial about loading a sample database and there it was .tar-file that was used.
New table created at 24:33. Finally! Pheww!
lol
Quick question!!!! I had my pgadmin all up and running and then one time upon opening I lost my browser tab ,when I click on add server and nothing happens. I deleted all files and my Postgres that I was running on it… and reinstalled. Reset layout etc Nothing ! I was told to change ip address ….. I am sooo lost any suggestions?
Not sure what you mean...but delete everything, watch the video again, follow along exactly.
Hi there , I couldn’t find PostgreSQL under server though I installed both . Can someone help me with this?
Try reinstalling it. Watch the video again to see what you missed
I was Just getting pretty surprised..
The explanation before 22.00 it was the same explanation given by my Lecturer last year...but fortunately I came Across this channel because unfortunately my Lecturer is changed...
Ha
I am having an issue with foreign keys in postgresql. I have an application that has user registration/login and when u login you post a new article. I have two tables one table is users and one table is articles. The users table has 3 columns userid, password, username. The articles table has 6 columns. Articleid, dateupdated, datecreated, body, title, and userid. When I post an article after a user is logged in I dont get the corresponding userid with the article that is posted. Userid column in the articles table just says null. I made a foreign key called article_userid_foreign_key with local column set to userid reference the public.users table referencing the userid. I am using node is I have let userId = req.session.user.userId; the other columns are getting data like body, title, ect. The userid column under articles is just getting back null. Can anybody help ke with this
I'd post your code and question at stackoverflow and ask for help there. Without the code it's hard to help and you can't really post the code here in easily readable format.
@@Codemycom github.com/cardfaux/postgreSQL?files=1
I put it on github. I've posted questions everywhere and 8 have emailed professors at the local community college here where I live In bumb fuck Alabama and they said that postgreSQL databases was out of their expertise. The problem could be my pgAdmin set up but I have changed all of it multiple times
if you are not able to save the input data in table by clicking the icon try pressing F6 32:29
thanks. you save me
thanks
Welcome!
I did'nt understand 31:21 part of how to import data and save file can u please explain it.
Didn't I show how to do it in the video?
Walterwhite is teaching Postgre, I can't refuse to watch in one go
Ha!
hello Teacher, I need your help , I want to create an electronic paper archiving server but have no idea
If you can give me some advice or help me
No sorry
Hey man, I want to save a PGadmin file, but then nowhere does the PGADMIN appear fro me to save it to. If I click save it saves it to google chrome browser. Please help
what file do you mean?
@@Codemycom I just want to save my pgadmin work, if I click on save, and I want to choose a location, it does not allow me, basically it's disabled (the save button)
Hi,
Actually i want to restore a file in Pgadmin 4 but it is not restoring as required.
can you let me know if a file in preview format(Notepad) be restored in Pgadmin 4 or not ?
If Yes , How?
OS - Windows 10 , PostgreSQL 10 , 32 Bit
Sure, but without knowing your situation, I couldn't guess.
@@Codemycom
Can you let me know a mail id on which I can contact and elaborate my issue?
i have intalled postgresql, im now trying to install Dspace
ok
Can anyone answer the following question: How do I process the input of a form and insert the values into multiple related tables with Node.js and Postgresql?
Big question! If you want to update two or more tables at the same time then you need to create stored procedures. The procedure (like a NodeJS function) takes a number of parameters that will be written to tables. Alternatively you can write a number of database update statements and get NodeJS to handle each table update. (Not good practice.) Either way you will need to add PostgreSQL database functionality to your NodeJS code.
@@undercrackers56 Many thanks for your detailed answer. Can you give me a few technical terms I should deal with?
Thanks bro!
Sure thing!
how to import sharepoint data
Postgres 10 in the video, in 14 you need to write "INSERT INTO public.customers" so skip the "" at 34:04
PGadmin overview 18:32
I don't see any coupon code. Can you provide coupon code so that I can buy from Udemy?
JOHN_ELDER25
starts at 3:26
Interesting suggestion.
Someone give this (wo)man a Like!
when i click save,It doesnt automatically assign number 1 to id.why?
Cuz you did something wrong with your code, I assume...
Look for "postgresql auto increment" on google, I assume that will be enough.
I had a problem getting past the password requirement but I found this fix online. It gets rid of the need for a password.
in folder C:\Program Files\PostgreSQL\9.2\data or C:\Program Files (x86)\PostgreSQL\9.x\data, you'll find the pg_hba.conf text file.
Find the following lines:
# TYPE DATABASE USER ADDRESS METHOD
# IPv4 local connections:
host all all 127.0.0.1/32 md5
# IPv6 local connections:
host all all ::1/128 md5
and change METHOD md5 to "trust" like this:
# TYPE DATABASE USER ADDRESS METHOD
# IPv4 local connections:
host all all 127.0.0.1/32 trust
# IPv6 local connections:
host all all ::1/128 trust
Cool
THanks
elephant vs dolphin?! tough choice
best
Thanks!
My personnel favorite - "FLAT_EARTH_GUY" !!
Ha
it wont let me save after inserting into table
Did you google the error you're getting?
click on "Save Data Changes(F6)" icon on the right side of "Save File" icon .
How come you didn’t use the postgresql shell
why would I?
what is key difference between postgreSQ and MYSQL
MYSQL is way better than PostgreSQL, trust me that is true. PostgreSQL query language is so stupid.
@@siweiwu65 PostgreSQL is very efficient and even used by big companies such as Instagram
@@siweiwu65 dumbest comment of the year goes to...
O god, it's Heisenberg!
Ha!
and boom, I'm more familiar with pgadmin
awesome
Skip the PostgreSQL install and the explanation of what a database is by going to 18:28