Top notch video. People complained that you spoke slowly: the subject matter of the video and the clarity with which you delivered it outweighed the slow speech. Watching this tutorial was much easier to understand and faster than reading a chapter which would have conveyed the same message.
Even though it's 3 years since you made this video, it's still very good. Well explained, and clear instructions on how to do things. Many will learn from this still.
Thank you for the tutorial and for taking the time to offer it to us for free! Your pace and your presentation style are just fine and worked well for me. I have a doctorate as well. So I guess we're just slower on the uptake than the wise guys who cursed you. Shame on them for their lack of gratitude. God bless you Dr. Soper.
Excellent video that very clearly explained foreign key concepts and setup. Your speaking slowly and very clearly was a huge benefit for those us who want to actually learn something instead of just hearing it spit out quickly for those who probably already (think) they know what you are teaching us. Thank you so much for posting your video!
(1:49) method to set a single column as the primary key (4:15) second method to set a single column as the primary key (6:50) method to create a composite primary key which uses more than one column (9:20) method to create foreign key (13:16) second method to create a foreign key
Thanks for sharing! I'm a beginner but I think I can learn now SQL in a easy and fastest way.......May God give you its returns in this world and hereafter as well.... stay blessed
Wow, You did a great job creating this video for us, very top quality, Real English Language that makes us understand the words and talks, great display and used tools for this video, No extra talks, and repetition, very easy to follow.... I really like your video and effort in this video. I wish to see more SQL videos from you. You are a great instructor.
Great video. Thank you. Question? What software are you using to create this tutorial? I love how you can smoothly zoom and highlight different objects on the screen.
Great, comprehensive walk through of a fundamental database tool. Would love it if I could speed up the playback as the speech was a little slow. Thanks for the video!
To increase any video playback speed select the Gear Icon (Settings) in the bottom right of the video and select -> Playback Speed. Then increase the speed by the desired multiplier.
Well done, thank you. Excellent explanation/demonstration. I see a couple of people complained that you spoke too slowly, personally I think your pacing was perfect.
This remark is useless at best. Not every video has to or indeed should be frantically packed with information to show off the author's supposed brilliance-most examples of which reveal a scatterbrained thoughtlessness. Such learning tends to be volatile. Not to mention the fact that many listeners are not native English speakers.
When someone does not understand something, the best way is to be patient and pay attention. He applied the best way to teach someone. when some people know something, they just press the forward button... That 's all.
Thanks, nice video, still confusing about why the 'productId' is not linked with 'customerId'? How do we know which Customer purchase a particular product? Pls, share more light to this.
@Dr. Daniel Soper , Well that was a great tutorial.. that so easy way to creating foreign , BUT when we are going to add the data in those tables it will give error of parent table and child table constraint ..How to handle that error ? please explain to me , i shall be highly obliged to you ..
![SQL Tutorial for Beginners [Full Course]](http://i.ytimg.com/vi/7S_tz1z_5bA/mqdefault.jpg)
I know this video is 7 years old, but this has helped me out so much.
Top notch video. People complained that you spoke slowly: the subject matter of the video and the clarity with which you delivered it outweighed the slow speech. Watching this tutorial was much easier to understand and faster than reading a chapter which would have conveyed the same message.
I love his slow speech !!!
Even though it's 3 years since you made this video, it's still very good. Well explained, and clear instructions on how to do things. Many will learn from this still.
yo bro its 9yrs now
almost 9 years and still help me, you are god
This is definitely the tutorial I want, no theory, no SQL language, easy to follow.
One of the best tutorial vid. The visual and audio is flawless. The speaking speed is not too fast.
th-cam.com/video/rRmI16IkqG0/w-d-xo.html
Very thorough explanation. Great video for beginners. I was in a rush to find the foreign key information [starting at 9:30]
th-cam.com/video/rRmI16IkqG0/w-d-xo.html
Thank you for the tutorial and for taking the time to offer it to us for free! Your pace and your presentation style are just fine and worked well for me. I have a doctorate as well. So I guess we're just slower on the uptake than the wise guys who cursed you. Shame on them for their lack of gratitude. God bless you Dr. Soper.
th-cam.com/video/rRmI16IkqG0/w-d-xo.html
Excellent video that very clearly explained foreign key concepts and setup. Your speaking slowly and very clearly was a huge benefit for those us who want to actually learn something instead of just hearing it spit out quickly for those who probably already (think) they know what you are teaching us. Thank you so much for posting your video!
Exactly.
th-cam.com/video/rRmI16IkqG0/w-d-xo.html
(1:49) method to set a single column as the primary key
(4:15) second method to set a single column as the primary key
(6:50) method to create a composite primary key which uses more than one column
(9:20) method to create foreign key
(13:16) second method to create a foreign key
Dr. Soper its my First lecture in your channel ,but now i am a big fan of yours .you a a awesome
I looked up this tutorial to help with my assignments. Looked down to see it was from my actual professor! Thanks for the Help Dr. Soper!
Thanks for sharing! I'm a beginner but I think I can learn now SQL in a easy and fastest way.......May God give you its returns in this world and hereafter as well.... stay blessed
Perfect explanation, my uni lecturer takes hours and couldn’t understand. I took a view on your video and understand straight away.
Thanks
You sir, are a saint among men. every bit of info provided here is still relevant.
Thank you Dr. Soper for this informative video. your teaching style is commendable.
This was uploaded when I was in 6th grade. Did not expect I will be here studying databases.
I was familiar with the concept but now I learned practically.
Thanks
I so much appreciated your calm and simple approach
You deserve heaven, thank you man
Its been a while since this video came out but it still provides useful information for new users of the SQL Server Management Studio! Thanks man :)
This was great to help me brush up on my database skills that had got a little rusty.
Wow, You did a great job creating this video for us, very top quality, Real English Language that makes us understand the words and talks, great display and used tools for this video, No extra talks, and repetition, very easy to follow.... I really like your video and effort in this video. I wish to see more SQL videos from you. You are a great instructor.
Thank you so much for this video. It's so clear and easy to understand. Saved me from frustration taking hold.
By far the best tutorial I've come across. Thank you!
th-cam.com/video/rRmI16IkqG0/w-d-xo.html
Thanks for your excellent video. This must be one of the best tutorial regarding on how to create primary and foreign key in sql server.
th-cam.com/video/rRmI16IkqG0/w-d-xo.html
Excellent video !!! Thank you Dr Daniel Soper !
Thank you, Dr. Soper, for the great video. Step by step, simple and clear.
Great Explanation. I was able to do the database model for DW watching this. Thanks
very good explaination Mr Dr. Daniel Soper. thanks
Hi Dr. Daniel Sooner; Thank u for the great presentation😀👍
Yes, learned everything u taught.
its 2023 and i thank you it help me with my capstone
Thanks You a lot Daniel Soper. You helped me a lot of understand in this area, especially for those kind people like me as a beginer of asp.net
Thank you, Dr. Soper.
You did a great job and you save my day.
Wow Dr. Soper! Excellent explanation! Thank you so much Dr.
Great video. Thank you. Question? What software are you using to create this tutorial? I love how you can smoothly zoom and highlight different objects on the screen.
express sql
I'd like to say a big "thank you" for your detailed tutorial.
th-cam.com/video/rRmI16IkqG0/w-d-xo.html
thank you so much mr Dr.Daniel Soper God bless you all the time
I honestly learned something interesting. Thank you Dr. Soper
Minhas dúvidas quanto a criação destes tipos de relacionamentos foram sanadas! Obrigado Dr.Soper!
Thanks for the video, was better than any book can ever be.
Very very very good tutorial... couldn't really find any informative out there... Thanks .......
Thank you Dr. Daniel Soper.
Thanks for explaining step by step.
Great, comprehensive walk through of a fundamental database tool. Would love it if I could speed up the playback as the speech was a little slow. Thanks for the video!
th-cam.com/video/rRmI16IkqG0/w-d-xo.html
To increase any video playback speed select the Gear Icon (Settings) in the bottom right of the video and select -> Playback Speed. Then increase the speed by the desired multiplier.
Well done, thank you. Excellent explanation/demonstration. I see a couple of people complained that you spoke too slowly, personally I think your pacing was perfect.
th-cam.com/video/rRmI16IkqG0/w-d-xo.html
This tutorial Help Me A lot Thanks Dr. ........!
Thank You so much for going step by step! This really helped me with my assignment.
th-cam.com/video/rRmI16IkqG0/w-d-xo.html
very interesting and useful video. thank you so much DR.Soper
Extremely helpful video that clearly defines the processes. Many thanks!
Thank you for sharing great knowledge with us !
Very informative and excellent way of delivering.
thanks Dr. Daniel Soper for this tutorial it's fantastic , however flocks set video speed to 1.5 x
can you create a crystal report tutorial with these tables?
Very descriptive, awesome for beginners!
Just what I was looking for...thanks.
Thank you so much Dr. Soper!
Thanks for the info. Thank youtube for 2x video speed
This remark is useless at best. Not every video has to or indeed should be frantically packed with information to show off the author's supposed brilliance-most examples of which reveal a scatterbrained thoughtlessness. Such learning tends to be volatile. Not to mention the fact that many listeners are not native English speakers.
When someone does not understand something, the best way is to be patient and pay attention. He applied the best way to teach someone. when some people know something, they just press the forward button... That 's all.
real
2x is not enough
Thank you for the comment too!
Thank you. Excelent explanation. I would like to see more videos about this topic.
Excellent tutorial sir...very good
Loved this video Sir. Very Informative. Thank you!
& Liked your way of teaching slowly and explaining everything in a nice way.
th-cam.com/video/rRmI16IkqG0/w-d-xo.html
9:00 foreign key
Thanks... Hero!!
You're the real MVP
th-cam.com/video/rRmI16IkqG0/w-d-xo.html
@@maryadam4174 7 years later and you are still a fucking legend!
Thanks! Really helped
Thank you SO much for making this video. Clearly spoken and understandable. Thanks bro!
Very nice explained. Many thanks!
Excellent presentation.Hope to get more demonstration in future too.
thanks a lot for posting such a clear detailed yet brief tutorial , it helped a lot and it is interesting to learn . thank you dr :)
perfect explanation of both keys
Very nice, best one I found on the internet.
Very nicely explained, it helped me so much to understand the concepts.
I had no idea it was so simple.
Very good demo. cool and simple.
Definitely one of the best videos about the topic. Thank you very much!
Useful for the Data Design assignment. :)))))
Thanks for this helpful tutorial !... How we can copy the values of Primary key to foreign key?
Excellent. Thank you Prof.
2:10 set primary key
3:00 refresh the list each time
7:00 composite primary key
9:40 foreign key creation
Thanks , very very explanatory video. Highly recommended
You are the best you helped me so much thank you again😭
Very Good Video!! Saludos de Argentina
Very nice tutorial. Thank you.
outstanding explanation dude...
So when creating the relationship, which table should you create the FK in? Should you start in the many table or doesn't it matter?
Thank you so much, sir. I wish I could give you more than one up vote.
Excellent explanation boss 👍👌👍
Could you explain further why did you set the orderId and productId as primary key in the Orderline table?
thanxx man for easing my life
Thank you i like the way you explain
Dear Sir, would you like please to continue how to create query of those tables, thank you, it ia great and very clear tutorial 👍👍
i dont speak english but this video is so good that i cannot understand everything
Thank you very much this helps me a lot
wow! thanks 4 your explanation, it was so clear and easy!!!
Thanks, nice video, still confusing about why the 'productId' is not linked with 'customerId'? How do we know which Customer purchase a particular product? Pls, share more light to this.
Thank u so much for this brilliant tutorial!
@Dr. Daniel Soper , Well that was a great tutorial.. that so easy way to creating foreign , BUT when we are going to add the data in those tables it will give error of parent table and child table constraint ..How to handle that error ? please explain to me , i shall be highly obliged to you ..
Great video, finally someone who can teach! ;-)
Thank you so much.Very helpful tutorial.
Thank you, very helpful video.
Thank you very much, you help me a lot!
A really great video, thanks a lot for giving your time and knowledge!
th-cam.com/video/rRmI16IkqG0/w-d-xo.html
Good tutorial. simple and comprehensive . Bit slow some times. But that will be good for beginners