05-01-relational-algebra-1.mp4

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

КОМЕНТАРІ • 267

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

    So this is the power of Stanford professors. Impressive.

  • @shuyanli7366
    @shuyanli7366 8 років тому +604

    Have to say this is great...20 mins = 3 trash lectures given by my professor....

    • @stuartp2006
      @stuartp2006 7 років тому +13

      Yeah, this lecturer is a lot better than my lecturers.

    • @ailujxu2194
      @ailujxu2194 7 років тому +4

      hhhhhhhh I am also taking CSC343

    • @darvr4042
      @darvr4042 6 років тому +1

      lol accurate

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

      Astaghfirullah, don't be mean brother 😅

    • @ayushuprety5676
      @ayushuprety5676 4 роки тому +2

      Yes, they have a way of making simple things complicated

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

    I came down to the comment section to talk about how much this video helped me but then saw everyone else already did that... So instead let's talk about how schools need a major reform because CLEARLY, something isn't working if literally, every comment I read (and I read all of them before I got to the bottom of the page and YT had to load more) was about how shitty their professor was, and how amazing this lady is (which for the record I COMPLETELY agree with)

  • @Hossthenapper
    @Hossthenapper 2 роки тому +24

    Thank you Professor for explaining in 18 minutes what my prof failed to do in 2 months

  • @jrparkerwatches7860
    @jrparkerwatches7860 4 роки тому +58

    Still saving lives 7 years on! Thank you so much!

  • @unklarnamenpflicht
    @unklarnamenpflicht 3 роки тому +98

    I learned more in the first 5 minutes of this video than I did in the whole semester of my DB lecture, thanks 🤩

    • @송예은-h7b
      @송예은-h7b 2 роки тому

      ㄴSeriously. Agreed

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

      I think if you paid attention in the class you would understand anyway

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

      @@jay_wright_thats_right sure if these videos give us degree

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

      @@jay_wright_thats_right how on earth do you get that conclusion from my comment

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

      @Jeremy Wright ok, you assumed a stranger is in debt for college, assumed someone not learning anything just because someone taught better than college prof, if someone is ignorant in this conv, it is you.

  • @benedictwaiharo1469
    @benedictwaiharo1469 3 роки тому +7

    8 years later and this is still really solid content. Thank you for this.

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

    Your video was way better than two whole semesters in college.

  • @myztazynizta
    @myztazynizta 10 років тому +7

    "like"... nooo, not "like". LOVE. This course saved my ass and my job a few years ago. THANK YOU SO MUCH!

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

    edx's sql course didn't include the relational algebra videos even when the professor stressed how important they are. Thanks for uploading these.

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

      are you sure? It's January 2021 and *edx.org* has Stanford's "Databases: Modeling and Theory" course, active. It includes Relational Algebra.

  • @cgme7076
    @cgme7076 4 роки тому +41

    It's weird when you hear a professor that actually seems to enjoy talking about the topic they specialize in.
    It's almost like they care enough about it to have a decent understanding. This lets them explain the concept extremely clearly.
    Hmmm.. I wish all of our teachers taught like this! Thank you!

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

      Most professors ive had to date have been fairly passionate about the subject they are teaching. They are sometimes not the best teacher but that doesn't discredit their passion. My experience I guess but my professors have been great but I'm at a smaller university.

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

    9 years later, still the best explanation on youtube by far. Thank you

  • @zsmurphy
    @zsmurphy 6 років тому +14

    I have a midterm exam in Database I tomorrow, and I learned SQL before learning Relational Algebra. This video really helped me get a grasp on Relational Algebra and I'm feeling pretty confident now!

    • @markwiedeman7271
      @markwiedeman7271 3 роки тому +5

      I know this is two years old, but im in the same exact situation lol

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

      @@markwiedeman7271 Lol this took me back.. My Database I professor was terrible. I'm a Database Administrator now... we don't use Relational Algebra... shocker am I right 😂 (I mean, it teaches logic pretty well; AND, OR, XOR, etc.)

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

    I understood the entire Relational Algebra concept just by watching this video once. It was so straightforward and brief. Thank you so much! This video really helped me alot.

  • @BlacktopNightmares
    @BlacktopNightmares 6 років тому +196

    Your two videos on relational algebra taught me better than 3 two-hour classes combined. Why am I paying for college?

    • @networkphreak5604
      @networkphreak5604 6 років тому +39

      Because you need that piece of paper. (cry)

    • @NattyWerewolf
      @NattyWerewolf 6 років тому +1

      Network Phreak not in CS , IT field

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

      umm she teaches at stanford I think? So basically get into a good college lol

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

      @@networkphreak5604 True

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

      Idk cuz it’s obviously not helping, seeing that you missed that this is a college class.

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

    I was searching to learn the same thing, but unable to find a proper video, at last this saved my time even after 8 years.
    Why such Universities are respected?
    Salute.

  • @SaintMando98
    @SaintMando98 4 роки тому +11

    wow in just 18 mins I was able to understand something I thought was gonna end me. Relational algebra sounds scary but after this, I'm good!

  • @tatevabrahamyan7067
    @tatevabrahamyan7067 3 роки тому +5

    Thank you. Now I have a better understanding what Relational Algebra is.

  • @mikedevries9930
    @mikedevries9930 7 років тому

    Twenty five years working in databases, but never had to learn relational algebra. My lecturer was "substandard". Thanks, this was a great video.

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

    amazing how you can teach this so quickly. Now, I can't tell if it is a simple concept or if you are just a really good teacher. It's probably because you are a good professor. Thank You Very Much!

  • @pauliewalnuts6734
    @pauliewalnuts6734 7 років тому +50

    AMAZING so much better than my rubbish lecturer

  • @EiffelCurls
    @EiffelCurls 9 років тому +39

    This was so helpful! Thank you for taking your time and explaining this in simple terms! You are saving my life in grad school right now! 🙌🏾👏🏾

  • @F1R3STORM17
    @F1R3STORM17 11 років тому +1

    I love how you teach, this makes it so much simpler and easier to understand the way you explain it.

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

    You honestly explained relational algebra better than my professor (all due respect to him). Thanks for saving me for my upcoming final.

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

      Tbf it's weird to explain without very clear visuals, which is hard to do when some people sit so far away

  • @m1hdi333
    @m1hdi333 5 місяців тому

    This is pure gold. Wow!
    Now I Understand how professors can make big difference.

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

    Fantastic!! I've learnt more from your lesson than at University in a whole period. Your explanation was so clear! Thanks so much!

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

    I wish there were videos like this for every subject and every category because this way learning would be much better. We always need many clear examples apart from simple theory for edge-cases and so many more.

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

    This was awesome. Thanks for the simple resource, I missed a day of class and this saved me

  • @sergeifomin9901
    @sergeifomin9901 3 роки тому +6

    "This is in fact the normal set cross product that you might have learned way back in the elementary school".
    Oh I must have skipped that day to prepare for an exam on the multiples of 3...
    Great video btw!

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

      lmao exactly, do elementary schools in Cali teach set theory? 😂
      I suppose that explains some things though...

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

    Thanks so much. I spent a month and a half in the class and have no idea what is going on, got it from your 20-minute video. Thanks again!

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

    Good pace and finally a video with a good english speaker!

  • @satyajeetjha1681
    @satyajeetjha1681 7 років тому

    And this is the real beauty. I watched a lot of videos on youtube but couldn't get the real intuition but this one really helped.

  • @natarajboina7525
    @natarajboina7525 6 років тому

    Honestly, this is the most informative session on relational algebra.

  • @zairoxs
    @zairoxs 6 років тому

    I put the video at 2x the speed and still learned everything she said. It does not get clearer than that!! Wow thnx a ton!

  • @ntbohl
    @ntbohl 6 років тому +2

    This was an amazingly informative and helpful video until 15:00.. after that it was all over my head.

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

    Amazing video, made this relational algebra stuff SOOOOO much easier to understand and digest than my professor, who just reads off the slides. Great work mam.

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

    I have a Midterm tomorrow and i think i am in the right place, thank you ma'am, you are a life saver.

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

    As expected of the finest institution and their teachers. Understood every single word. Thank you.

  • @MoAnwar
    @MoAnwar 6 років тому

    This absolutely helped me understand the topic after stumbling with the videos made by my university. Very well explained! Thank you for your service to enhancing global knowledge!

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

    Amazing lecture. I wish professors were easier to undestand like this professor.

  • @damonh5551
    @damonh5551 7 років тому

    you explained in 18min what took my teacher 4 classes to do thank you:)

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

    Teaching is an art. and you madam is a master!!. Excellent Video by far

  • @JamesBiser
    @JamesBiser 2 місяці тому +1

    I wish Penn State had these kinds of professors. guess I should've buckled down harder in highschool.

  • @craigiscool6557
    @craigiscool6557 7 років тому

    Thank you so much for explaining this subject. We just went over it in class for 1.5 hours and you nicely and simply explained it in less than 20 minutes!! Everything you said just made perfect sense :-)

  • @AegixDrakan
    @AegixDrakan 9 років тому +6

    Who the heck would dislike this video? It's really helpful!

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

    TA's tell us you only understand 30% of what u hear in a lecture at my university, definetly not the case with this lecture we're just geting ripped off lmao. 10/10 lecture right here

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

    You've saved my life! Thank you so much ma'am for this relation algebra class. So clear and simple!
    It almost looks like an easy topic after this

  • @prayagrajgandhi4431
    @prayagrajgandhi4431 10 років тому +15

    Thank you for your efforts, extremely helpful!

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

    Found 6 hrs before the exam. So helpful!!!

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

    Great explanations and examples, thank you for posting this. I have to agree with everyone else saying that this is not taught well enough in our classes.

  • @o.k.8531
    @o.k.8531 3 роки тому

    Can't get simplier than this. Perfect explanation.

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

    Great video. Relational algebra was way too difficult to grasp, I wish I had this video at the beginning of the semester because this is so much more simple.

  • @smkgeek716
    @smkgeek716 6 років тому

    very expressive and learnt a lot.......
    thanks a lot from PAKISTAN,ISLAMABAD....

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

    very grateful for the resources this channel provides!

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

    so good at teaching. my midterm is tomorrow. this saves me a bit of marks.

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

    wow wow wow! this is 2 hours of my Yesterday’s lecture! soo clearly articulated!!

  • @edgarpanduro5205
    @edgarpanduro5205 9 років тому

    Thank you very much for this great tutorial. I’ve read a database book on relational algebra and the text example's were unclear. This video made it easy and fun to learn.

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

    this video is amazing. trash lecturers didnt put emphasis on this topic but still test so thoroughly in previous years

  • @anboo5117
    @anboo5117 3 місяці тому

    This is them 11 years ago, Imagine how far they've come now; My current professor doesn't even have the energy to do these explanations on a laptop and instead writes on a whiteboard. Mind boggling to say the least.

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

    You are explaining so fluently and well. Thank you so much.

  • @jeremycornish-ford2435
    @jeremycornish-ford2435 2 роки тому +1

    Thank you for some of the theory behind databases. I'm currently learning the basics of A.I.. Just wanted to peek under the hood for a brief moment.

  • @송예은-h7b
    @송예은-h7b 2 роки тому

    Such a clear and straightforward explanation. Best one ever about DB=)

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

    Idk why I can understand this video because my English are so bad, thank you so much!

  • @davidyang5131
    @davidyang5131 4 роки тому +8

    I wish Standford would let me take their courses for learning while still attending my college.

  • @adipalihovici
    @adipalihovici 7 років тому

    Wonderfully explained. Makes me wish I abandoned reading those trash courses of mine earlier and found this much, much sooner.

  • @warrior100girl
    @warrior100girl 6 років тому

    Thank you so much! I had a hard time to understand my professors script about RA. Found this video and i passed my exam for Data Knowledge Engineering Part 1. :D

  • @InformationTechknowledgy
    @InformationTechknowledgy 8 років тому +3

    very good lecture . everyone take a minute to appreciate the hard work :)

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

    if you know well the topic, you can teach very simple! thank you !

  • @afraaalmoala3133
    @afraaalmoala3133 6 років тому +1

    thnk you very mucch i have an exam tomorrow and i pray for you .

  • @MN-pr7bx
    @MN-pr7bx 7 років тому

    Very clear and direct instruction. Thanks a lot, and it saved my life as well. Good job!

  • @time.dealer
    @time.dealer 6 років тому

    Best video on the topic ever! Bravo!

  • @Rex14550
    @Rex14550 9 місяців тому

    Thank you for this better than professors convoluted PowerPoints.

  • @ConnorBode
    @ConnorBode 11 років тому

    Awesome video! These explanations were at least 74.257% better than the ones given by my professor. THANKYOU! =D

  • @tirathsidhu6530
    @tirathsidhu6530 7 років тому

    Really helpful, you are better than my professor

  • @miguelradhakrishna5802
    @miguelradhakrishna5802 7 років тому

    Very good explanation, especially for the natural join!!!.

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

    Thank you so much. You’re so good at explaining these things

  • @billelguechi5831
    @billelguechi5831 8 років тому

    this is the future teaching method very effective .

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

    This video was extremely useful for me. Thank you so much!!

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

    Much Better than my Chinese professor, Thanks a lotttttt

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

    Thank you for sharing your knowledge. This makes way more sense now!

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

    Best video on RA.

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

    Hi I have a question on page of 16:58: since the theta join is a natural join with condition, shouldn't it be equal to "Sigma_theta (exp1 bowtie exp2)" instead of othe cross product? Thanks!

  • @aydnmesuttorun8397
    @aydnmesuttorun8397 6 років тому

    dear madame, thank you for the clear explanations and tone. This benefit me greatly ! :)

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

    Thank you so much, this is life changing for me.

  • @farhanrahman8327
    @farhanrahman8327 8 років тому +2

    Wonderfully explained. Thank you so much for the help!

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

    Very helpful and useful lecture. Thank you!

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

    excellent, couldnt have been done any better.

  • @briansabbeth
    @briansabbeth 11 років тому

    Couldn't be more clear. Thank you for sharing this.

  • @DanteEhome
    @DanteEhome 6 років тому

    So helpful. Hopefully explain the difference between cross-product and natural join more if possible. still a really really good tutorial.

  • @Eviscerate86
    @Eviscerate86 6 років тому +18

    My university really should give money to UA-cam. They even encourage us to study using "external source" (youtube, google mostly) while shitty lecturers and inexperienced tutors are teaching the shitty contents which are never used in current industry. and I am talking about Ranked 1 university in my country. I actually tested. I never went to any lecture and i only saw lecture outline and topics and studied only through youtube+google+SO and I got A.
    and they charge few K$ per paper. Exactly why geniuses drop out universities or never go to uni at all. Im not a genius so i need a degree + lot of internships on my CV to start out from graduate position. So much for a piece of graduation paper. Shitty university.

  • @hejloldetermig3850
    @hejloldetermig3850 7 років тому

    Why can't all teachers be this good?

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

    You are so clear, thank you so much for posting this

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

    Year 2022, January 30-- that's when i got saved.. Thanks much

  • @gruppenzwangimweb20
    @gruppenzwangimweb20 8 років тому +2

    brilliant! will help me to understand the sql server optimizer much better.

  • @slim_mike
    @slim_mike 7 років тому

    this was very very helpful, thanks a lot! greetings from venezuela!

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

    THANKS! this was really helpful and easy to understand.

  • @shanawan67
    @shanawan67 6 років тому

    Wonderful explanation. You explained each and everything precisely and in a great manner. At first, when I played the video and listened to her voice I thought Google Translator is left on but later I realized that it was her voice... just joking. Nice accent actually.

  • @panosgian2737
    @panosgian2737 7 років тому

    Thanks for the great explanation. My dump professor must see this video...58 pages of nonsense descriptions without any example.

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

    When you watch an 18 minute video and it summarizes 3 lectures

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

    I have a Final tomorrow and i think i am in the right place......