MySQL SQL Statements Tutorial 5

preview_player
Показать описание
Here I explain what SQL is & show many statements in sql. I'll teach you everything on Atomic Data, Normalized Data, Primary Keys and Foreign Keys
Рекомендации по теме
Комментарии
Автор

I honestly liked the music in the background. Different strokes, different folks. Great videos!

x_Liquid_x
Автор

Sorry about that. I made a newer / better tutorial on sql if you're interested check out my youtube channel

derekbanas
Автор

Until I read the comments, I did not even notice the music. I was so focused on what Derek was saying.

ZenrichSocial
Автор

Hey Derek! Thank you for all the videos you make! You.Are.Awesome! You have helped me learn SO many things about various languages that I was unable to learn elsewhere. You explain things VERY well and VERY simply. Simple is good in my opinion.

I have a question on this video.

Under the "Rules of Normalized Tables" you have the point "You also want to eliminate using the same values repeatedly in your columns. Ex. You wouldn't want a column named instructors, in which you hand typed in their names each time. You instead, should create an instructor table and link to it's key."

My question is: when referring to typing in the instructor names each time, do you mean having to retype the same instructors name, repeatedly? E.g. Column = Instructor, Row 1 = "Joe Schmo", Row 2 = "Jane Doe", Row 3 = "Joe Schmo", Row 4 = "Jane Doe", Row 5 = "Joe Schmo", Row 6 = "Jack Sparrow", etc. In this case, one would be better off creating an instructor table that contained each instructor once. Is that the point of that rule?

Thanks for your help! :)

Quaerite.Intellectum
Автор

Yes, I cant watch tutorial with music too

andreybraslavskiy