Getting Started with PostgreSQL for Windows | 2021

PostgreSQL is a modern relation database that has been in active development for more than 30 years. It's Open Source and great to use for own projects or real applications.
Free PostgreSQL Course
- amigoscode.com/courses/postgr...
In this video you will learn how to:
- Install PostgreSQL on Windows
- Use PSQL
- Use PGAdmin
- CRUD operations
PS:
Subscribe to my channel: / amigoscode
Follow on Instagram: / amigoscode
Happy coding 👊🏾

Пікірлер: 235

  • @dylangodfrey902
    @dylangodfrey9023 жыл бұрын

    Ive scurried all over the internet and this guy is the most clear and straight to the point as can be. Great video lad and your accent was a bonus!!

  • @nicholasho7956
    @nicholasho79565 жыл бұрын

    The permission error at 16:56 you get is because you are using the '\' slashes instead of '/' Just change them around and then the file gets imported with no problems. Thanks so much for this video - it rocks :0)

  • @amigoscode

    @amigoscode

    5 жыл бұрын

    Thanks buddy. I haven't used Windows for almost 10 years now

  • @waheedafolabi6264

    @waheedafolabi6264

    4 жыл бұрын

    Worked. Thanks for the insight, @Nicholas and great video @Amigoscode

  • @atanupaul5327

    @atanupaul5327

    4 жыл бұрын

    the '/' is not working \i C:/Users/Atanu Paul/Desktop/test1.sql; this is the command still shows permission dennied why???

  • @extremepillows

    @extremepillows

    4 жыл бұрын

    @@atanupaul5327 it works for me tho

  • @shobhitsharan2027

    @shobhitsharan2027

    4 жыл бұрын

    thanks, Man, I was stuck on this for long

  • @Name-qt6jv
    @Name-qt6jv4 жыл бұрын

    I was looking for a new and relevant tutorial and finally have found it! Thank you so much!

  • @amigoscode

    @amigoscode

    4 жыл бұрын

    You welcome again

  • @Renee11123
    @Renee111232 жыл бұрын

    I just started learning postgres and I'm overjoyed about this. I was intimidated by using the shell and couldn't import files for the first time and nearly given up. Your video helped me enjoy learning how to use postgres even more. Keep it up!

  • @andreas-fefe

    @andreas-fefe

    2 жыл бұрын

    Definitely Nelson you are the best, Thanks for all. Keep up

  • @timjohnston6072
    @timjohnston60725 жыл бұрын

    Awesome video. Straightforward, easy to follow, and complete. Really appreciate it.

  • @amigoscode

    @amigoscode

    5 жыл бұрын

    Glad you liked it

  • @SosetaFurioasaJr
    @SosetaFurioasaJr2 жыл бұрын

    Thanks Nelson. I actually came from your Spring Boot Tutorial because I installed PostgreSQL but during installation I did not specify a password because I did not know exactly it's use and did not want to get bogged down with another password. After I installed the software, I could not access the server in any way shape or form because it would not recognize any password I inputted and I could not reset it. So what I did I uninstalled PostgreSQL and reinstalled it using this tutorial. Now it works and I can continue your Spring Boot tutorial. Thanks!

  • @RattyScorpion
    @RattyScorpion9 ай бұрын

    Thank you so much for this. My professor threw us into an assignment with no knowledge of how to set up PostgreSQL and no prior experience using SQLs. I had to learn it all from this video.

  • @asterixcode
    @asterixcode3 жыл бұрын

    16:37 when you get Permission denied, to make it works you just need to pass the entire path wrapped by a single quotation + double backslash \\ So the command would be: \i 'C:\\Users\\lucas\\Desktop\\sql.sql' (of course change the username \\lucas here to your own username or path)

  • @cabdicaziizqaasimmaxamed7225

    @cabdicaziizqaasimmaxamed7225

    2 жыл бұрын

    Thank you sir it worked;)

  • @vude123

    @vude123

    2 жыл бұрын

    many thanks sir

  • @uchejames409

    @uchejames409

    Жыл бұрын

    Thank you so much. It worked for me.

  • @rudra2036

    @rudra2036

    6 ай бұрын

    thank u thank u

  • @fxgraphicslive
    @fxgraphicslive Жыл бұрын

    without a doubt the best, most complete tutorial for anything I have seen on yt. Thank you very much!

  • @antonyrichard369
    @antonyrichard3692 жыл бұрын

    I am new to PGres and this beginner tutorial of yours is very helpful !! Thanks a bunch 🙏

  • @billyinthelowland
    @billyinthelowland4 жыл бұрын

    Direct, concise and to the point. Thanks for a great introduction. Subscribed and will check out your other courses.

  • @amigoscode

    @amigoscode

    4 жыл бұрын

    Glad it was helpful!

  • @dimplesantoshi8561
    @dimplesantoshi85612 жыл бұрын

    Wow! such an amazing way of explaining...everything was so clear...step by step..thank you so much!

  • @changofaceanimations5402
    @changofaceanimations54023 жыл бұрын

    Thank you Amigo, you have fantasticly succinct and easy to understand tutorials! I liked and subscribed (with notifications).

  • @ganeshk2156
    @ganeshk21563 жыл бұрын

    You have no idea how useful this video was you hurt me alot man thank you so much. Hats off to ur explanation. ❤️ From India

  • @jeevantha123
    @jeevantha1233 жыл бұрын

    Great content and easy to follow. Fantastic video mate!

  • @amedeekreuzer9190
    @amedeekreuzer9190 Жыл бұрын

    Thank you very much dear Nelson, everything worked with the terminal and also with pgAdmin4. Many many thanks!

  • @SerenityNow_4K_3Dsound
    @SerenityNow_4K_3Dsound4 жыл бұрын

    You are the BEST! Thank you for making it so simple and getting right to the point!!

  • @amigoscode

    @amigoscode

    4 жыл бұрын

    You welcome

  • @user-kn6vr7el8y
    @user-kn6vr7el8y4 жыл бұрын

    Great video! Today the PostgreSQL is so simple to install, that's awesome!

  • @amigoscode

    @amigoscode

    4 жыл бұрын

    Thanks buddy

  • @victoria19162
    @victoria191622 жыл бұрын

    Thank you so much! Brilliant explanation of the topic - it helped massively!

  • @EpoKeins
    @EpoKeins2 жыл бұрын

    Thank you! I only needed the first few minutes. But I've just used the remeining video as a great introduction to the basics of PostgreSQL✌

  • @andrewm6407
    @andrewm64075 жыл бұрын

    This video was really helpful! Thanks for uploading

  • @amigoscode

    @amigoscode

    5 жыл бұрын

    You welcome buddy

  • @mugofmm7476
    @mugofmm74763 жыл бұрын

    Amazing - very clear and down to the point. Keep it up ;-)

  • @julianb.8749
    @julianb.87493 жыл бұрын

    thank you man! i was very stress with this until now. x)

  • @mussiekebede2575
    @mussiekebede25752 жыл бұрын

    Nelson, you are the best. Keep the good work. This video helped me understand command line syntax.

  • @farawayfara
    @farawayfara3 жыл бұрын

    This was extremely helpful. Thank you!!

  • @techture
    @techture4 жыл бұрын

    Excellent tutorial! Thank you so much :)

  • @ddon375
    @ddon3752 жыл бұрын

    Thanks Amigoscode this video solved the problem i have been having for over an hour

  • @erdooungwa7660
    @erdooungwa76604 жыл бұрын

    Great video. I finally now understand postgresql through this tutorial.

  • @amigoscode

    @amigoscode

    4 жыл бұрын

    Awesome. I am glad it benefited you

  • @Tejas-zx7ie
    @Tejas-zx7ie4 жыл бұрын

    Dude, love your way of explaining things. Make more videos! ♥ from India.

  • @amigoscode

    @amigoscode

    4 жыл бұрын

    Thanks I will

  • @bertinopetchiho8407
    @bertinopetchiho84072 жыл бұрын

    Thank you for this amazing introduction video. Very good start for beginners.

  • @shohruhsafarov1645
    @shohruhsafarov16453 жыл бұрын

    Thank you brother, Alloh rozi bolsin!

  • @daiyrkanybekov8575
    @daiyrkanybekov85752 жыл бұрын

    Great tutorial! I Really appreciate this kind of content, keep it going BRO!

  • @konstantinshmarin2676
    @konstantinshmarin26765 жыл бұрын

    And one! I have not seen course about last Maneger PostgreSQL. I think - you really good teacher =)

  • @amigoscode

    @amigoscode

    5 жыл бұрын

    Thanks buddy

  • @tily5939
    @tily5939 Жыл бұрын

    Great video! Still works from 3 years ago. Looks like PostgreSQL isn't too different my MySQL, at least on the basic level.

  • @alpstinger5083
    @alpstinger50833 жыл бұрын

    Thanks mate! This was really helpful.

  • @de1t0
    @de1t03 ай бұрын

    Dude, you teach awesome and you're awesome!

  • @DigitalEmma1
    @DigitalEmma14 жыл бұрын

    Insightful and very helpful , especially now that i'm new to database

  • @amigoscode

    @amigoscode

    4 жыл бұрын

    Thanks Seun

  • @x7331x
    @x7331x2 жыл бұрын

    Great introductory video, thank you so much !

  • @jonlbs7
    @jonlbs73 жыл бұрын

    AWESOME Tutorial.. Thank you !!

  • @godwinokache5803
    @godwinokache5803 Жыл бұрын

    Thanks for this educative video, looking out for more of this. Once again, thank you very much.

  • @svyatoslavsemochko6397
    @svyatoslavsemochko63974 жыл бұрын

    Pretty easy to understand tutorial thanks:)

  • @zlucyz1
    @zlucyz12 жыл бұрын

    This was so helpful, thank you!

  • @milroyshumba7728
    @milroyshumba77283 жыл бұрын

    amazing work , really helped a lot

  • @buka.a
    @buka.a3 жыл бұрын

    I love this course so much

  • @carlosrangel4500
    @carlosrangel45003 жыл бұрын

    Awesome dude, thanks for this :)

  • @barbara2268
    @barbara2268Ай бұрын

    Thank you, that was really useful!

  • @roshansapkota4738
    @roshansapkota47384 жыл бұрын

    thanks you so so much..helped me get out of the problem at the moment

  • @kav5906
    @kav59063 жыл бұрын

    Hands down the easiest video to follow, I should have looked here first rather than reading docs and blogs. Side note - setting up most things on windows is becoming complex or maybe it's just that I haven't done that in awhile.

  • @chrisrodgers6813
    @chrisrodgers68134 жыл бұрын

    Super helpful and easy to follow. Thank you!

  • @amigoscode

    @amigoscode

    4 жыл бұрын

    you welcome

  • @positivepower2879
    @positivepower28792 жыл бұрын

    Excellent content. Thank you!

  • @jaylee5252
    @jaylee5252 Жыл бұрын

    This was super helpful, thank you 🙂

  • @mrpikachuyt7973
    @mrpikachuyt79733 жыл бұрын

    Great video, thank you for the help :)

  • @bigmonster1277
    @bigmonster12773 жыл бұрын

    Big help thank you so much!!!

  • @jaymo2024
    @jaymo2024 Жыл бұрын

    I finally figured out after struggling with permission error 16:56. 1. Go to file location 2. Right click on the file > choose properties 3. Security 4.Choose your user name > Edit 5. Choose your user name again 6. Under permission for users > Make sure it has full control > Apply > Ok 7. After allowing full control go to postgresql shell \i 'C:\\Users\\computernamegoeshere\\Desktop\\filename.sql'; Best of luck and make sure to use one single quote surrounding the file location plus double back slashes!!!!!!!

  • @deepaksangroha
    @deepaksangroha4 жыл бұрын

    Amazing work, Nelson !! Is there any video of you doing High Availability setup of PostgreSQL on Windows Server ? If not, any good source ? :) thank you.

  • @amigoscode

    @amigoscode

    4 жыл бұрын

    google is your best bet. whats how I do everything

  • @AlexRussian92
    @AlexRussian923 жыл бұрын

    Awesome video, thank you so much

  • @emmanuelogunmoroti3348
    @emmanuelogunmoroti33482 жыл бұрын

    Thank you, this video is a life saver

  • @Omar_Muhammad
    @Omar_Muhammad2 жыл бұрын

    Thanks, that video helps me a lot.

  • @amletomonacelli22
    @amletomonacelli22 Жыл бұрын

    New subscriber bro, amazing video.

  • @piotrboczar7967
    @piotrboczar79674 жыл бұрын

    that was useful, thank you.

  • @moviofootgame8726
    @moviofootgame87262 жыл бұрын

    Thank You Man!!!

  • @apocalypseb7x
    @apocalypseb7x3 жыл бұрын

    Thanks! Amigos!!!

  • @elidvenega3017
    @elidvenega30172 жыл бұрын

    Thanks men for this lesson.

  • @sachinmaharjan6398
    @sachinmaharjan63985 жыл бұрын

    nice video and it helped me a lot, thank you sir.

  • @amigoscode

    @amigoscode

    5 жыл бұрын

    I am glad you enjoyed.

  • @techture
    @techture4 жыл бұрын

    Hello my friend! Do you have any videos about connecting DBeaver to PostgreSQL? Thanks so much!

  • @tongyu-ph4mo
    @tongyu-ph4mo Жыл бұрын

    Thank you so much!😋

  • @he132
    @he132 Жыл бұрын

    thanks, this was helpful

  • @cyberguide_in
    @cyberguide_in3 жыл бұрын

    Quite helpful. thanks a lot

  • @chio3112
    @chio31123 жыл бұрын

    Great video!

  • @adilkhanabdrashov7507
    @adilkhanabdrashov75072 жыл бұрын

    jazakallahu hayran Akhi!!!!!

  • @Mahesh-gq7fm
    @Mahesh-gq7fm3 жыл бұрын

    The tutorial is very good and useful

  • @vitia2010a
    @vitia2010a2 жыл бұрын

    Thanks for the information

  • @TehPobo
    @TehPobo3 жыл бұрын

    looks good bruvva

  • @ex-wife83
    @ex-wife832 жыл бұрын

    THANK YOU!!!

  • @sudomakes
    @sudomakes2 жыл бұрын

    thanks man!

  • @Romain35BoB
    @Romain35BoB2 жыл бұрын

    Merci mon pote !

  • @wesamhamed1663
    @wesamhamed16634 жыл бұрын

    that's great.thanks so much

  • @amigoscode

    @amigoscode

    4 жыл бұрын

    You are welcome Wesam

  • @alickcampbell8915
    @alickcampbell89152 жыл бұрын

    Very good tutorial!

  • @danielswearson1360
    @danielswearson13603 жыл бұрын

    This is really good

  • @lucacaputo2465
    @lucacaputo24652 жыл бұрын

    Thank you!

  • @william_shokhan
    @william_shokhan2 ай бұрын

    Really thanks guy

  • @ravenhooper9263
    @ravenhooper9263 Жыл бұрын

    Loved the video. Do you have any video on connecting psql to an application. I got stuck on connecting it to my app

  • @oguzkarademir1441
    @oguzkarademir14413 жыл бұрын

    Thank you so much :)

  • @prphawke
    @prphawke4 жыл бұрын

    thank you, very helpful

  • @amigoscode

    @amigoscode

    4 жыл бұрын

    You welcome

  • @IZE85
    @IZE852 жыл бұрын

    Thanks, mate! ;)

  • @kevinidoma545
    @kevinidoma5452 жыл бұрын

    Thanks bro!

  • @athmanmtingwa8896
    @athmanmtingwa88964 жыл бұрын

    Thanks. You are really good.

  • @amigoscode

    @amigoscode

    4 жыл бұрын

    Thanks buddy

  • @loam
    @loam4 жыл бұрын

    Some people say "you know" a lot. Some go with "uhm", this one uses "pretty much" xD Btw, video was pretty much useful.

  • @amigoscode

    @amigoscode

    4 жыл бұрын

    lol thanks

  • @manu-singh
    @manu-singh3 жыл бұрын

    I'm impressed that he uses insert key, personally i hate it !! But yeah, command prompt is one it is useful i agree.

  • @dreamchaser8365
    @dreamchaser8365 Жыл бұрын

    Good work my brother

  • @yogialexiusn4130
    @yogialexiusn41302 жыл бұрын

    thank you amigos

  • @MrGamislife
    @MrGamislife3 жыл бұрын

    thank you so muchhhh

  • @paulfleischer-djoleto4429
    @paulfleischer-djoleto44294 жыл бұрын

    A good tutorial.

  • @Rachel_codes
    @Rachel_codes Жыл бұрын

    very helpful video for beginners

  • @JackJones-uj9fh
    @JackJones-uj9fh3 жыл бұрын

    you are awesome good job

  • @victormandela1810
    @victormandela18105 жыл бұрын

    Thanks big time.

  • @amigoscode

    @amigoscode

    4 жыл бұрын

    you welcome

  • @shiblyaziz4528
    @shiblyaziz45282 жыл бұрын

    Thank you so much

  • @jonathanndawula8584
    @jonathanndawula85842 жыл бұрын

    Good Job Bro 👍

  • @mattiasnkonjo940
    @mattiasnkonjo9403 жыл бұрын

    Thanks Man

  • @nguyenvanloc3744
    @nguyenvanloc37442 жыл бұрын

    thank you so much