PostgreSQL Tutorial for Beginners

[@programmingwithalex.585]

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]

thanks!

[@ankitg6454]

where's the link to the dvdrental file?

[@programmingwithalex.585]

@@ankitg6454 www.postgresqltutorial.com/wp-content/uploads/2019/05/dvdrental.zip

[@programmingwithalex.585]

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

[@Laptop-s8b]

@@programmingwithalex.585 where is the rest of this video?

[@programmingwithalex.585]

Here's the link of dvdrental.tar file: www.postgresqltutorial.com/wp-content/uploads/2019/05/dvdrental.zip

[@matari_ganan]

thank you sir! 🎩 could you pin this comment or add the link to your description?

[@programmingwithalex.585]

@@matari_ganan Is not my channel, therefore I can't pin comments.

[@ThePraQNome]

Thank you

[@programmingwithalex.585]

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]

Thanks!

[@synen]

This channel keeps getting better and better, its like a complete free education now.

[@tigana]

Can’t believe this stuff is free it’s amazing

[@allengeorge15]

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

[@teknoh]

MInd Readers!!! I just decided last night to build postgres for my own sites, and today you come up with this.

[@josuedehoyos]

It's call Google assist. They hear and see everything we do. 😂

[@olakunledaniel2561]

​@@josuedehoyosthey hear what we are thinking too 😂😂

[@hyunduk0206]

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]

Thank you so much! Worked for me...

[@jenashingi]

might you have a solution for the same error on windows?

[@ahmadhaidar7088]

@@jenashingi extract the file zip folder and choose the tar file it just worked for me!!

[@danielfarmer7372]

Life saver! Thank you

[@ramthenmala]

worked mate. Thanks for this

[@Aishwarya_st]

My first project is on data migration to postgre and you guys came at the right time with this video. Thank you tons!!

[@jakesimmens]

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!

[@jeffsellers5468]

After following this video instructions there are now two locations for pgAdmin4. Start Menu->Programs->PostgreSQL Start Menu->Programs->pgAdmin 4 I chose the 2nd one that we downloaded, which is the latest version. the first one is included in the Postgres database download

[@ilcastilho]

Yes. I got both pgAdmin, and both run perfectly. Should I uninstall one of them just like he did?

[@SeanPizzaSpark]

Thank you for this tutorial. I've been waiting for this as a student.

[@vijayarajan-bt5fk]

Thanks from india .Really slow and steady tutorial, examples are so good east to understand with your simple (english) voice modulation😘

[@seroma3516]

Awesome! Just what I needed as a refresher for my ongoing GIS project in PyQGIS

[@alejo5007]

Thanks for the course. The COUNT section is duplicated (0:41:09 and 1:15:01)

[@funnyvideo8677]

Yes

[@theodorebenjaminvonberkens2216]

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]

yeah a lot of it felt like it was written by ChatGPT tbh :/

[@icewallowcome3942]

@@samirdevechi8589 agreed he was just reading slides

[@flibben]

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';

[@dochinaschannel2776]

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]

likewise myself. It keeps saying failed

[@jenashingi]

same here

[@esshadigitalskillsconsult]

Sam here.

[@stroopwafelvla1804]

I've found a solution. I extracted the file and selected the TAR file as the destination. No error.

[@dattadigambar4038]

Really waiting for this video finally it has come , Thank you 🙏🙏

[@tejasukalkar2199]

Please bring a project based course which covers Nextjs, Ruby on rails & PostgreSQL

[@golmanjedan1861]

For those who are trying to open the provided .zip file. Just copy/extract the folder named 'dvdrental.tar' from the downloaded folder named 'dvdrental.zip' to some location you want on your machine. Then, from pgAdmin when you need to 'Restore' -> find and select a zipped folder named 'dvdrental.tar' (you have to select 'All file types' as mentioned in the video). After selecting 'dvdrental.tar' -> click Restore and that's it.

[@thegoingwolf9674]

For anyone having trouble restoring the database, extract the zip file and restore the .tar file contained in the extracted file

[@LuckyFishM]

Thank you so much for the help....

[@anabildebnath2590]

I got to realize that whether you write queries on MySql or Postgre, most of the syntaxes are xactly same!

[@SreekanthKaringula]

watched completely, thank you

[@gabrielgrabois]

the count section is repeated, but great video

[@aymanelaouad1028]

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

[@mickeyfounder]

1:15:01 why COUNT given again? it already explained on 0:41:09

[@nothinwritten]

Could you not edit out every time you are waiting for pgAdmin to load??

[@robfrankel5956]

Yes, that would be good.... or just leave it open but minimised. Otherwise great video

[@StockGarjanaHindi]

Hi. I am not able to restore .tar file. It says process failed. I am using windows OS. can you please help?

[@flibben]

Same problem here and no information on why it failed.

