PostgreSQL Tutorial for Beginners

Рет қаралды 214,956

9 ай бұрын

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-masterclass-learn-kotlin-from-zero-to-advanced/?couponCode=FREECODECAMP4AADC8F8
⭐️ 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

Пікірлер: 233

@programmingwithalex.585 9 ай бұрын

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 9 ай бұрын

where's the link to the dvdrental file?

@programmingwithalex.585 9 ай бұрын

@@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?

@Bale-ek7eu 4 ай бұрын

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!!

@Aishwarya_st 9 ай бұрын

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

@jakesimmens 9 ай бұрын

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!

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

@programmingwithalex.585 9 ай бұрын

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!

@seroma3516 9 ай бұрын

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

@SeanPizzaSpark 9 ай бұрын

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

@synen 9 ай бұрын

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

@hyunduk0206 8 ай бұрын

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 20 күн бұрын

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

@danielfarmer7372 20 күн бұрын

Life saver! Thank you

@dattadigambar4038 9 ай бұрын

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

@teknoh 9 ай бұрын

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 😂😂

@allengeorge15 4 ай бұрын

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

@vijayarajan-bt5fk 5 ай бұрын

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

@tejasukalkar2199 9 ай бұрын

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

@torrvic1156 7 ай бұрын

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.

@user-wd9lx2yr7e 8 ай бұрын

watched completely, thank you

@flibben 7 ай бұрын

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

@prafulchaudhari2860 9 ай бұрын

Thank you so much for this course

@AkumetsuOne 9 ай бұрын

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

@ianwataka3328 5 ай бұрын

Why are we not using the pgadmin that comes with postgres

@victorcamargo7298 9 ай бұрын

This is amazing!

@codewithnadeem 6 ай бұрын

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

@kaushalshah2930 9 ай бұрын

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

@serj5128 2 ай бұрын

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

@alejo5007 7 ай бұрын

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

@funnyvideo8677 5 ай бұрын

Yes

@ankitg6454 9 ай бұрын

where's the link to the dvdrental file?

@dochinaschannel2776 7 ай бұрын

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 5 ай бұрын

Sam here.

@stroopwafelvla1804 3 ай бұрын

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

@CodingChannel1 9 ай бұрын

Awesome 👌

@kuys.undefined 28 күн бұрын

I already installed mysql and sql in my laptop, does it conflict or compromise with my installation with prostgressSql?

@brainmasterias298 3 ай бұрын

can't understand the language,

@relaxingbeatz4468 6 ай бұрын

Hi FCC, there is not subtitle for this video.

@SonuDeVilliers-pl3pl 21 күн бұрын

Wow thank you for such a nice explanation ❤

@maelstrom57 9 ай бұрын

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

@programmingwithalex.585 9 ай бұрын

You don’t; you can skip downloading pgadmin

@haritssyah7434 4 ай бұрын

Where can we get the dvdrental database?

@ogundipebamidele7445 6 ай бұрын

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

@nothinwritten 8 ай бұрын

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

@kyrgzten7005 4 ай бұрын

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

@theodorebenjaminvonberkens2216 6 ай бұрын

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

@kabukijoe99 9 ай бұрын

please switch on subtitles

@nguyenanh-vt4jv 3 ай бұрын

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

@kabukijoe99 9 ай бұрын

Thank You

@Architg_streams 9 ай бұрын

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

@whoisarod 9 ай бұрын

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

@gabrielgrabois 8 ай бұрын

the count section is repeated, but great video

@krishnachaithanyaks9693 3 ай бұрын

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!

@thingsgood9596 5 ай бұрын

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

@thingsgood9596 5 ай бұрын

sorry *dvd rental files?

@hamster_24_7 24 күн бұрын

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

@maaniurf4870 8 ай бұрын

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

@jirayuvijjakajohn295 9 ай бұрын

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.

@HamzaSattar-rq9td 3 ай бұрын

How to Get Rd rental file ? tell me if anyone know this

@samkale5988 7 ай бұрын

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

@user-hq3uh7sn2k 7 ай бұрын

where is the rest of this video?

@anabildebnath2590 Ай бұрын

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

@user-kz5xw2sq9v 8 ай бұрын

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

@georgenicoloff 5 ай бұрын

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

@segunfunmi 9 ай бұрын

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.

@ahmadhaidar7088 17 күн бұрын

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

@bidhubhushangahan9242 4 ай бұрын

Please provide caption for this video.

@thingsgood9596 5 ай бұрын

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

@natnaelabayneh7664 9 ай бұрын

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

@StockGarjanaHindi 7 ай бұрын

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 5 ай бұрын

@@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

@esrx7a 9 ай бұрын

Wonderful

@golfy4223 6 ай бұрын

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

@yamalaha9233 14 күн бұрын

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

@aymanelaouad1028 4 ай бұрын

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

@thecodemon 9 ай бұрын

Best time to become a developer

@thegoingwolf9674 3 ай бұрын

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

@LuckyFishM 3 ай бұрын

Thank you so much for the help....

@esshadigitalskillsconsult 5 ай бұрын

How can I download the zip file, please?

@jenashingi 5 ай бұрын

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

@AwaAnderson 5 ай бұрын

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

@IdungBasah 2 ай бұрын

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

@GameVerse215 9 ай бұрын

Could you please use sequelize orm with postgresql

@illegalsmirf 9 ай бұрын

@user-ts5lc1oc5v Ай бұрын

can you please upload the ppt slides as well?

@tahirahmedt9156 9 ай бұрын

Is the COUNT section repeated or is it different?

@ChristopherChaduka 8 ай бұрын

Seems to be the same

@arijitdn 8 күн бұрын

Postgres tutorial without updating, inserting or deleting data?

@FzsHotDogInDonut 6 ай бұрын

Doesn't pg admin gets installed with postgres?

@soma7891 6 ай бұрын

Yes

@abhinavsimhadri2747 9 ай бұрын

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

@jimo9555 9 ай бұрын

nice!!

@AwaAnderson 5 ай бұрын

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!

@kennethlola3588 9 ай бұрын

Thanks! ❤

@alext2664 Ай бұрын

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

@mantravora6119 7 күн бұрын

can someone tell me the timestamp of JOINS?

@rishabhsoni6190 9 ай бұрын

Man I just searched for it like 15 mins ago.

@syhusada1130 9 ай бұрын

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.

@EmreYavuzalp Ай бұрын

Why you disabled auto subtitles for a video like this?

@whoisarod 9 ай бұрын

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

@ahmadhaidar7088 17 күн бұрын

is the count part repeated??

@rbar6501 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

@chiraglalwani901 9 ай бұрын

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

@maksimbondarenko1179 9 ай бұрын

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

@samarbid13 9 ай бұрын

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

@Solomon_TY 4 ай бұрын

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

@bracket9731 25 күн бұрын

and what language he spoke ?

@kuldeepsinhrajput2673 6 ай бұрын

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

@pablomatos1707 9 ай бұрын

Tô top top

@avrakadavra1552 Ай бұрын

Any solution in 2:17:27 ?

@avrakadavra1552 Ай бұрын

I'm trying to display the other rows of aggregated function result

@TahaTawell 9 ай бұрын

The first❤

@YanqinQualmann 3 ай бұрын

for someone with error "Restoring backup on the server PostgreSQL 16" Process failed at 16:18 , check this video : kzfaq.info/get/bejne/odGnaZCrvdHWYH0.html