05-02-relational-algebra-2.mp4

[@nguyentu3321]

10 years later and I can't still find a better RA explanation than this

[@ImanMatar]

You have just summed up a total of about 5 lectures which I slept through in these 2 parts videos. Thank you

[@michaelpeng5597]

+Iman Matar well said

[@xsoteria6458]

Agreed

[@nitinneo7]

One person's clarity in a topic and the ability to transfer that knowledge can add to saving so many hours! Thank you for being so cogent.

[@TheDruida72]

who else has a databases exam tomorrow?

[@fauge7]

It might be 3 months later, but I do!

[@danieldelrey3133]

Today xD

[@af_125]

6 days

[@mgligorov98]

it's today iiin about 3 hours :)

[@keshara97]

TheDruida72 today

[@jokejong9414]

I spent close to 2-months trying to understand this topic from my studies. I spent 30mins with your video and I feel like I have gained relational algebra enlightenment. :) Thank you for doing up this video and teaching it so clearly!

[@Mike-gt9re]

You make me wonder how my professor is employed. Thank you for keeping this public.

[@srinivasmaheedhar4118]

Combination of Video 1 and 2, is awesome, I recommend anyone who wants learn relational algebra ...go through these

[@JediMaddy94]

7 almost 8 years later, came upon these vids and...amazing stuff.

[@JohnKilombelevisualfxartist]

thank u very much madame for an impressive tutorial, am now able to seat for my final db course exam at my college a million thanks once again may God bless u more more more and more......

[@filipemarquesg]

What a goddess. Learned more in 35 minutes than in a whole month at college. Amazing teacher.

[@pascalsolutions6158]

Thank you professor for breaking this complex topic down. Obviously i have learnt within 40 minutes what i struggled to understand in weeks

[@abdulllah4855]

I want to appreciate how great this 2 videos were and how the professor explained the topic

[@norcal6181]

I was soo lost on this subject before watching these two videos. This cleared it right up. Thank You!

[@miketurner3461]

In R, when you merge data frames, it employs the relational algebra paradigms mentioned in this video!

[@marwanbassam9932]

I have found a gem in a time of online learning. Thank you!

[@pyromen321]

Wow. These two videos were unbelievably helpful and easy to understand. In less than 40 minutes, you did a better job of covering what took my professor 5 one-hour lectures to cover. When I fill out my course evaluations, I'm going to link these videos. Hopefully my professor can learn from you on how to convey these concepts so efficiently.

[@zairoxs]

These videos are great! In fact, I knew nothing on the subject, and the first video was so good, I actually caught the error she made at 3:58 before reading her correction shortly after. Great job!

[@jojo23srb]

this woman is a queen!!!

[@laurenpolo2474]

You explained this topic so simply. Thank you for posting these videos!

[@UdayaKumaraBro]

i would like to thank you for this video tutorial series which consists short and sweet explanation in efficient way.

[@AB-ce9qb]

Thank you so much. I wish I would have watched these videos before mid term

[@thomasjaszczult1118]

"which is a standard set operation you learned about in elementary school" wtf elementary school did you go to? Great video though, thanks a bunch!

[@samuelayine418]

awesome explanation about important topic great work lady

[@electronicdreams.9870]

Thank you for writing the book we use for the course. Very informative

[@kaizhuolim3332]

At 13:41 when she uses n1

[@saqib8470]

i think it compares the starting string that is B from Berkeley and S from Stanford.

[@buscapee]

i think it is alphabetical order

[@Lucky-bg7sd]

Time 4:00 Couldn't you just add a theta join instead of of a natural join with a project operator. Did you not do this because theta joins are rare? I thought you said otherwise when you explained it to us?

[@lucianoinso]

Exceptional teacher, thank you for the videos!

[@SlaveryEvolves]

When she does "pairs of colleges in same sate" with the first method, with the cross product, she selected s1 = s2, but don't you also have the Berkley Stanford and Stanford Berkley issue here as well as you did with the natural join?

[@lucianoinso]

Yup, she missed that i guess because it was not the final query that she was going to show, it also gets repetitions like "stanford stanford" "berkeley berkeley" i think

[@abhinitsati3082]

You could fix that by adding the condition n1 < n2 to the select operator. So the new condition would be s1 = s2 ^ n1 < n2.