[@StockGarjanaHindi]

@@flibben actually it got resolved. See the video carefully.

[@raj-pandey55]

@@StockGarjanaHindi where do i look eaxctly in the video.. i can't seem to find it. i am having the same error

[@samuellucas593]

hi have you fixed the issue, I'm facing it currently@@raj-pandey55

[@torrvic1156]

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.

[@JirayuVijjakajohn]

Just finished it. Good course keep it up

[@ABDTalk1]

how do you finish a four hour course in three minutes of upload?

[@Ghazanfierce]

​@@ABDTalk1 exactly what I came to comment LIAR... 😂

[@bisw4sh]

@@ABDTalk1 i think s/he completed the one that is 4hrs long recently that is from 4 yrs ago, just like me.

[@SonuDeVilliers-pl3pl]

Wow thank you for such a nice explanation ❤

[@ShaqarudenGames]

I would have PGAdmin open before starting each section of the video. No need to keep us waiting for ~25s each time.

[@georgenicoloff]

Nice but I don't see JOIN tables. Maybe in another tutorial?

[@ahmadhaidar7088]

is there a part 2 with a final project in it?

[@MohamedAlaa-vx5qn]

What is the programing language use in this Crouse ❤

[@codedusting]

pgAdmin is installed in the first installer itself. No need to do it again.

[@krishnachaithanyaks9693]

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!

[@arijitdn]

Postgres tutorial without updating, inserting or deleting data?

[@ArchitStreams]

The zip file mentioned is not able to restore the database, pgAdmin needs tar file and conversion didn't help!

[@whoisarod]

were you able to extract it properly?

[@dino_xy]

Have you solved it?@@whoisarod

[@mehulbhatt1929]

To restore DB, From Program Files > PostgreSQL > 15 > bin, copy everything from bin folder to pgAdmin4 > runtime Folder. This will solve restore error

[@dirudeen1421]

@@mehulbhatt1929 thanks a lot, it worked perfectly

[@Murugesanmurugesan-mr6ji]

​@@mehulbhatt1929bro I have copied those files, where to paste them please let me know

[@thingsgood9596]

Hello, where is the resources under this video containing the video rental database?

[@thingsgood9596]

sorry *dvd rental files?

[@relaxingbeatz4468]

Hi FCC, there is not subtitle for this video.

[@prafulchaudhari2860]

Thank you so much for this course

[@chiraglalwani901]

सीता राम इतना उपयोगी ज्ञान और संक्षिप्त पाठ्यक्रम देने के लिए धन्यवाद ❤🎉

[@maksimbondarenko1179]

пер андерстенд

[@malikayeshasiddiqa]

how to deal wuth this error : C:/NEW/main.exe: error while loading shared libraries: LIBPQ.dll: cannot open shared object file: No such file or directory

[@segunfunmi]

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]

Hello @segun, do you still need help??

[@E.K.S08]

hello, im facing the same problem. any suggestion?

[@segunfunmi]

Yes, I am still facing the same problem. Any help? @@alarezomoosamuyi8526

[@greg3458]

make sure to unzip then click on the folder then on the file should work

[@_promptcoder]

@@greg3458 If you are using ubuntu try to make it tar file instead zip format. I faced the same issue and fixed it.

[@maelstrom57]

We selected the option to have PgAdmin installed together with Postgre so why do we need to download PgAdmin separately?

[@programmingwithalex.585]

You don’t; you can skip downloading pgadmin

[@ilcastilho]

@@programmingwithalex.585 Thanks bro.

[@FzsHotDogInDonut]

Doesn't pg admin gets installed with postgres?

[@soma7891]

Yes

[@CodewithDeepika]

Awesome 👌

[@ankitg6454]

where's the link to the dvdrental file?

[@batuhanbatuhan6445]

0:50 Whether I'm a Syrian database professional?

[@kaushalshah2930]

How to connect oracle database with postgresql to insert oracle database all tables to postgresql

[@alext2664]

As there is no link in the description for the exercise file needed to follow this tutorial, it's usefulness is extremely limited.

[@pujasingha181]

did not understand the second question's solution of group by challenge. Can anyone please help?

[@samkale5988]

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]

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]

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]

​@@samkale5988good evening, I am also getting the same error messages, please how can I resolve the issues

[@truongkham3845]

where is the "Downloading Supplemental Resources" link?

[@golfy4223]

wait where did you get the tar file? I mustve missed something..

[@yamalaha9233]

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

[@victorcamargo7298]

This is amazing!

[@MerinaMotu]

can you please upload the ppt slides as well?

[@AwaAnderson]

please the restore doesn't seem to work keep giving a failed response, i am using windows Please any one who can help

[@seeker511]

Extract the zip file after that you will get a tar file, try using that!

[@seeker511]

Extract the file and try!

[@tahirahmedt9156]

