This guy is by far the Best Teacher ever. I learned everything I know about VBA from him. Now I have moved on SQL Server and don't even know why. I have no need for it. But he does so great that I feel like I could learn anything that he was teaching.
Thank you for this knowledge. I was unaware of designer diagram way of creating tables and establishing relationships. Thank you for teaching normalization and datatype selection thought process.
Thank you so much, sir I don't have words for you at this point just amazing and you're awesome, fantastic, fabulous Teacher again Thank you so much, sir, by heart
Awesome content! Thank you Andy! One question here that I've been trying to digest in my mind for the last couple of days. Lets say we've got person table and hobbies table and a relation between them made on HobbyID present in both of them. What is the idea of this? Lets say initially our person table has hobby name in it (no hobby table at this point) and once we create a relation to hobby table we simply remove the hobby names from person table and replace them with IDs and make reference to the same ID in hobby table. I can understand this when we assign ID = 1 to lets say 'Dancing'. In terms of memory number 1 takes only 1 byte and it is much less then 7 bytes of 'Dancing'. What if our ID seed is like 1000000 - we can do that, why not - and now it takes 7 bytes as well. And lets give more hardcore example: our ID seed is the same and hobby name is shorter (for example 'Yoyo'). Seed itself takes 7 bytes while 'yoyo' would take only 4. Is there anything else besides memory saving? Advangage on computing numbers over computing strings?
Very good tutorial. Out of the box, in real world, how we are going to add data into the tables? If we have form where we put person's details and hit save button how we are going to save the details in these specific tables? Can you please explain?
Its very helpful. But I suck at one place. If while entering titles in the title table, I typed similar title and hit enter. In the table it showed NUll in Title ID and I could not delete it. And one number in the ID missed. How can I correct it.
Hi, it's because you could use any value as a primary key (a product code or unique reference number for instance), it doesn't necessarily have to be an auto-number.
Funnily enough, when it comes to actors, duplicate names aren't allowed! en.wikipedia.org/wiki/Screen_Actors_Guild#Unique_stage_names But in general, yes, you're likely to encounter duplicate names in a database of personnel or customers for example. Think of it this way - a row in the Actor table isn't just a representation of the name, it's a representation of a specific entity (an alternative name for a database diagram is Entity Relationship Diagram). The name and date of birth are simply properties of that entity. While there could be many people called Tom Cruise, only one specific person with that name property played Maverick in Top Gun. In database terms, the primary key (in this case a simple number but in the real world perhaps an employee reference number, a customer identifier, a National Insurance number, etc.) uniquely identifies each specific entity with the name Tom Cruise. If you were strictly trying to avoid any duplication of values in your database you could create a separate table of names where the value 'Tom Cruise' is stored once and once only. The primary key value of this name could then be assigned to a row in the Actor table when you need to add another person with the same name. It would be highly unusual to do this however!
Hi, When I have a middle name, how can I check if it is not empty in the computed column? Otherwise you will get an extra space. Kind Regards, Dante Netherlands
Hi Dante! There are several ways you could do this ISNULL( MiddleName + ' ', '') If concatenating the MiddleName with a space results in NULL an empty string will be produced instead. I hope that helps!
@@WiseOwlTutorials Hi Andrew, sorry to bother you with a question. I can't get the full name without a space in the computed name when there is an infix. Without the name prefix, there is no space in the full name field. Is there any way to check if the first name or prefix is empty? As I have it now: SureName', '+isnull(FirstName+' ','')+isnull(Prefix+' ','') Kind regards, Dante
@@dantehavenaar1044 Hi Dante! If the Surname field does not allow nulls but the FirstName and Prefix fields do then this expression should do the trick: Surname + IsNull(' ' + FirstName, '') + IsNull(' ' + Prefix, '') Or you could use the Concat function instead: Concat(Surname, ' ' + FirstName, ' ' + Prefix) I hope it helps!
Thank you very much my dear and sweet brother,i kiss you ,God bless you, you solved my big problem.i wish you more successful and happy,my problem was that i couldn't create the diagram of database i was face to error that you showed it.
Hey. Watching Andrew's videos has become one of my hobbies.
5yrs later and this is still so good! I just ran into a situation where I need to create a database from scratch!
Happy to hear that you found it useful, thanks for watching!
Time well spent. Thank you for this quality delivery.
Glad you liked it!
This guy is by far the Best Teacher ever. I learned everything I know about VBA from him. Now I have moved on SQL Server and don't even know why. I have no need for it. But he does so great that I feel like I could learn anything that he was teaching.
Thank you for this knowledge. I was unaware of designer diagram way of creating tables and establishing relationships. Thank you for teaching normalization and datatype selection thought process.
You're very welcome Navya, I'm happy to hear that you found it useful and thanks for your comments!
I wish teachers could teach it this way.
I am surprised !!
i have to pay for Netflix but not for this video.
great work sir
Thank you SO MUCH for this video which I found it very use full and also Help full , and I really enjoyed watching it!
Very happy to hear that you enjoyed it, Rokhsare! Thank you for watching!
Thank you so much, sir
I don't have words for you at this point just amazing and you're awesome, fantastic, fabulous Teacher
again Thank you so much, sir, by heart
You're very welcome as always, Pradeep. Thank you for your support!
Thank you Andrew. In this video I have learnt a lot again!! Looking forward to the next video
You're very welcome! Happy to hear that you found it useful, thanks for taking the time to leave a comment!
You are the God of Sql....these videos are just amazing
I like your video a lot! You are such a good teacher!
really great videos .. thanks for your time and instruction
Extremely helpful. Mr.Wang is correct! you're such a good teacher :)
Keep uploading tutorials.
Cheers!
Another great video from Wise Owl! Thanks.
Great video! I really enjoyed the joke about watching SQL videos as a hobby.
Great Videos Sir. Thank you very Much.....!! Fantastic
You're very welcome, thank you for watching!
Thanks for another great video in this excellent series.
Thank you for posting this Video, well put together and well presented.
You are really good in explaining sir...
really great videos.....well presented and explained....Thanks
Hobby: Making youtube training videos, sad hobby - Phd Gould...ahahaha..
you are the trainer, Andrew
Awesome video series.
Thank you for your great work.
Good explanation , Thanks.
You're welcome, thanks for watching!
OutStandIng !
Wish I knew about the Database Diagram features about ten years ago that way I might still have real hair !! haha
INSERT INTO RUclipsVideo (1st_Comment)
VALUES ('Love the videos man');
Great work sir.
Awesome content! Thank you Andy! One question here that I've been trying to digest in my mind for the last couple of days. Lets say we've got person table and hobbies table and a relation between them made on HobbyID present in both of them. What is the idea of this? Lets say initially our person table has hobby name in it (no hobby table at this point) and once we create a relation to hobby table we simply remove the hobby names from person table and replace them with IDs and make reference to the same ID in hobby table. I can understand this when we assign ID = 1 to lets say 'Dancing'. In terms of memory number 1 takes only 1 byte and it is much less then 7 bytes of 'Dancing'. What if our ID seed is like 1000000 - we can do that, why not - and now it takes 7 bytes as well. And lets give more hardcore example: our ID seed is the same and hobby name is shorter (for example 'Yoyo'). Seed itself takes 7 bytes while 'yoyo' would take only 4. Is there anything else besides memory saving? Advangage on computing numbers over computing strings?
GOLD!
Very good tutorial. Out of the box, in real world, how we are going to add data into the tables?
If we have form where we put person's details and hit save button how we are going to save the details in these specific tables? Can you please explain?
Thanks for the video.
excellent video!!!!
You are amazing 🤗
Its very helpful. But I suck at one place. If while entering titles in the title table, I typed similar title and hit enter. In the table it showed NUll in Title ID and I could not delete it. And one number in the ID missed. How can I correct it.
How much do you like the video of Wise Owl?
ONE TO MANY.
and how much does the people like?
MANY TO MANY.
THANK YOU!
Is there a good reason why when you select a column to be a primary key it doesn't automatically change 'Identity specification' to Yes?
Hi, it's because you could use any value as a primary key (a product code or unique reference number for instance), it doesn't necessarily have to be an auto-number.
Thanks @@WiseOwlTutorials! I tried to donate towards a pack or two of hob nobs for you though the PayPal link was not working
@@concert_music No problem! Sorry the link wasn't working for you, it seems to be fine now, thanks for trying to donate anyway!
How does PeopleID get populated.
im a bit confused surely there are people with the same first name last name and DOB?
Funnily enough, when it comes to actors, duplicate names aren't allowed! en.wikipedia.org/wiki/Screen_Actors_Guild#Unique_stage_names
But in general, yes, you're likely to encounter duplicate names in a database of personnel or customers for example.
Think of it this way - a row in the Actor table isn't just a representation of the name, it's a representation of a specific entity (an alternative name for a database diagram is Entity Relationship Diagram). The name and date of birth are simply properties of that entity.
While there could be many people called Tom Cruise, only one specific person with that name property played Maverick in Top Gun.
In database terms, the primary key (in this case a simple number but in the real world perhaps an employee reference number, a customer identifier, a National Insurance number, etc.) uniquely identifies each specific entity with the name Tom Cruise.
If you were strictly trying to avoid any duplication of values in your database you could create a separate table of names where the value 'Tom Cruise' is stored once and once only. The primary key value of this name could then be assigned to a row in the Actor table when you need to add another person with the same name. It would be highly unusual to do this however!
@@WiseOwlTutorials ah ok thankyou for taking the time to clearly explain makes sense now
@@harrisonwright3900 No problem!
Hi,
When I have a middle name, how can I check if it is not empty in the computed column? Otherwise you will get an extra space.
Kind Regards,
Dante
Netherlands
Hi Dante! There are several ways you could do this
ISNULL( MiddleName + ' ', '')
If concatenating the MiddleName with a space results in NULL an empty string will be produced instead.
I hope that helps!
@@WiseOwlTutorials Works like a charm.... Thanks for your help!
@@dantehavenaar1044 No problem, happy to hear that you solved it!
@@WiseOwlTutorials Hi Andrew, sorry to bother you with a question. I can't get the full name without a space in the computed name when there is an infix.
Without the name prefix, there is no space in the full name field.
Is there any way to check if the first name or prefix is empty?
As I have it now:
SureName', '+isnull(FirstName+' ','')+isnull(Prefix+' ','')
Kind regards,
Dante
@@dantehavenaar1044 Hi Dante! If the Surname field does not allow nulls but the FirstName and Prefix fields do then this expression should do the trick:
Surname + IsNull(' ' + FirstName, '') + IsNull(' ' + Prefix, '')
Or you could use the Concat function instead:
Concat(Surname, ' ' + FirstName, ' ' + Prefix)
I hope it helps!
No Gould?
- Michael Scott
Thank you very much my dear and sweet brother,i kiss you ,God bless you, you solved my big problem.i wish you more successful and happy,my problem was that i couldn't create the diagram of database i was face to error that you showed it.