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

Поделиться
HTML-код
  • Опубликовано: 25 авг 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 лет назад +687

    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 2 года назад +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!!!

  • @xeroks646
    @xeroks646 5 лет назад +131

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

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

  • @Gra8t-Back
    @Gra8t-Back 2 года назад +9

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

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

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

  • @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 3 года назад +1

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

    • @EntropyOnTheCrosshair
      @EntropyOnTheCrosshair 3 года назад +3

      Im really hoping everyone knows this woooosh.

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

  • @frikkiebruwer5779
    @frikkiebruwer5779 4 года назад +14

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

  • @quantummotion
    @quantummotion 4 года назад +9

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

  • @Beny123
    @Beny123 5 лет назад +28

    Who else is addicted to listening to Ulka?

  • @davidkuda7074
    @davidkuda7074 3 года назад +20

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

  • @MmmBopsPops
    @MmmBopsPops 5 лет назад +1

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

  • @kalyan98765
    @kalyan98765 5 лет назад +71

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

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

  • @pretty_ok
    @pretty_ok 5 лет назад +5

    This is what all tech explanation videos should be like.

  • @mastermind8437
    @mastermind8437 Год назад +1

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

  • @Socratica
    @Socratica  4 года назад +1

    Do you love Socratica Programming videos? We have a Kickstarter to make 20 Advanced Python Lessons. Support what you love! bit.ly/PythonKickstarter

  • @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..." 👍😉

  • @thisisajoke0
    @thisisajoke0 5 лет назад +12

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

  • @vidanatural_oficial
    @vidanatural_oficial 5 лет назад +18

    thank you Socratica producers, you are awesome.

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

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

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

  • @NotAshamedOfficial
    @NotAshamedOfficial 3 года назад +2

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

  • @quahntasy
    @quahntasy 5 лет назад +10

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

  • @GolfhausYT
    @GolfhausYT 5 лет назад +7

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

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

  • @psycodepath6180
    @psycodepath6180 3 года назад +1

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

  • @aceofspades02
    @aceofspades02 4 года назад +1

    I love her sense of humor!
    Thanks for the class

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

  • @vaidasmasys3764
    @vaidasmasys3764 3 года назад

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

  • @jangyman
    @jangyman 5 лет назад +27

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

    • @DoTuskO
      @DoTuskO 5 лет назад +4

      I was thinking the same thing lol

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

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

  • @coler7975
    @coler7975 2 года назад

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

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

  • @moibe182
    @moibe182 2 года назад

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

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

  • @JonathanSueck
    @JonathanSueck 3 года назад

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

  • @DeepakSharma_youtube
    @DeepakSharma_youtube 5 лет назад +2

    Technical videos should be like this one, loved it!

  • @oppositeistrue
    @oppositeistrue 4 года назад

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

  • @yannickpahl6558
    @yannickpahl6558 2 года назад

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

  • @sarundayo
    @sarundayo 5 лет назад +3

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

  • @dougiehawes916
    @dougiehawes916 3 года назад

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

  • @Jabranalibabry
    @Jabranalibabry 5 лет назад +1

    Every video is top notch!

  • @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 :-)

  • @i.i
    @i.i Год назад

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

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

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

  • @Eric-it4we
    @Eric-it4we 2 года назад

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

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

  • @rolamcclary
    @rolamcclary 3 года назад +1

    'Let's take a moment and stare at the name' hahaha!

  • @arpandutta7678
    @arpandutta7678 3 года назад

    Most not-boring installation video ever!

  • @brettona123
    @brettona123 2 года назад

    Love your humor. Well done. Thank you!

  • @cxxxk3084
    @cxxxk3084 3 года назад

    so thankful for this lol my professor was just like "use postgres"

  • @siyanbolafaruk3005
    @siyanbolafaruk3005 2 года назад

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

  • @athulak
    @athulak 5 лет назад +1

    I don't need mindfulness classes anymore... I have this!

  • @andriipolishko1477
    @andriipolishko1477 Год назад

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

  • @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!! 💜🦉

  • @senpaiyaa
    @senpaiyaa 3 года назад

    Love it when GLaDOS teaches me about databases

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

  • @jamesspawned1096
    @jamesspawned1096 2 года назад

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

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

  • @L1terally_Me
    @L1terally_Me 5 лет назад +1

    This is the most charismatic woman alive !

  • @kaym7549
    @kaym7549 Год назад

    I've never laughed so much while watching an installation video of a database manager

  • @BECEG_Bodhit
    @BECEG_Bodhit 2 года назад

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

  • @aliza_h
    @aliza_h 3 года назад

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

  • @capitansantiagopinto4122
    @capitansantiagopinto4122 3 года назад

    Not only I learned, I laughed too!
    great video

  • @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. :)

  • @BigAL-x7f
    @BigAL-x7f 4 года назад +1

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

  • @johnmcdermott7740
    @johnmcdermott7740 2 года назад

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

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

  • @carlodurian3730
    @carlodurian3730 5 лет назад +4

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

  • @Hangup2008
    @Hangup2008 3 года назад

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

  • @omegasintetic6987
    @omegasintetic6987 5 лет назад +1

    Here we go again... this is gonna be awesome!

  • @sanesanyo
    @sanesanyo 5 лет назад +2

    Dry humour here is next level. Cheers :)

  • @scfdtutorials-ro2ru
    @scfdtutorials-ro2ru Год назад

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

  • @michaelrosenbaum6210
    @michaelrosenbaum6210 5 лет назад +3

    Loved it! “ manual heavy”

  • @tsarprince
    @tsarprince Год назад

    better than most short movies out there

  • @rohitkumar-ub3km
    @rohitkumar-ub3km 3 года назад

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

  • @arpit8273
    @arpit8273 3 года назад

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

  • @emmanuelmasemola1014
    @emmanuelmasemola1014 2 года назад

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

  • @dannyae3523
    @dannyae3523 5 лет назад

    there is laughter beyond the cold void of the db

  • @ezbozovago
    @ezbozovago Год назад

    Refreshingly light of touch. Thank you.

  • @la6mp
    @la6mp 5 лет назад +1

    Great, I enjoy both the knowledge and the humor!

  • @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!! 💜🦉

  • @markestrada1703
    @markestrada1703 Год назад

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

  • @softanacademy
    @softanacademy 5 лет назад +1

    Super Great. Hurry on the next one.

  • @johnsmith-ro2tw
    @johnsmith-ro2tw 2 года назад

    I wonder if she speaks this way like a robot in real life. I honestly thought it was a bot all along until we saw her face on the screen. Unless big tech can make such very sophisticated bots now. Amazing !

  • @DaintreeJD
    @DaintreeJD 2 года назад

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

  • @Puneetsharmain
    @Puneetsharmain Год назад

    Enjoyed sense of humour...watched twice to hear tech humour 😊

  • @PierreAndNick
    @PierreAndNick 5 лет назад +1

    This is my new favourite channel

  • @fuanka1724
    @fuanka1724 5 лет назад +1

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