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
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?
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?
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.
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!
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!
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.
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.
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!
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!
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 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
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!
Extremely helpful. Mr.Wang is correct! you're such a good teacher :)
Keep uploading tutorials.
Cheers!
I like your video a lot! You are such a good teacher!
I wish teachers could teach it this way.
really great videos .. thanks for your time and instruction
Thank you for posting this Video, well put together and well presented.
Another great video from Wise Owl! Thanks.
Great video! I really enjoyed the joke about watching SQL videos as a hobby.
I am surprised !!
i have to pay for Netflix but not for this video.
great work sir
really great videos.....well presented and explained....Thanks
Awesome video series.
Thank you for your great work.
Thanks for another great video in this excellent series.
Great Videos Sir. Thank you very Much.....!! Fantastic
You're very welcome, thank you for watching!
Good explanation , Thanks.
You're welcome, thanks for watching!
You are really good in explaining sir...
Great work sir.
Hobby: Making youtube training videos, sad hobby - Phd Gould...ahahaha..
you are the trainer, Andrew
OutStandIng !
Wish I knew about the Database Diagram features about ten years ago that way I might still have real hair !! haha
Thanks for the video.
excellent video!!!!
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?
You are amazing 🤗
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?
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.
INSERT INTO RUclipsVideo (1st_Comment)
VALUES ('Love the videos man');
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!
GOLD!
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!
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!
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!
How does PeopleID get populated.
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.