My SQL DB Design and Dev professor does not want us to use cartesian products and will give us 0s on assignments if we use them. (He instead wants us to select on one table and join everything to it). Dave doesn't seem to be as against them in this video. Why is that? Aren't they bad practice?
@@superfreiheit1 lol I'm trying to figure it myself. I think different situations require different approaches is what I've realised.. knowing about Cartesian joins helped me a lot solving some SQL problems
well explained. i liked how you mention that all joins begin with a cartesian product of the tables, then are reduced based on other commands.
dataquerying classes have forced me to watch this video over and over again and it's a wonderful explanation, thanks man
Well, that was refreshing. I actually understood the concept correctly now. Thank you
Thank you for clearing out my concept Dr. Dave!
Best explanation out there, thank you sir!
Really clear explanation. thanks mate.
Awesome explaination. Thanks man
Wonderfully explained
this is a crystal clear clarification that i had sought for years, thanks a!
great explanation, really helped!
Good work.
hahahaha majors in "the occult" XD nice
thank you!
W guy
Thanks Alot bro!! really helped me!
UCLL represents
My SQL DB Design and Dev professor does not want us to use cartesian products and will give us 0s on assignments if we use them. (He instead wants us to select on one table and join everything to it). Dave doesn't seem to be as against them in this video. Why is that? Aren't they bad practice?
Why using Cartesian join and not just inner join?
Did you understand why?
@@yuvrajmahendru2149 no, why
@@superfreiheit1 lol I'm trying to figure it myself. I think different situations require different approaches is what I've realised.. knowing about Cartesian joins helped me a lot solving some SQL problems
@@yuvrajmahendru2149 I think its the same. inner join works like caresian
@@superfreiheit1 yupppp, works the same
I'm more of a Count Chocula man myself... student id 6666666 lol.
occult 666? da fck?