Enterprise Computing Predictions/Thoughts (1 Viewer)

[no_idea (clueless)]

prob gonna need to brush up on it its 100% on our exam

how do you use the join in sql, like how is it different from where

 

[no_idea (clueless)]

prob gonna need to brush up on it its 100% on our exam

https://enterprise.paper.is/?exam=independent, question 19

 

[sillilouyje]

I don't believe we need to know joins. Using WHERE to join relational databases does the same thing and it is in the course specs whereas join is not. I asked my software teacher at school and he agreed with me too.

Like if you have one table you can join them with WHERE Pets.OwnerID = Owners.OwnerID

 

[no_idea (clueless)]

that's what i did, but i ran the sample ans it show diff result

 

[no_idea (clueless)]

idk i remember my teacher teaching it, i just don't undertstand it

 

[sillilouyje]

I don't think we need to know it because using WHERE the ID's are equal do the same thing. Its one of the many strange things in the syllabus.

idk i remember my teacher teaching it, i just don't undertstand it

 

[no_idea (clueless)]

I don't think we need to know it because using WHERE the ID's are equal do the same thing. Its one of the many strange things in the syllabus.

k, thanks anyway

 

[alphxreturns]

how do you use the join in sql, like how is it different from where

JOIN ON essentially physically picks up the smaller table and plops it into the big one, making the ID's the same, thus making it easier to call for conditions across previously different tables

 

[no_idea (clueless)]

JOIN ON essentially physically picks up the smaller table and plops it into the big one, making the ID's the same, thus making it easier to call for conditions across previously different tables

thx

 

[alphxreturns]

we're cooked

 

[sillilouyje]

we're cooked

I just found this. Its REALLY PRETTY good

https://www.brainscape.com/flashcards/week-3-18279491/packs/22697577

 

[alphxreturns]

also consider tomorrow going thru the syllabus with traffic lights to make sure u know everything

 

[no_idea (clueless)]

also consider tomorrow going thru the syllabus with traffic lights to make sure u know everything

I have red everywhere

 

[no_idea (clueless)]

we're cooked

Check studocu, heaps of notes there

 

[en1411]

these are my notes, they're sorted by the syllabus and are concise as possible - hopefully can help in some way if you guys need it. data science starts from pg21 everything else before is the IRPT

 

[sillilouyje]

these are my notes, they're sorted by the syllabus and are concise as possible - hopefully can help in some way if you guys need it. data science starts from pg21 everything else before is the IRPT

Thank you , this is actually really good.

 

[no_idea (clueless)]

these are my notes, they're sorted by the syllabus and are concise as possible - hopefully can help in some way if you guys need it. data science starts from pg21 everything else before is the IRPT

Damn, how are we gonna through this rn

 

[sillilouyje]

Damn, how are we gonna through this rn

I been reading it for at least 3 hours from this morning to last night lmao

 

[sillilouyje]

guys, that was actually so easy
what did everyone put on the Memes question? That was a bit strange.

 

[no_idea (clueless)]

guys, that was actually so easy
what did everyone put on the Memes question? That was a bit strange.

I was trying not to laugh at that question