PostgreSQL Tutorial for Beginners
Learn PostgreSQL, one of the world's most advanced and robust open-source relational database systems. Whether you're a beginner looking to set up your first database, or a seasoned developer aiming to scale and optimize complex data structures, this course has something valuable for you.
✏️ Alexandru Cristian created this course.
Watch his Complete Android & Kotlin Development Course: www.udemy.com/course/kotlin-m...
⭐️ Contents ⭐️
(0:00:00) PostgreSQL Introduction
(0:02:03) Windows Installation - PostgreSQL and PgAdmin with Database Setup
(0:17:12) SELECT statement
(0:27:25) SELECT Challenge
(0:31:17) SELECT DISTINCT
(0:39:13) SELECT DISTINCT Challenge
(0:41:09) COUNT
(0:54:03) SELECT WHERE
(1:02:13) SELECT WHERE Example
(1:11:19) SELECT WHERE Challenge
(1:15:01) COUNT
(1:27:56) ORDER BY
(1:35:21) LIMIT
(1:42:05) BETWEEN Statement
(1:48:48) IN Statement
(1:54:18) LIKE and ILIKE
(2:11:00) General Challenge
(2:14:28) Aggregate Functions
(2:20:02) GROUP BY
(2:26:08) GROUP BY example
(2:37:17) GROUP BY Challenge
(2:38:22) HAVING command
(2:48:05) AS Statement
🎉 Thanks to our Champion and Sponsor supporters:
👾 davthecoder
👾 jedi-or-sith
👾 南宮千影
👾 Agustín Kussrow
👾 Nattira Maneerat
👾 Heather Wcislo
👾 Serhiy Kalinets
👾 Justin Hual
👾 Otis Morgan
👾 Oscar Rahnama
--
Learn to code for free and get a developer job: www.freecodecamp.org
Read hundreds of articles on programming: freecodecamp.org/news
Пікірлер: 230
If you'd like to show your support, you can also explore my course on Kotlin and Android development using a special discount code. Let's continue learning and growing together! www.udemy.com/course/kotlin-masterclass-learn-kotlin-from-zero-to-advanced/?couponCode=FREECODECAMP4AADC8F8
@matari_ganan
9 ай бұрын
thanks!
@ankitg6454
8 ай бұрын
where's the link to the dvdrental file?
@programmingwithalex.585
8 ай бұрын
@@ankitg6454 www.postgresqltutorial.com/wp-content/uploads/2019/05/dvdrental.zip
@programmingwithalex.585
8 ай бұрын
The link with the discount code is only available 30- days. Therefore, a new link with discount code is available here: www.udemy.com/course/kotlin-masterclass-learn-kotlin-from-zero-to-advanced/?couponCode=BESTCOURSE8BFCA
@user-hq3uh7sn2k
7 ай бұрын
@@programmingwithalex.585 where is the rest of this video?
For those who are facing to restore the dvdrental.tar file , Open pgAdmin < File < Preferences < Paths < Binary Path < and set the path to both the server and Postgresql to the version you have installed and set as default . Path should be pointing to your bin directory , eg : C:\Program Files\PostgreSQL\16\bin. Hope it helps! 🙌
@christopherschopf2438
3 ай бұрын
Thank you!!!
@SandeepYadav-tb1jy
3 ай бұрын
thanks bro
@hasherm5494
3 ай бұрын
Thank you.
@anakin-bj2ki
2 ай бұрын
thanks a lot mate , you helped a lot
@fefe070302
2 ай бұрын
thanks!!
My first project is on data migration to postgre and you guys came at the right time with this video. Thank you tons!!
Here's the link of dvdrental.tar file: www.postgresqltutorial.com/wp-content/uploads/2019/05/dvdrental.zip
@matari_ganan
9 ай бұрын
thank you sir! 🎩 could you pin this comment or add the link to your description?
@programmingwithalex.585
9 ай бұрын
@@matari_ganan Is not my channel, therefore I can't pin comments.
@ThePraQNome
8 ай бұрын
Thank you
@programmingwithalex.585
8 ай бұрын
The link with the discount code is only available 3- days. Therefore, a new link with discount code is available here: www.udemy.com/course/kotlin-masterclass-learn-kotlin-from-zero-to-advanced/?couponCode=BESTCOURSE8BFCA
@michaelanthony4750
8 ай бұрын
Thanks!
This was a nice refresher after being away from SQL for a bit. You do a good job at explaining each set of syntax with examples. Your challenges slides followed by expected results and then the solution slide is in a good pause/play format to test my knowledge. Thank you!
Thank you for this tutorial. I've been waiting for this as a student.
Awesome! Just what I needed as a refresher for my ongoing GIS project in PyQGIS
This channel keeps getting better and better, its like a complete free education now.
@tigana
7 ай бұрын
Can’t believe this stuff is free it’s amazing
Really waiting for this video finally it has come , Thank you 🙏🙏
For individuals facing issues with restoring the dvdrental zip file on Mac, please set the Format to "Directory" and choose the directory where the dvdrental zip file has been extracted.
@ikumargaurav
7 ай бұрын
Thank you so much! Worked for me...
@jenashingi
5 ай бұрын
might you have a solution for the same error on windows?
@ahmadhaidar7088
16 күн бұрын
@@jenashingi extract the file zip folder and choose the tar file it just worked for me!!
@danielfarmer7372
15 күн бұрын
Life saver! Thank you
watched completely, thank you
Thank you so much for this course
Thanks from india .Really slow and steady tutorial, examples are so good east to understand with your simple (english) voice modulation😘
This is amazing!
MInd Readers!!! I just decided last night to build postgres for my own sites, and today you come up with this.
@josuedehoyos
9 ай бұрын
It's call Google assist. They hear and see everything we do. 😂
@olakunledaniel2561
8 ай бұрын
@@josuedehoyosthey hear what we are thinking too 😂😂
Thank you so much for your tutorial sir! It was very detailed and useful but honestly sometimes it was really difficult to distinguish what you said and AS sounded like ass and the stuff like that. But I learned a lot from it anyway and you text files especially helped me.
Awesome 👌
Please bring a project based course which covers Nextjs, Ruby on rails & PostgreSQL
Thank You
The solution at 2:38:08 doesn't work for me. Found a solution for it where you cast the payment_date as a date. Either written like so: SELECT payment_id, amount, payment_date FROM payment WHERE payment_date::date = '2007-02-15' Or like this SELECT payment_id, amount, payment_date FROM payment WHERE CAST(payment_date AS DATE) = '2007-02-15';
Thank you for the class, if someone know a blog about good practices about administration share pls.
For those looking to restore the file , extract the .zip folder and inside you can find the .tar file..Upvote so that people can find this comment
Wow thank you for such a nice explanation ❤
Why are we not using the pgadmin that comes with postgres
How to connect oracle database with postgresql to insert oracle database all tables to postgresql
what are the prerequisites before learn PostgreSQL, i have decent understand of MERN
Wonderful
I already installed mysql and sql in my laptop, does it conflict or compromise with my installation with prostgressSql?
nice!!
Not a Postgres Course, but a 95% SQL Language course using Postgresql Database. KZread is full of such SQL courses, that tend to teach you the SQL In the name of RDBMS.
Where can we get the dvdrental database?
Hi FCC, there is not subtitle for this video.
Just finished it. Good course keep it up
@ABDTalk1
9 ай бұрын
how do you finish a four hour course in three minutes of upload?
@Ghazanfierce
9 ай бұрын
@@ABDTalk1 exactly what I came to comment LIAR... 😂
@bisw4sh
9 ай бұрын
@@ABDTalk1 i think s/he completed the one that is 4hrs long recently that is from 4 yrs ago, just like me.
Thanks for the course. The COUNT section is duplicated (0:41:09 and 1:15:01)
@funnyvideo8677
4 ай бұрын
Yes
Hi, Thank you for this tutorial but i am stuck at the restore phase, done all that needs be done but it does work, keeps saying "process failed". Please, i would appreciate a positive guidance and help in resolving this, Thank you.
@pojuagbomeji1115
5 ай бұрын
likewise myself. It keeps saying failed
@jenashingi
5 ай бұрын
same here
@esshadigitalskillsconsult
4 ай бұрын
Sam here.
@stroopwafelvla1804
3 ай бұрын
I've found a solution. I extracted the file and selected the TAR file as the destination. No error.
How did you get to set master password I am using pgadmin 8
is there a part 2 with a final project in it?
Thanks! ❤
The square brackets do not work when I try to use it.
the count section is repeated, but great video
Could you not edit out every time you are waiting for pgAdmin to load??
@robfrankel5956
5 ай бұрын
Yes, that would be good.... or just leave it open but minimised. Otherwise great video
how can I turn on the subtitle, can anyont help me pls
usually I tune in to videos to hear the person explain some other perspectives and showing their expertise and opinion and vast knowledge on something,I felt a bit of a lack when it came to that, he was just reading from the script
@samirdevechi8589
5 ай бұрын
yeah a lot of it felt like it was written by ChatGPT tbh :/
@icewallowcome3942
5 ай бұрын
@@samirdevechi8589 agreed he was just reading slides
1:15:01 why COUNT given again? it already explained on 0:41:09
where is the rest of this video?
can you please upload the ppt slides as well?
Best time to become a developer
We selected the option to have PgAdmin installed together with Postgre so why do we need to download PgAdmin separately?
@programmingwithalex.585
8 ай бұрын
You don’t; you can skip downloading pgadmin
Please add auto subtitles (it's just a checkbox in KZread, 1 sec of your time) for this video and all other videos on the channel.
where's the link to the dvdrental file?
Can't find .tar file to restore data. Pls help someone.
Hello, where is the resources under this video containing the video rental database?
@thingsgood9596
5 ай бұрын
sorry *dvd rental files?
Postgres tutorial without updating, inserting or deleting data?
For those getting "Process Failed" Error while restoring the database from zip file. Please use any file compressors to extract the tar file inside it then import the tar file!
How to Get Rd rental file ? tell me if anyone know this
How can I download the zip file, please?
great course , but for those who worked with databases before , I think u can save time and learn all those concepts from official docs in 20 min
I got to realize that whether you write queries on MySql or Postgre, most of the syntaxes are xactly same!
please switch on subtitles
can someone tell me the timestamp of JOINS?
Could you please use sequelize orm with postgresql
@illegalsmirf
9 ай бұрын
no
Nice but I don't see JOIN tables. Maybe in another tutorial?
is the count part repeated??
Please, if anyone has the database file, kindly share.Thank you.
im already on the 2 hour mark...thanks for this beautiful tutorial
For anyone having trouble restoring the database, extract the zip file and restore the .tar file contained in the extracted file
@LuckyFishM
2 ай бұрын
Thank you so much for the help....
Doesn't pg admin gets installed with postgres?
@soma7891
6 ай бұрын
Yes
wait where did you get the tar file? I mustve missed something..
@yamalaha9233
9 күн бұрын
1. Download the file from his comment. 2. Click on the folder and click extract all. 3. when reloading select the extracted folder (they look the same but the one that isn't extracted will say compressed at the side). 4. Celebrate
Please provide caption for this video.
anyone getting below error while resoring the dvdrental file ? i have downloaded files 3 times now and on 2 differnet postgre versions.. 16.1 nd 15.5 every single time it is same error... error is pg_restore: error: input file does not appear to be a valid archive
@samkale5988
7 ай бұрын
This is on Windows 11 And while the postgres 16.1 and 15.5 installation went thru' with no issues reported, i am not sure if these versions are supported on windows 11 OS.
@samkale5988
7 ай бұрын
Resolved... Silly me, i had to unzip the file and sure enough there was a tar file within... i was getting error only cause i was trying to restore zip file directly...
@RisiqahOladunni
6 ай бұрын
@@samkale5988good evening, I am also getting the same error messages, please how can I resolve the issues
hey guys just want to ask that the count content is show twice, thank you.
Is the COUNT section repeated or is it different?
@ChristopherChaduka
7 ай бұрын
Seems to be the same
Is it possibler that the [] wildcard is no more valid in PostgreSQL? Is not working form me and as far i searched over the internet they are only talking about two valid wildcards in PostgreSQL, that is % and _
@pulse3522
7 ай бұрын
I made a comment, but it seems to have not processed, for some reason. Anyway, you are correct, the square bracket functionality described in this video is not applicable to the LIKE or ILIKE pattern-matching operators in PostgreSQL. It is, however, applicable to the SIMILAR TO pattern-matching operator in PostgreSQL. The SIMILAR TO pattern-matching operator in PostgreSQL borrows many metacharacters from the POSIX standard, such as the square brackets. The LIKE and ILIKE operators are, however, relatively more secure than SIMILAR TO (although that's a large conversation to be had, and as long as the key being used for pattern-matching is not being provided by a user, then the security difference between LIKE and ILIKE, and SIMILAR TO is inconsequential).
@user-kz5xw2sq9v
7 ай бұрын
Thank you@@pulse3522
Hi. I am not able to restore .tar file. It says process failed. I am using windows OS. can you please help?
@flibben
7 ай бұрын
Same problem here and no information on why it failed.
@StockGarjanaHindi
7 ай бұрын
@@flibben actually it got resolved. See the video carefully.
@raj-pandey55
4 ай бұрын
@@StockGarjanaHindi where do i look eaxctly in the video.. i can't seem to find it. i am having the same error
@samuellucas593
4 ай бұрын
hi have you fixed the issue, I'm facing it currently@@raj-pandey55
Might you have a solution for the zip file failing to restore on a windows machine?
@AwaAnderson
4 ай бұрын
Please have you had any success with this i ma currently stock here
Currently stuck when I want to restore the 'dvdrental file'. It was giving me the following error message "Utility file not found. Please correct the Binary Path in the Preferences dialog" Any help please? I wish I can share a screenshot. 😓
@alarezomoosamuyi8526
8 ай бұрын
Hello @segun, do you still need help??
@E.K.S08
8 ай бұрын
hello, im facing the same problem. any suggestion?
@segunfunmi
8 ай бұрын
Yes, I am still facing the same problem. Any help? @@alarezomoosamuyi8526
@greg3458
8 ай бұрын
make sure to unzip then click on the folder then on the file should work
@_promptcoder
8 ай бұрын
@@greg3458 If you are using ubuntu try to make it tar file instead zip format. I faced the same issue and fixed it.
Man I just searched for it like 15 mins ago.
Why you disabled auto subtitles for a video like this?
As there is no link in the description for the exercise file needed to follow this tutorial, it's usefulness is extremely limited.
सीता राम इतना उपयोगी ज्ञान और संक्षिप्त पाठ्यक्रम देने के लिए धन्यवाद ❤🎉
@maksimbondarenko1179
9 ай бұрын
пер андерстенд
Dear sir, my request to you all that please launch a free course on 3d animation. Please sir. ❤
@purplepixeleater
8 ай бұрын
thats not code lol
please the restore doesn't seem to work keep giving a failed response, i am using windows Please any one who can help
@seeker511
4 ай бұрын
Extract the zip file after that you will get a tar file, try using that!
@seeker511
4 ай бұрын
Extract the file and try!
and what language he spoke ?
Tô top top
The zip file mentioned is not able to restore the database, pgAdmin needs tar file and conversion didn't help!
@whoisarod
8 ай бұрын
were you able to extract it properly?
@dino_xy
8 ай бұрын
Have you solved it?@@whoisarod
@mehulbhatt1929
5 ай бұрын
To restore DB, From Program Files > PostgreSQL > 15 > bin, copy everything from bin folder to pgAdmin4 > runtime Folder. This will solve restore error
@dirudeen1421
5 ай бұрын
@@mehulbhatt1929 thanks a lot, it worked perfectly
@Murugesanmurugesan-mr6ji
3 ай бұрын
@@mehulbhatt1929bro I have copied those files, where to paste them please let me know
guys the link to the file is in the comments. go through
what's the difference between this and the previous freecodecamp postgre video?
@shadyawad5383
8 ай бұрын
This one comes in a incomprehensible thick accent
@torrvic1156
7 ай бұрын
@@shadyawad5383or it have the distinct original style.
unable to convert .zip file to .tar a on macOS. Currently stuck. HELP!
@mindevo3677
8 ай бұрын
Dont need to convert. Just unzip the file, the tar is in it.
@ClaireEB328
8 ай бұрын
I am stuck here too. Using a macOS, the file is unzipped, do not see .tar. Were you able to figure it out?
@ClaireEB328
8 ай бұрын
Update: I deleted every thing after dvdrental/ on the file path and it worked for me!
@whoisarod
8 ай бұрын
@@ClaireEB328great! I will try that!
@Jakan-sf3xj
8 ай бұрын
This helped. Thank you@@mindevo3677
Any solution in 2:17:27 ?
@avrakadavra1552
Ай бұрын
I'm trying to display the other rows of aggregated function result
HI! I didn't get the part of downloading from step3 i.e dvdrental file , can anyone help me out here?
@programmingwithalex.585
9 ай бұрын
www.postgresqltutorial.com/wp-content/uploads/2019/05/dvdrental.zip
COUNT IS REPEATED?????????
I expcted to have some words on Backup, restore, and regulare maintenance operations!
Couldnot have been more timely
The first❤
can't understand the language,
for someone with error "Restoring backup on the server PostgreSQL 16" Process failed at 16:18 , check this video : kzread.info/dash/bejne/nZ-rmI-ziM7YYKw.html
Why no migrations?
Welcome 🤖to the exciting 🤖 world 🤖 of relational databases. 🤖
Can someone please do a video about oracle apex
first