PostgreSQL (Postgres) - Installation & Overview |¦| SQL Tutorial |¦| SQL for Beginners

Поділитися
Вставка
  • Опубліковано 15 вер 2024

КОМЕНТАРІ • 491

  • @Socratica
    @Socratica  4 роки тому +133

    It's official! The Socratica Python Kickstarter was a success! Thank you to all of our supporters. Because of you, many more Python videos coming soon!! 💜🦉

    • @njolee
      @njolee 4 роки тому

      Ulka, this was hilarious! ...I have a serious question though. Is there a way to run postgres scripts in the background- that is, starting a postgre script logging out, and having the postgre script continue running data management processes for hours (or potentially months on end)?
      I know how to do this with Unix/Linux shell scripts and raw data (i.e. without a database), but I was wondering if there was a way to do this inside of postgres (or any SQL database).

    • @opensourcerror
      @opensourcerror 4 роки тому

      py + postgre pls

    • @motunrayobabatunde1963
      @motunrayobabatunde1963 3 роки тому

      Literally found myself giving you a round of applause after watching the video. LOVE the humor!

  • @4DGlasses
    @4DGlasses 5 років тому +688

    I'm not even using postgres, I'm here for the dry humor

  • @RocketLR
    @RocketLR 5 років тому +224

    "engineers get double respect points when typing in commands vs using GUI"
    That is compleeeeeetely accurate and ofc goes for everything, firewalls, switches, etc..

    • @pixelfairy
      @pixelfairy 5 років тому +9

      what you can command line, you can automate, you can scale, you can automate testing, and, with the hair style, you can look cool doing it all

  • @vniga
    @vniga 4 роки тому +170

    This was intense. I've never felt so much suspense while installing something.

    • @edwingarcia5043
      @edwingarcia5043 2 роки тому +2

      The worst part: I had to stop watching the video in order to download and install things, and then be synced with the video :')

    • @niiYehezkel
      @niiYehezkel 2 роки тому +1

      oh yes, after installing then you would find out that there're not chairs in your database

    • @ThierryC2373
      @ThierryC2373 Рік тому

      Then, you never installed Oracle on a Sun Solaris server!! 😆

  • @alexz4334
    @alexz4334 3 роки тому +89

    It has been 2 minutes so far and I can already state that this is by far the best short educational video I have ever watched. So tasteful, clever and with an excellent sense of humour. THANK YOU!!!

  • @Gra8t-Back
    @Gra8t-Back 2 роки тому +9

    A standing ovation for this woman. Breaking down concepts and delivery is top notch.

  • @xeroks646
    @xeroks646 5 років тому +131

    I see an elephant, so we must be at the right place 😂😂😂

  • @briannussbaum2725
    @briannussbaum2725 4 роки тому +32

    This is such a nice unexpected change of pace from the hundred other painfully dry SQL tutorials I have been making my way though! Thank you!

  • @frikkiebruwer5779
    @frikkiebruwer5779 4 роки тому +14

    How have I never heard of this channel?
    Laughing and learning is such a powerful combination, thanks!

  • @alcapone1366
    @alcapone1366 5 років тому +47

    we have no tables, and no chairs either!! lol
    the puns are more like dad jokes, but still I found this channel and her way of teaching amazing!!

  • @mrswats
    @mrswats 5 років тому +277

    The amount of puns in this video is... just right

    • @andersonmyguy5054
      @andersonmyguy5054 4 роки тому

      I'm sorry, this comment had 69 likes, i turned into 70 likes.
      [Internal sadness]

    • @nac9880
      @nac9880 4 роки тому

      you don't wanna know what "puns" means in portuguese...

    • @calebemiquissene
      @calebemiquissene 3 роки тому

      @@nac9880 Existe algum problema com a palavra "trocadilhos"?

  • @quantummotion
    @quantummotion 4 роки тому +10

    "I always include a similar warning in my CV." That comment just made my day! Wonderfully crazy and quirky! Thank you for putting this material out and making it a joy to learn from!

  • @elgrapadura1453
    @elgrapadura1453 5 років тому +46

    Great video, very informative and great humor. I very much enjoy the presenters delivery style. New quote for me.." you should not fear change.. unless the change is scary, then you should be terrified."

  • @mastermind8437
    @mastermind8437 Рік тому +1

    We loved this video. We especially loved the dig about using the gui when nobody's looking.

  • @MmmBopsPops
    @MmmBopsPops 5 років тому +1

    I love this lady. She has such dry humor and presents it as nothing more than that.

  • @thenoorer
    @thenoorer 5 років тому +67

    God i am hooked to the sarcrasm and unexpected comments by the AI on the video, very human like

    • @roronoa_d_law1075
      @roronoa_d_law1075 4 роки тому +1

      @Shovine Bojraj it's just a very good AI ^-^

    • @physicsguybrian
      @physicsguybrian 4 роки тому +4

      AI? Really going there? No, she is Ulka Simone Mohanty and is very real and quite lovely.

    • @lawaladekunleolusegun8409
      @lawaladekunleolusegun8409 4 роки тому +1

      @@physicsguybrian Nice, She's too real and good to be AI :)

    • @EntropyOnTheCrosshair
      @EntropyOnTheCrosshair 3 роки тому +3

      Im really hoping everyone knows this woooosh.

  • @pretty_ok
    @pretty_ok 5 років тому +5

    This is what all tech explanation videos should be like.

  • @rugvedshinde5418
    @rugvedshinde5418 Рік тому +1

    never loved a tutorial more .... it was just WOW .. felt like i was watching a episode from my beloved series or something

  • @Beny123
    @Beny123 5 років тому +28

    Who else is addicted to listening to Ulka?

  • @neilpodoba7090
    @neilpodoba7090 Рік тому +3

    For someone like me who works as a System Admin/Database Administrator for 8-9 hours per day I really didn't think it was possible for me to effectively learn coding without burnout. Your videos have helped me become super interested in code versus watching painstakingly boring courses everyday. I wish all courses were like this it would be beneficial for people who have a hard time sitting down and reading through hours of material and videos. Maybe you can make a Kubernetes/Docker course in the future??

    • @andracomsa
      @andracomsa 7 місяців тому

      Happy for you! Indeed it's difficult to learn new things when you already have a full time job

  • @jeremythen7239
    @jeremythen7239 4 роки тому +1

    The first thing that I do after starting a Socratica video with Ulka in it is to hit the like button because I'm pretty sure I will like it already.

  • @vero0992
    @vero0992 5 років тому +5

    Love this series! I'm learning all the things. No more blank looks from me when I mentioned needing help with a SQL database and they tell me, "It's not SQL, it's postgres..." 👍😉

  • @davidkuda7074
    @davidkuda7074 3 роки тому +20

    _"It is a fascinating manual. There is even an audiobook version available that is only 400 hours long."_ Hahah

  • @thisisajoke0
    @thisisajoke0 5 років тому +12

    I'm here for Ulka and whatever she feels like teaching.

  • @Ennytrippen
    @Ennytrippen Рік тому +1

    You told a story, you took me through a journey. Thank you, Socratica. You just gained a subscriber in me for this special and impactful content. Obrigado!

  • @jego0320
    @jego0320 3 роки тому +8

    This was a well thoughtout and hilarious tutorial, truly made learning fun!
    Laughed a lot while watching this, thanks for making my day!

  • @AndrewSmith99
    @AndrewSmith99 5 років тому +6

    I've been using PostgreSQL at a professional level for twenty years and I can assert that this video was interesting.

    • @saichaitanya154
      @saichaitanya154 3 роки тому

      Sir, I'm a business intelligence developer (Tableau) I use SQL to get data from data source to visualise on Tableau desktop. I wanna learn postgresql, how will it help me in long-run?

    • @sagarjain4128
      @sagarjain4128 2 роки тому

      @@saichaitanya154 have you found the answer to your query? If yes kindly share

  • @null-wp1le
    @null-wp1le 4 роки тому

    I came here just to learn the pronunciation and didn't expect this video to be so helpful with it. Thank you.

  • @NotAshamedOfficial
    @NotAshamedOfficial 3 роки тому +2

    This is absolutely my favorite tutorial I've ever seen every tutorial should be like this!

  • @vidanatural_oficial
    @vidanatural_oficial 5 років тому +18

    thank you Socratica producers, you are awesome.

  • @SunilKumar-yd9bz
    @SunilKumar-yd9bz Рік тому

    I came here when searching a tutorial on PostgreSQL and found your video is valuable, informative and was totally in a different way of style to present. Liked and subscribed. Thank You!!!

  • @moibe182
    @moibe182 2 роки тому

    One minute after looking this video, I subscribed! You are awesome!

  • @kalyan98765
    @kalyan98765 5 років тому +71

    Because engineers get double respect points when typing in command versus using the gui. 😂

  • @monagulapa3022
    @monagulapa3022 4 роки тому +3

    Hi ! :)
    I like your style of teaching. This is your originality. And it helps lessen the boredom of a programming job. Thank you for sharing your knowledge.

  • @vaidasmasys3764
    @vaidasmasys3764 3 роки тому

    I cant believe that this is a tutorial not just a good comedy sketch. Well done!!!

  • @quahntasy
    @quahntasy 5 років тому +10

    The amounts of puns in this video lmao.
    Loved the delivery style.

  • @i.i
    @i.i 2 роки тому

    These videos are very educational and funny at the same time 🌹🌹🌹🌹👍👍

  • @psycodepath6180
    @psycodepath6180 3 роки тому +1

    HAHAHA, this channel made my day, and I promise it will make my entire carrier in coding

  • @JonathanSueck
    @JonathanSueck 3 роки тому

    Where is the super like button?! I so enjoy the added humor and silly references!

  • @keifer7813
    @keifer7813 2 роки тому

    This host is something else lmao best walk throughs ever!

  • @glenacord
    @glenacord 2 роки тому +2

    Absolutely love this! I stumbled upon it while trying to introduce myself to PostgreSQL for a work assignment. I never knew Database Comedy was a "thing"! I'm going to watch all your other database vids too - databases are fun :-)

  • @coler7975
    @coler7975 2 роки тому

    This was the most intense thing I ever did. Thanks.

  • @aceofspades02
    @aceofspades02 4 роки тому +1

    I love her sense of humor!
    Thanks for the class

  • @Eric-it4we
    @Eric-it4we 2 роки тому

    OMG this was the greatest tutorial video I've ever watched in my life.

  • @arcturianninja
    @arcturianninja Рік тому

    That's the fastest I've ever subscribed to a channel. Amazing video :)

    • @Socratica
      @Socratica  Рік тому

      Hooray!! We're so glad you've found us!! 💜🦉

  • @andruramirez8396
    @andruramirez8396 4 роки тому

    this is one of the best videos i have ever seen. i have adhd and this video made my brain forget i cant focus.

  • @arpandutta7678
    @arpandutta7678 3 роки тому

    Most not-boring installation video ever!

  • @glennreviews5171
    @glennreviews5171 4 роки тому

    Fantastic videos. I have never seen such a funny and charismatic IT video. Make such a nice change from mumbling incomprehensible Indian bloke. Don't get me wrong I appreciate them helping me learn. This however is brilliant. Thanks!

  • @yannickpahl6558
    @yannickpahl6558 2 роки тому

    Informative and humorous. Way better than the average "hey guys, in this video we will see how to..." video.

  • @zipazip
    @zipazip 5 років тому +2

    PostgreSQL is something that I'm not interested in. But your tutorials are always so well done. I had to watch it and I loved it :D My favorites are those about Python. Not sure how you do it, but keep doing it!

  • @oppositeistrue
    @oppositeistrue 4 роки тому

    The humor is great, thank you for reminding me I haven't been using mine enough lately. Thank you again.

  • @DeepakSharma_youtube
    @DeepakSharma_youtube 5 років тому +2

    Technical videos should be like this one, loved it!

  • @sarundayo
    @sarundayo 5 років тому +3

    Thanks Socratica! Every day I become smarter (and wittier, lol).

  • @sunilvalavala7071
    @sunilvalavala7071 3 роки тому

    i did not skip ads , just to be thankful - i liked the video - thanks !

    • @Socratica
      @Socratica  3 роки тому

      You're amazing, thank you!! 💜🦉

  • @BECEG_Bodhit
    @BECEG_Bodhit 2 роки тому

    vniga
    I've never felt this much suspense while installing ...lol...love your voice

  • @johnmcdermott7740
    @johnmcdermott7740 2 роки тому

    Thanks for the simple yet detailed explanations. I enjoy your dry witty humor and nerdy speech :D

  • @moibe182
    @moibe182 2 роки тому

    I have never enjoyed a installation video as much as this one! Perfect way to keep us tuned. Before this video I didn't even knew what postgres is, thanks a lot!

  • @manualvarado2212
    @manualvarado2212 5 років тому +1

    8:32 Manuel here.
    Thank you for the video! I thought it was a joke, but it's really useful for my Databases class assignment!

  • @dougiehawes916
    @dougiehawes916 3 роки тому

    glad I have found a postgresql video which feels like a cult initiation, thanks

  • @woolfel
    @woolfel 5 років тому +5

    One difference between mysql and postgres is the underlying storage engine. PostgreSql uses MVCC similar to Oracle. Only a few RDBMS use MVCC design.

  • @brettona123
    @brettona123 2 роки тому

    Love your humor. Well done. Thank you!

  • @BitcoinBabu369
    @BitcoinBabu369 5 років тому +1

    Simple and straightforward to the point this is amazing way of teaching i really impressed. Will definitely support #SupportSocratica.

  • @aliza_h
    @aliza_h 3 роки тому

    I kind of love this tutorial. Informative and sarcastic without being condescending. Cool shit.

  • @siyanbolafaruk3005
    @siyanbolafaruk3005 2 роки тому

    I'm fascinating with this. In fact this is the greatest installation short video I'll ever watch.

  • @Jabranalibabry
    @Jabranalibabry 5 років тому +1

    Every video is top notch!

  • @davidhargrove5181
    @davidhargrove5181 4 роки тому

    You guys are doing such an amazing job with this... decided to go through some videos as a refresher, I could see a lot of different people being engaged here.

  • @GolfhausYT
    @GolfhausYT 5 років тому +7

    6:51 Damn, Michael Harrison. The superuser just dunked on you in front of all of us.

  • @thoufiqmohammed8627
    @thoufiqmohammed8627 4 роки тому

    Fabulous.. your robotic style is just woww.. looking forward to more interesting n useful videos .

  • @la6mp
    @la6mp 5 років тому +1

    Great, I enjoy both the knowledge and the humor!

  • @fifthowl
    @fifthowl 4 роки тому

    I am enjoying her humour and her funny insights like "pretty good" admin and elephant logo since "an elephant never forgets". I think every tutor should have humour like her. :)

  • @kasidogga
    @kasidogga Рік тому

    Learn with Fun! Awesome tutorial to start with PostgreSQL delightfully :)

  • @dickyssanjaya
    @dickyssanjaya 4 роки тому

    This channel is underrated

  • @capitansantiagopinto4122
    @capitansantiagopinto4122 4 роки тому

    Not only I learned, I laughed too!
    great video

  • @rohitkumar-ub3km
    @rohitkumar-ub3km 4 роки тому

    this is the first time i am laughing also while learning any technology or database. Great effort and thanksk for the video.

  • @PierreAndNick
    @PierreAndNick 5 років тому +1

    This is my new favourite channel

  • @garyjohnston2777
    @garyjohnston2777 3 роки тому

    This channel is so funny, educational and entertaining. I have learnt soooo much keep the videos coming.

  • @DaintreeJD
    @DaintreeJD 2 роки тому

    That was the best introduction hahaha, nice work, and thank you.

  • @CaliforniaGrows
    @CaliforniaGrows 4 роки тому

    youre my new favorite for programming videos. It actually kept my attention and i learned a good amount. THANK YOU!

  • @arpit8273
    @arpit8273 3 роки тому

    I don't even comment on videos. But ur video editing and voice is perfect.

  • @ezbozovago
    @ezbozovago Рік тому

    Refreshingly light of touch. Thank you.

  • @jangyman
    @jangyman 5 років тому +26

    Why do I feel like I'm playing Portal while watching this?

    • @DoTuskO
      @DoTuskO 5 років тому +4

      I was thinking the same thing lol

  • @liammckenna1479
    @liammckenna1479 4 роки тому

    4:57 "Click next until you get to a license agreement with a lot of text in all caps. I always include a similar warning on my CV." GENIUS

  • @Hangup2008
    @Hangup2008 3 роки тому

    finally a video that explains something before I start doze off! Thanks for not being boring and the great explanation!

  • @senpaiyaa
    @senpaiyaa 3 роки тому

    Love it when GLaDOS teaches me about databases

  • @PunmasterSTP
    @PunmasterSTP 3 роки тому

    Another unbelievably good technology SQL from Socratica! These are the greSt!

  • @carlodurian3730
    @carlodurian3730 5 років тому +4

    I love you Ulka! You're so funny you always make my day!

  • @stewartkerlin2565
    @stewartkerlin2565 3 роки тому

    best video currently on the internet

  • @fuanka1724
    @fuanka1724 5 років тому +1

    I really like the subtle humour. Keep it up. :)

  • @jamesspawned1096
    @jamesspawned1096 2 роки тому

    Thank you for the much needed comic relief, and awesome info!

  • @andriipolishko1477
    @andriipolishko1477 Рік тому

    ah, gosh, that Portal games' vibe is so cool.
    Video is great by the way, thanks

  • @JohnDoe-nw3sv
    @JohnDoe-nw3sv 2 роки тому

    Great video. Useful, short enough, and some bonus humor is awesome.

  • @brunoavila5
    @brunoavila5 3 роки тому

    Maaan, funniest geek video ever! Congrats!!

  • @aureliusnt
    @aureliusnt 5 років тому +12

    You seem happier than the Python serie.

    • @iamjimgroth
      @iamjimgroth 5 років тому +2

      It's not the same character. ;)

    • @aureliusnt
      @aureliusnt 5 років тому

      @@iamjimgroth that explains a lot. Thanks!

    • @Someone-vb6ed
      @Someone-vb6ed 5 років тому +4

      Someone made a good point that it's the next version/release. The newer version of the robot has more humour/sarcasm, can show some emotions etc.

    • @neociber24
      @neociber24 5 років тому

      @@iamjimgroth Nah, she just update the software

  • @kirbyurner
    @kirbyurner 4 роки тому

    I'm a long time fan of this teacher, Ulka. Her Python course is good too.

  • @BigAL-x7f
    @BigAL-x7f 4 роки тому +1

    the humorous commentary in this video alone got a sub!!! hahaha :D

  • @scfdtutorials-ro2ru
    @scfdtutorials-ro2ru Рік тому

    You made me a subscriber in just few seconds and believe me, that never happens.

  • @emmanuelmasemola1014
    @emmanuelmasemola1014 2 роки тому

    Ohw my gosh I love you, I want to see more on this subject, finally a fun video to watch

  • @L1terally_Me
    @L1terally_Me 5 років тому +1

    This is the most charismatic woman alive !

  • @sumitkumar-gz2pm
    @sumitkumar-gz2pm 5 років тому +1

    Wow great video.. best way to teach programming... thank you...😀😃😄

  • @markestrada1703
    @markestrada1703 Рік тому

    OMG this is hilarious and such a relief from normal "data" videos. LOL 🤓