Is the COUNT section repeated or is it different?

[@ChristopherChaduka]

Seems to be the same

[@AkumetsuOne]

Thank you for the class, if someone know a blog about good practices about administration share pls.

[@EmreYavuzalp]

Why you disabled auto subtitles for a video like this?

[@natnaelabayneh7664]

im already on the 2 hour mark...thanks for this beautiful tutorial

[@kyrgzten7005]

The square brackets do not work when I try to use it.

[@ΝίκοςΠιστικούδης]

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]

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).

[@ΝίκοςΠιστικούδης]

Thank you@@pulse3522

[@jenashingi]

Might you have a solution for the zip file failing to restore on a windows machine?

[@AwaAnderson]

Please have you had any success with this i ma currently stock here

[@bidhubhushangahan9242]

Please provide caption for this video.

[@haritssyah7434]

Where can we get the dvdrental database?

[@ogundipebamidele7445]

How did you get to set master password I am using pgadmin 8

[@syhusada1130]

what's the difference between this and the previous freecodecamp postgre video?

[@shadyawad5383]

This one comes in a incomprehensible thick accent

[@torrvic1156]

@@shadyawad5383or it have the distinct original style.

[@svkggl2778]

Not a Postgres Course, but a 95% SQL Language course using Postgresql Database. KZbin is full of such SQL courses, that tend to teach you the SQL In the name of RDBMS.

[@shahrukhhasib5047]

The F are you talking about? SQL is the language that RDBMS understands. They are part of the same coin.

[@svkggl2778]

@@shahrukhhasib5047All the F you are writing here, go and try to learn the difference between and RDBMS and a Language. Do you think the Postgres RDBMS only runs on SQL????? You think DML, DDL are the only things that are carried out on a RDBMS? And if they are part of the same coin, then why not name it "MySQL Tutorial" or "Cubrid Tutorial" for Beginners?? With the kind of information you have, if it were me I would keep the F shut.

[@brainmasterias298]

can't understand the language,

[@DilliwalaRanghad]

It is SQL brother learn it on KZbin it is one of the very easy languages for database ❤

[@thecodemon]

Best time to become a developer

[@svkggl2778]

Correct Title: "Learn SQL using Postgresql Database". Pls correct me if I am wrong?

[@kabukijoe99]

Thank You

[@nguyenanh-vt4jv]

how can I turn on the subtitle, can anyont help me pls

[@chunchenglee174]

There are two duplicate sections in counts topic

[@ahmadhaidar7088]

is the count part repeated??

[@IdungBasah]

hey guys just want to ask that the count content is show twice, thank you.

[@rbar6501]

Dear sir, my request to you all that please launch a free course on 3d animation. Please sir. ❤

[@purplepixeleater]

thats not code lol

[@mantravora6119]

can someone tell me the timestamp of JOINS?

[@samarbid13]

I expcted to have some words on Backup, restore, and regulare maintenance operations!

[@esshadigitalskillsconsult]

How can I download the zip file, please?

[@whoisarod]

unable to convert .zip file to .tar a on macOS. Currently stuck. HELP!

[@mindevo3677]

Dont need to convert. Just unzip the file, the tar is in it.

[@ClaireEB328]

I am stuck here too. Using a macOS, the file is unzipped, do not see .tar. Were you able to figure it out?

[@ClaireEB328]

Update: I deleted every thing after dvdrental/ on the file path and it worked for me!

[@whoisarod]

@@ClaireEB328great! I will try that!

[@Jakan-sf3xj]

This helped. Thank you@@mindevo3677

[@Laptop-s8b]

where is the rest of this video?

[@serj5128]

Please add auto subtitles (it's just a checkbox in KZbin, 1 sec of your time) for this video and all other videos on the channel.

[@kennethlola3588]

Thanks! ❤

[@kabukijoe99]

please switch on subtitles

[@astralvolt6309]

The start of the video ruined the installation. My pgadmin is not starting even

[@esrx7a]

Wonderful

[@BrantK147]

Welcome 🤖to the exciting 🤖 world 🤖 of relational databases. 🤖

[@ianwataka3328]

Why are we not using the pgadmin that comes with postgres

[@maaniurf4870]

Can't find .tar file to restore data. Pls help someone.

[@bracket9731]

and what language he spoke ?

[@GameVerse215]

Could you please use sequelize orm with postgresql

[@illegalsmirf]

no

[@codewithnadeem]

what are the prerequisites before learn PostgreSQL, i have decent understand of MERN

[@Solomon_TY]

guys the link to the file is in the comments. go through

[@thingsgood9596]

Please, if anyone has the database file, kindly share.Thank you.

[@rishabhsoni6190]

Man I just searched for it like 15 mins ago.

[@kuldeepsinhrajput2673]

COUNT IS REPEATED?????????

[@Tokinjester]

nice!!