Tables & Keys | SQL | Tutorial 2

[@yashienwamangamassa5094]

I really love your Tutorials, they are very clear to understand. Thanks Dane

[@ItsMePhoebe]

You're a great teacher, thanks for this video, it was very helpful!

[@amaanrampath4100]

Jumping from Employee table to Branch table -> PARKOUR PARKOUR PARKOUR

[@duduetc]

great video Mike! loved the The Office reference

[@frankjb9977]

Lols to the office reference. Also I'm taking my ITF+ on Thursday & this just saved me. Thanks my dude.

[@Logan-tp8ib]

I love how Andy still sold the least even in this tutorial 😂

[@sylviama9016]

awesome! very clearly and give a lot of examples to help understand. thank you

[@louisdiamond417]

Thankyou for takeing your time out to help.

[@AngryBeardGaming]

I love The Office (UK and US) :)

[@jacobblack2544]

Loved the example too

[@samueljnrsithole2552]

Your tutorials are very clear to understand

[@sovanu234]

excellent till today among all the videos i browsed !!!Thanks and appreciate...god bless

[@SkyFly19853]

Your Channel is one of the best!

[@shoaib4828]

using the Office as example. Ah, I see, you are a man of culture as well

[@harbisetyonugroho2312]

thanks mike, this is exactly what I've been searching for

[@emmanuelblay-morkeh7785]

great job i really appreciate the way you tech it makes it very easy to understand. thank you

[@sovanu234]

too good...Mike...you are excellent, Can you please put some links for query exercises?

[@AbhishekDubey.19]

Love the office

[@yugioh-furkan-4508]

Incredibly useful tutorials thank you

[@imad_uddin]

Thanks Mike! This was very helpful

[@SimpleHumanInNY]

Hi Mike, thank you for the tutorial. I have a question on "super_id" attribute (column), as well as "mgr_id" column. Is it necessary that those 2 attributes be a foreign key? Will the schema be impacted if they weren't foreign keys?

[@persiansayed]

The data will definitely be impacted, and there would be no corresponding relation. We would be able to put any number in the "super_id" and "mgr_id" column, which will cause data ambiguity.

[@tonnysocrates9741]

Good content

[@pandeyishita]

The Office fans hit like!

[@Siddharth-uo6zw]

Thank u so much! can you make more advanced paid courses in SQL, Back end Developer with economical for students. you teach so well.

[@IDontReadReplies42069]

Why would you want to pay lol literally anything you could want to learn there's hundreds of videos and thousands of articles free online

[@MoonOvIce]

@@IDontReadReplies42069 Useful certs maybe.

[@sonamuhialdeen7866]

Amazing tutorial

[@kildasinguillermo5235]

Thanks Mike.

[@Visafriend]

Awesome!

[@ivanovski.stojan]

Long live "The Office" :D

[@rishabhmehta7152]

Thanks a lot Brother. Your way of explaining is awesome. I have a small Question if any one can answer it will be helpful: 9:28 what about Josh Porter? his Branch ID is also 3 do Andy Bernard and Josh Porter both of them belongs to same branch Stamford .

[@dhineshkumar2044]

see the employee id is different. it's a primary key it's uniquely identifies the josh porter is the manager

[@anibng]

18:27 Foreign keys? Do you mean both of those columns are primary keys of other tables combining to form a primary key for that table? Because those primary keys link to other tables, are you referring to them also as foreign keys in this context?

[@tylery9540]

great video

[@febrianjuan7087]

love you bro

[@蹦太君-o4d]

thank your tutorials !

[@zynxajeaesthetics6067]

You are my hero

[@thantlinthein5812]

My Information professor from college should be replaced with you.

[@lamismessaadi3893]

thank you for this tutorial

[@kennykistler6735]

5:05: What happened to Gould?! Did Gould die?!

[@dccc1960]

Mike Dane, you are a GOD! Best instructional videos on the internet by far. Not once did you put me to sleep.

[@ahmadullahrajib2244]

he is super awesome but not GOD

[@ondrejmarek9752]

Thank you

[@FatmaYousuf]

Love love love your tutorials. Thanks for this playlist

[@abuukarcusmaansuufi3249]

Very Very Thanke MD

[@30_kashishkashyap4]

Can we say that the composite key is a super key?

[@toshi4479]

I see an office Fan

[@webb-developer]

✅

[@mahou3853]

how we diffrentiate between composite and foreign

[@moecharger27]

Thank you tutorial

[@thealchemist9781]

Coloums:vertikal ~single attribute Rows:horizontal entry~individual student Primarey key~row Surrogate key Natural key Foreign key

[@anishjoshi1999]

love from nepal

[@mohammedjoubba318]

thank u so much

[@rp2804]

damn~!

[@kennykistler6735]

Andy Bernard's super_id should be 102.

[@vanitas6620]

Why?

[@alenjose3903]

@@vanitas6620 why not?

[@nikobitan7294]

The branch supplier example was very confusing to me because it relies on a pretty strong limitation that one branch can buy solely ONE thing from a given supplier, and there really is no logical reason for that. A more intuitive example would connect the supplier and their supplies, so Paper inc. would only ever produces paper, Forms and Labels will only produce custom forms for the company etc. Alternatively, make the initial example clearer: there is no need for a branch that only produces wooden toys to buy anything except wood from Hammer Mill, and on the other hand, there's no need for a publishing branch to buy anything except paper from Hammer Mill. In that case it makes intuitive sense why we would connect a branch and a supplier in a way that doesn't allow any additional purchases.

[@gabehcuodsuoitneterp203]

We can also tell the big boss by their salary.

[@dexspits7869]

primary key surrogate key (primary key) natural key (primary key) foreign key composite key

[@AbhishekDubey.19]

He doesn't like jim

[@kunj5327]

people who have watched the office can define relations without any knowledge of SQL or database.