I'm studying to be a full stack developer and being that I'm self taught the material is tricky. There's no shortage of free educational material in virtually any subject (it just takes dedication to find it). What's hard to find is necessary material delivered in a way that you can not only understand, but understand it easily. You sir accomplish this! Instead of just presenting the information you provide it in an energetic way that allows the student to feel like they naturally understand. Which then allows a student to go from not knowing a subject to being able to replicate it on their own.
I must say these videos are about ten times easier to understand than my overly complicated jargon filled uni lectures. Thanks Eddie, wish I had you as my teacher in high school!
Absolutely. I found Eddie Woo while studying entry level pure math at uni, and I'm back four years later when covering entry databases. The dude is timeless.
For the life of me I have always had a difficult time mastering the concept of what a foreign key and primary keys are. Now I can explain it to others. You have explained it easily, thoroughly and without confusion. Thank you.
2 Things: 1) There is no way to distinguish student A from student B granted they share FirstName, LastName, ClassID and POB -> Solution: Use extra field, StudentID 2) When I first started learning Databases I was confusing the theory with the practice To understand the concept I had to follow a few tutorials of how to create actual databases
That's101. Or 100.5, more. But now a university, where students take many classes, or courses with different, simultaneous subcourses. And professors with more than one subject, or 2 professors, teaching the same course, or separate lessons in a single course, etc, etc. Things get more complicated when an ERD grows. Also, you cannot duplicate records (So you can't have Class ID in the Student table when a Student takes more than one class). That's called normalization. And then, this ERD only applies to transactional systems. For analytical systems, or auditable financial system, you have other schemas alltogether.
Of course: I Google for help, and Eddie Woo shows up. Not only does he show up, I'm HAPPY TO SEE he shows up. I know that after the video, I'll understand things better. Dude is just SO helpful.
The concept was explained well. But another thing that impressed me is how could you use your fingers on board with some application projected on to a screen. Thats amazing..!! Please let me know. Thats very interactive technology you were using in this video.
Topic is on Schema and students can't even answer elementary questions like primary and foreign key? The teacher is awesome but I guess his talents are wasted on this bunch.
Eddie, my daughter is going to take the AP (Advanced Placement) Statistics course this fall, she is in Sarasota, Florida, U.S.A at her junior year, I wonder is this the course series you teach that can help her with the course AP Statistics? S
I easily understood your lesson, it was a nice refresher for me. I'm just here to say that I like your teaching style and I've actually found you first from watching your lessons on mathematical induction so I was surprised when my friend linked me this video (we're working on a project involving databases). Keep up the good work :) I'm sure not enough people do this but I really appreciate you uploading your lessons, some teachers or professors seriously don't explain the topics you upload in such a way that the student can easily understand them.
Man, this was literally the best tutorial I watched whole this year! I really mean it man, You taught Database schema the best way possible. Salute to you bro ✌✌❤
Great Video. I've added the the Structural Data, and Google's markup tool shows the info but, my Business's knowledge graph hasn't updated. How can I have the info updated?
Relational databases have "fields" ??? Class.ClassID is a Primary Key ??? It provides Uniqueness ??? Try inserting ... Class (1, "Mickey Mouse", "5A") Class (2, "Mickey Mouse", "5A") Class (3, "Mickey Mouse", "5A") With "databases" like that, you will have ALL KINDS OF FUN that people who have databases do not have.
We don't have that kind of teaching technology here in the Philippines. Luckily I found your channel. Now I can understand more about our lessons. Thank you Sir. I've watched your video about data flow diagram. Can you make more tutorials please? Our subject is System Analysis and Design and the way of teaching our professor does is not that student friendly. He just read it from his presentation. he don't have actual examples.
I really want to excel in math. That's my weakness. Your videos about math can help me also sir. I hope that the way of teaching here in my country is like the way you teach. Thanks for the immediate reply. God bless.
Could u also show an example of many to many? Is this mapping always done from right to left? Thanks Records produced after joining depend on this mapping? Thanks
One book can be borrowed by only one borrower AT A TIME, unless you want some kind of borrowing history. If you do not want the latter, it's pretty simple : you just add something like "borrower_person_id" to "book" table, and make it a foreign key, referencing a person, that is holding the book at the moment. When that guy returns the book to the library, the value of "borrower_person_id" will change to NULL. When the other guy takes it, "borrower_person_id" will then reference that new guy...
Love your charisma and way of teaching, but there's one thing in particular that I don't like about this class and that's teaching beginners to use upper case characters. Since many, if not most, automated relational database solutions are linked (in-)directly to the host's file system, promoting the use of upper case characters will enevitably result in n+1 headaches for the inexperienced who move their databases from a case insensitive local solution (windows for example) to pretty much any other system that features case sensitivity. I've had to help out countless, countless number of people getting their databases to work on their first unix-based environments simply because of something case-sensitivity related. So for absolute beginners: stick to lower casing to prevent headaches. They can always decide to go for a different naming convection once they're more experienced. Edit: I realize that one might think that's not within the scope of this lecture, but it all starts here, at the absolute beginning
A student to class relationship is many to many and would require a join table. A teacher to class relationship is one to many. His explanation was exactly incorrect.
I am new to programming. This video is awesome,better than my teacher. So , from where should i start learning the database. Like topics. #GreatVideo BTW can't it be like one teaching many classes, one to many relationship ?
Awesome:-) , you make things so easy to understand..You really have a gift to teach:-), can you post some videos on sequence diagram,state diagram and use case diagram pls
Just watching random database design videos and clicked on this without looking at the author. I legit was so excited to see Eddie's face! You explain things like no other
Daym, that`s one energetic and inspiring teacher! Imagine a world filled with these kinds of IT-teachers! :)
We would be living in space by now.
ai will make it so
I'm studying to be a full stack developer and being that I'm self taught the material is tricky. There's no shortage of free educational material in virtually any subject (it just takes dedication to find it). What's hard to find is necessary material delivered in a way that you can not only understand, but understand it easily. You sir accomplish this! Instead of just presenting the information you provide it in an energetic way that allows the student to feel like they naturally understand. Which then allows a student to go from not knowing a subject to being able to replicate it on their own.
your teaching with energy and method is awesome...
wrr, infix enerx nmw
I love the way you express yourself and you seen a lot passionate talking about the subject.
I wish you had a SQL/DB playlist. I find it difficult to find more DB videos
th-cam.com/video/ymb9gsl_x1U/w-d-xo.html&ab_channel=EddieWoo
@@andrewprimary yayy..thank you
I must say these videos are about ten times easier to understand than my overly complicated jargon filled uni lectures. Thanks Eddie, wish I had you as my teacher in high school!
Absolutely. I found Eddie Woo while studying entry level pure math at uni, and I'm back four years later when covering entry databases.
The dude is timeless.
hope my professor r half of you=.= ur 7 min. worth him the whole class
HAHAHAHAHA
4:53 hahhahaa TKO abbrieviates to technical knock out lol
Anyways top video thanks man really help a lot
10 years later and this information is so useful and you taught it so well! I am currently studying for my SAA exam. Thank you!
For the life of me I have always had a difficult time mastering the concept of what a foreign key and primary keys are. Now I can explain it to others. You have explained it easily, thoroughly and without confusion. Thank you.
😍 Eddie has absolutely Woo’d me 😍
2 Things:
1) There is no way to distinguish student A from student B granted they share FirstName, LastName, ClassID and POB -> Solution: Use extra field, StudentID
2) When I first started learning Databases I was confusing the theory with the practice
To understand the concept I had to follow a few tutorials of how to create actual databases
Brother...you are so natural ...with your knowledge.... i wish i could be like you..
Hmm..I agree Sir.. also....was little curious ,do you have any more videos for database...?
That's101. Or 100.5, more. But now a university, where students take many classes, or courses with different, simultaneous subcourses. And professors with more than one subject, or 2 professors, teaching the same course, or separate lessons in a single course, etc, etc. Things get more complicated when an ERD grows. Also, you cannot duplicate records (So you can't have Class ID in the Student table when a Student takes more than one class). That's called normalization. And then, this ERD only applies to transactional systems. For analytical systems, or auditable financial system, you have other schemas alltogether.
Of course: I Google for help, and Eddie Woo shows up. Not only does he show up, I'm HAPPY TO SEE he shows up. I know that after the video, I'll understand things better. Dude is just SO helpful.
I was randomly searching through database tutorials and felt ecstatic to find you've covered one of these things :D
Wow, great. Eddie, what kind of "whiteboard" are you using doing this video? It's awesome.
well class and teacher is a MANY TO MANY relationship
Thank you, simple and precise!
Very well explained - class id, primary key foreign key -
Good and clear video, very helpful
The concept was explained well. But another thing that impressed me is how could you use your fingers on board with some application projected on to a screen. Thats amazing..!! Please let me know. Thats very interactive technology you were using in this video.
Hi Mr Eddy. I guess it's a smart board. Just now googled. If I am wrong please do let me know.
where did you get it Eddie??
My school forced Database Management on us. And expected us to just learn it on our own. -_-
You sir, are a god sent.
seeing this 9 years after and the energy in the video is still shocking me
Topic is on Schema and students can't even answer elementary questions like primary and foreign key? The teacher is awesome but I guess his talents are wasted on this bunch.
Maybe they are advised for being silent
so it is correct to say that database schema and ERB are essentially the same thing then. It has been puzzling for me for a while.
Wow I learnt something and I am in year seven
I'd love an explanation from you on database vs schema vs model vs instance etc. These are confusing.
I had to watch so many videos until I found this one that explained it so clearly. Thank you.
Thanks Eddie ...very well explained in short time!!
Ok so now I know this is from James Ruse
i love your classes
i was thinking that u just teach math kkkkk
dayum man, now that's how an expositor should speak, well done eddie :D
Well explained. Cheers mate.
What kind of board is that?
Kowalski Analysis. Select VideoLikes From TH-camDB.ThisVideoInfo
Eddie, my daughter is going to take the AP (Advanced Placement) Statistics course this fall, she is in Sarasota, Florida, U.S.A at her junior year, I wonder is this the course series you teach that can help her with the course AP Statistics?
S
very easy to go with.
In the relationship between the Class and Teacher table which table contains the foreign key and the primary key?
Superb explanation. If you have many more subjects videos then pls share me. i just subscribed your link.
Awesome!!! I am impressed. Subscribed!
What a great teacher!
my fingers hurting after watching this. BTW thanks for this vid
teachers from india....... no dude its m*m for class and teacher relationship
This is owsome. Please what kind of screen is this called?
I easily understood your lesson, it was a nice refresher for me. I'm just here to say that I like your teaching style and I've actually found you first from watching your lessons on mathematical induction so I was surprised when my friend linked me this video (we're working on a project involving databases). Keep up the good work :) I'm sure not enough people do this but I really appreciate you uploading your lessons, some teachers or professors seriously don't explain the topics you upload in such a way that the student can easily understand them.
Man, this was literally the best tutorial I watched whole this year! I really mean it man, You taught Database schema the best way possible. Salute to you bro ✌✌❤
Great Video. I've added the the Structural Data, and Google's markup tool shows the info but, my Business's knowledge graph hasn't updated. How can I have the info updated?
He sound australian
Relational databases have "fields" ???
Class.ClassID is a Primary Key ??? It provides Uniqueness ???
Try inserting ...
Class (1, "Mickey Mouse", "5A")
Class (2, "Mickey Mouse", "5A")
Class (3, "Mickey Mouse", "5A")
With "databases" like that, you will have ALL KINDS OF FUN that people who have databases do not have.
wow, great energy teaching something like this
Is there any online resource where we can find pre-built schemas?
We don't have that kind of teaching technology here in the Philippines. Luckily I found your channel. Now I can understand more about our lessons. Thank you Sir. I've watched your video about data flow diagram. Can you make more tutorials please? Our subject is System Analysis and Design and the way of teaching our professor does is not that student friendly. He just read it from his presentation. he don't have actual examples.
I really want to excel in math. That's my weakness. Your videos about math can help me also sir. I hope that the way of teaching here in my country is like the way you teach. Thanks for the immediate reply. God bless.
Damn..You're so much better than my professor.
anyone tell me how he is writing on the white board with using his hand?? or am I watching wrong??
What is the difference between database schema and relation schema
Am I only one here after 7 years. 2020
Surely this isn't a high school class. Am I wrong?
Eddie Woo
could u tell me what about database instence ??
which thing is ur using to write on the BOARD or touch screen
Their should be a StudentID in the student class, should their not?!?!?!?!?!?!!?!??!?!!???!!
1234LMAO12345 Yes. That would be the Primary key of the Student table. Class ID would be the foreign key linked to the Class table.
Anyone wanna belt those who disliked this video?✋✋
what name of whiteboard with touchscreen like that?
Love the projector touchscreen thing you have going here!
i go to that school! my youtube channel is XMRetro
You said a teacher teaches one class. Is it at an instant you are talking about?
is it a board or a projector, i haven't seen this kind before
Helpful man...thanks for tutorial
Could u also show an example of many to many?
Is this mapping always done from right to left?
Thanks
Records produced after joining depend on this mapping?
Thanks
Wow just amazing explain ! 🤩
One book can be borrowed by only one borrower AT A TIME, unless you want some kind of borrowing history. If you do not want the latter, it's pretty simple : you just add something like "borrower_person_id" to "book" table, and make it a foreign key, referencing a person, that is holding the book at the moment. When that guy returns the book to the library, the value of "borrower_person_id" will change to NULL. When the other guy takes it, "borrower_person_id" will then reference that new guy...
Absolutely great video! 🎉
thank you lord woo
he's fucking drawing in paint with his fingers wtf
Love your charisma and way of teaching, but there's one thing in particular that I don't like about this class and that's teaching beginners to use upper case characters.
Since many, if not most, automated relational database solutions are linked (in-)directly to the host's file system, promoting the use of upper case characters will enevitably result in n+1 headaches for the inexperienced who move their databases from a case insensitive local solution (windows for example) to pretty much any other system that features case sensitivity.
I've had to help out countless, countless number of people getting their databases to work on their first unix-based environments simply because of something case-sensitivity related. So for absolute beginners: stick to lower casing to prevent headaches. They can always decide to go for a different naming convection once they're more experienced.
Edit: I realize that one might think that's not within the scope of this lecture, but it all starts here, at the absolute beginning
Good job sir. Helped in understanding
Not a well-designed schema! (ClassID in Student table?? -- is that the only class he/she takes?)
Yeah he said it was the only class the Student takes since it's a primary school
Who are you teaching this to? Year 12??
A student to class relationship is many to many and would require a join table. A teacher to class relationship is one to many. His explanation was exactly incorrect.
you are the best teacher in the world :) !!!
Xcellent explanation and very simple to understand. Thanks.
I am new to programming. This video is awesome,better than my teacher. So , from where should i start learning the database. Like topics. #GreatVideo
BTW can't it be like one teaching many classes, one to many relationship ?
Thank you very much.
god I wish you were my database teacher
Awesome:-) , you make things so easy to understand..You really have a gift to teach:-), can you post some videos on sequence diagram,state diagram and use case diagram pls
I literally just started watching this video and got a splash of all the energy in your teaching method. You're awesome!
How did you manage to get the desired screens or options just by touching the projected part. Ive never seen that before.
Thats a smart board
yoooo, it's that math guy. What's up dude
Would an intersecting table Consist of just primary keys from other tables?
Great video. Very informative and helpful. Thanks!
May I ask what is the touchscreen that you are using? It could come quite handy in my daily life. Thanks for the video
TKO = Technical Knock Out.
Excellent way of explanation.
👏🏼👏🏼👏🏼👏🏼
wow this was awesome teaching method
thnx fr sharing ur knowledge!!!
it's crystal clear thank u
BIG DATA in a small package....nicely done thanks a lot
Just watching random database design videos and clicked on this without looking at the author. I legit was so excited to see Eddie's face! You explain things like no other