05-01-relational-algebra-1.mp4

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

КОМЕНТАРІ • 262

  • @ashtrdvhjhedd
    @ashtrdvhjhedd 4 роки тому +244

    So this is the power of Stanford professors. Impressive.

  • @shuyanli7366
    @shuyanli7366 7 років тому +582

    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 6 років тому +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 4 роки тому +85

    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)

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

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

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

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

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

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

    • @user-dc7oj3el7o
      @user-dc7oj3el7o 2 роки тому

      ㄴSeriously. Agreed

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

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

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

      @@jay_wright_thats_right sure if these videos give us degree

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

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

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

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

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

    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.

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

    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.

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

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

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

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

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

      Because you need that piece of paper. (cry)

    • @NattyWerewolf
      @NattyWerewolf 5 років тому +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 Рік тому +1

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

  • @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 3 роки тому +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.

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

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

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

  • @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! 🙌🏾👏🏾

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

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

    AMAZING so much better than my rubbish lecturer

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

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

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

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

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

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

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

  • @m1hdi333
    @m1hdi333 2 місяці тому

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

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

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

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

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

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

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

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

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

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

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

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

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

    Thank you for your efforts, extremely helpful!

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

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

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

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

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

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

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

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

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

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

    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!

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

    Can't get simplier than this. Perfect explanation.

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

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

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

    very grateful for the resources this channel provides!

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

  • @anboo5117
    @anboo5117 12 днів тому

    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.

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

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

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

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

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

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

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

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

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

    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.

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

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

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

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

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

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

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

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

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

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

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

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

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

  • @user-dc7oj3el7o
    @user-dc7oj3el7o 2 роки тому

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

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

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

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

  • @gina8719
    @gina8719 11 місяців тому

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

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

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

    Best video on the topic ever! Bravo!

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

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

    Best video on RA.

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

    excellent, couldnt have been done any better.

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

    Thank you for this better than professors convoluted PowerPoints.

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

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

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

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

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

    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

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

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

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

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

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

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

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

    this is the future teaching method very effective .

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

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

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

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

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

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

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

    Wonderfully explained. Thank you so much for the help!

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

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

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

    Much Better than my Chinese professor, Thanks a lotttttt

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

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

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

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

    GOAT🐐

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

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

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

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

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

    This was a really good! Thank you.

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

    THANKS! this was really helpful and easy to understand.

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

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

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

    Really helpful, you are better than my professor

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

    Thank you for the great work

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

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

  • @ejavier19
    @ejavier19 8 років тому +1

    Thank you for making this video! so helpful!

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

    For cartesian product of final natural join example: Names and GPAs of students with HS > 1000 who applied to CS at college with enr > 20000 and were rejected:
    Π sName, GPA (σ student.sid = apply.sid AND college.cname = apply.cname AND enr > 20,000 AND major = 'cs' AND dec='rej' AND hs > 1,000 ( student X ( college X apply ))

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

    excellent! amazing! ive learned everything, thank you so much!

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

    Thank you, your video is very helpful!

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

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

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

    Very helpful and useful lecture. Thank you!

  • @muhammaddanial1267
    @muhammaddanial1267 8 років тому +7

    Thankyou so much mam