[@OttoFazzl]

@@abhinitsati3082 can you please explain how and why n1 < n2 would remove duplicates like Stanford, Berkley and Berkley, Stanford as shown @13:20?

[@harshvardhan556]

Brilliantly explained from india

[@sdegnan03]

the answer for the second difference example is wrong, @4:00, question asked for id & name but answer only gives name.

[@MN-pr7bx]

there's a little subtitle in red to correct the answer, hard to see though lol

[@m.rayfasacandra86]

thanks! these 2 videos help me a lot

[@junaidmughal3806]

No kidding, wasn't expecting it to be this easy

[@dalboz]

The division operator is missing?

[@jamiemarshall8284]

How does the less than work @ 13:25. How are you claiming a name of a school is less than another name of a school?

[@asdfuzdah]

comes first alphabetically

[@VineFynn]

All characters are ranked alphanumerically. Meaning that letters and numbers have a rank relative to each other.

[@idadahl6575]

Do all database teachers just like having university structures as examples?

[@ZoomerAdvice]

I would pay money to have a professor teach me this content this well. Oh wait, I do :/

[@fachatii]

very well explained , thank you

[@keer-3]

Finally, u made me realize that I wasted my money to those trash professors who takes away my 1 hour everyday taking shit.

[@ashvedlochun8240]

great lecture today i`ve found how great lecturers are compared to those at my university :3

[@fzndn-xvii]

Wait, SQL pronounced as "sequel"?

[@DaniDipp]

If you want it to

[@AngadGrewal]

I pronounce it as Sakweeal for fun.

[@missdhara6434]

But what happens if you have more than 2 colleges that you are looking for pairs of ? She just used Berkeley and Stanford and assigned them to C1 and C2 what i there are 300 colleges do we have to list all of them like that ? (C1, C2...C50... C300)?

[@ebukaiwuagwu9371]

The C1 and C2 is a cojoin of the two tables so it is only C1 and C2. the colleges within the table are what she represented with n1 and n2 i think

[@san28676]

Does anyone have the exercises to these lectures ? Thanks

[@ric_silva_a]

what about the enrollment atribute? where does it say that it doesnt make it to the pairs?

[@joe624p]

what if you want to find ids of student(s) that had the highest grade? How do you compare each student's grade?

[@jacobmoore8734]

What's the link to the previous video? I searched through your videos and the naming system was insane.

[@sdagur]

I don't understand the meaning of "don't increase the expressive power of language." What does it mean??

[@devcanas]

Hope I'm not too late! It means you can write the exact same query with other operators.

[@ArshadKhan-ls3oj]

I didn't understand the concept of 'natural join' in the Difference operator. The SID is unique in all cases. It cannot be same. So why do we need a 'natural join' to remove duplicate values?

[@calaphos]

It doesnt allow you to do something you couldnt have done with the opertors introduced before. Its just an easier way to write something however you could have written it before aswell

[@rammahmohamed8265]

amazing video

[@deadvision22]

ı understand thıs sectıon wıth the last example , thanks madam

[@abdallahrizk8787]

good explanation

[@RajashreeGhoshdiya]

this is just great

[@siyangliang5974]

Can somebody teach me how to write "get students who appliy multiple majors in one school"?

[@omgjustno]

Siyang Liang Someone correct me if I'm wrong, but you may have to look at previous lectures to understand. That question you are asking is actually not possible in this Student-Apply-School relation because I remember that the sID from the Apply table is the primary key. This means that a constraint of this whole relationship is that students can only apply once to a school.

[@siyangliang5974]

Ste awoi I think the primary key for Apply is (sID, college, major). A student could apply multiple college. And a student could apply multiple majors for one college. Look at the original apply table.

[@hanabenarab7558]

Thank you,Very helpful

[@yavuzerbas875]

Hair color is changed

[@itachi-senpaii]

thank you so much ... :)

[@srinivasmaheedhar4118]

very nice

[@drvp1997]

Thank you!

[@briannguyen5057]

very helpful

[@2everywhere285]

Thank you !!

[@elestirel3131]

AŞK KADIN........

[@tsunningwah3471]

知哪！

[@tsunningwah3471]

mmm

[@shnapi7]

Who else high af right now? :P

[@tsunningwah3471]

bbb

[@danmoulton7365]

Thank you!