Creating and working with tables - Part 3

In this video we will learn
1. Creating tables
2. Enforcing primary key and foreign key constraints
Text version of the video
csharp-video-tu...
Healthy diet is very important both for the body and mind. If you like Aarvi Kitchen recipes, please support by sharing, subscribing and liking our KZbin channel. Hope you can help.
/ @aarvikitchen5572
Slides
csharp-video-tu...
All SQL Server Text Articles
csharp-video-tu...
All SQL Server Slides
csharp-video-tu...
All Dot Net and SQL Server Tutorials in English
www.youtube.co...
All Dot Net and SQL Server Tutorials in Arabic
/ kudvenkatarabic

[@Sarahnjeri354]

Hi Mr KudVenKat. I love your tutorials. They are very detailed and very inspiring. I can vote you the best youtube teacher.

[@Csharp-video-tutorialsBlogspot]

Thank you very much for taking time to give feedback. This means a lot. I am very glad you found the videos useful. I have organised all the Dot Net & SQL Server videos in to playlists, which could be useful to you kzbin.infoplaylists?view=1&sort=dd If you need DVDs or to download all the videos for offline viewing please visit www.pragimtech.com/kudvenkat_dvd.aspx Slides and Text Version of the videos can be found on my blog csharp-video-tutorials.blogspot.com Tips to effectively use my youtube channel. kzbin.info/www/bejne/r2ibYYCtnb5qZtU If you want to receive email alerts, when new videos are uploaded, please subscribe to my youtube channel. kzbin.info If you like these videos, please click on the THUMBS UP button below the video. May I ask you for a favor. I want these tutorials to be helpful for as many people as possible. Please share the link with your friends and family who you think would also benefit from them. Good Luck Venkat

[@azrasaniya3058]

Adding rows at the end of the table?? My rows are getting added in the middle of the table How do I avoid that??

[@anupupadhyay8808]

Hi Venkat, Could u plz create vedio on python and Mysql?

[@rajinipriya3053]

Yes.. even I felt same

[@vijaydeshmukh7812]

@@Csharp-video-tutorialsBlogspot Hi sir please can you suggest a laptop under 30k for the .Net SQL database. Where we can work.

[@jgibson0522]

Excellent video. Thank you for adding value to the internet. People like you make the world a better place.

[@georgigeorgiev4871]

Dear Mr. Venkat, your work is great. You are a very good tutor and point out even the smallest details, which can ruin anybody's day. You deserve a lot more likes! Cheers for the good work from Bulgaria!

[@Sunelification]

+Georgi Georgiev Hallo Georgi! I'm also watching and loving Mr. Venkat's tutorials! :-D

[@virajvasaikar5156]

he does deserve more likes .....but in india his lyks will depend on which region he is from or which caste he belong.... i will like to speak more straight ....even religion matters .... mayb if he was from other religion (wont take name of that religion)...he would have got more likes even if his teaching was worst .... :)

[@bhaskerupreti9969]

"Insert Statement conflicted with foreign key constraint" error, can anybody solve this problem I did same as venkat then also I m getting error why???

[@Chux48]

This is by far the best made tutorial I've ever found on the internet

[@SmilingNiki]

I watched a lot of videos in the topic of SQL but I found yours the best. You're not only showing how to do things but explaining the point of every part in such a nice simple way, giving enough information so we can see it in whole. I especially liked that you showed how to do these both in the designer and query too. It was really helpful! Thank you!

[@masjediaqtash6578]

+SmilingNiki if u r also the one who ia learning and have some knowkedge about SQL server then lets have a connection to eachother . this ia my fb id .Masjedi Aqtash .

[@virajvasaikar5156]

true

[@MahmoudFaragallah]

I think he learn us how to think like a true programmer :)

[@gabsta69]

Thanks so much for compiling these videos, I have watched a lot of tutorials over the years and you are probably one of the best speaking professionals out there!

[@Ilovegigs]

I aim to watch all 140+ videos on this to be a genius! Thanks!

[@jiribem9845]

How far did you get aka are U by now ?

[@lizravenwood5317]

You amaze me. Not only do you know so much about so many technologies, you truly know how to teach. Thanks.

[@apoorvagupta9634]

My mind is like where were you before!. I have seen so manny videos, read so many tutorials but never got the practical understanding of the foreign key. You made it buttery smooth in this video. Thanks a tonn!.

[@RainnMakerr]

God Bless you man. Such polite method of teaching! It's a gift.

[@federicoladereche8727]

Venkat you are a Genius!!! Thank you very much!!! I love your tutorials, you really have a gift to explain and teach!!!

[@ajitphadtare2110]

Even NOn IT person can Learn SQL by watching this detailed tutorials NO1 videos Thank a lot... if i want to learn something i will learn from you

[@perfectionist6624]

watching in 2022 🤩 best SQL tutorial on KZbin till date... We dont even get such content by paying any institute... Thanks a lot sir....

[@sarthakshadangi1920]

Even after 10 years, this is the most relevant SQL playlist on youtube.

[@shazia321]

This is one of the best SQL Tutorial. Very Neat.

[@sondang5932]

YOU ARE THE GOD, I LOVE YOU AND EVERY TUTORIALS YOU'VE MADE, YOU SAVE MY LIFE. TANKS A MILLIONS

[@pramodkumarsura1880]

Awesome Venkat. You are the great online tutor or teacher. Your video tells how professional you are and committed towards your professional Thanks for your time and awesome explanation.

[@sandros8876]

Let me say thank you. You are a very good teacher.

[@sandros8876]

I will!! thank you once again!

[@mantudubey9970]

People like you make the world a better place, easy to understand thanku.....

[@Csharp-video-tutorialsBlogspot]

Hello Mantu - You are very welcome and thank you for the feedback. Means a lot. The full sql course is at the following link. kzbin.info/aero/PL08903FB7ACA1C2FB

[@lindahovius9436]

Dear Mr Kudvenkat, thank you so much for your videos! Not only do you make SQL crystal clear to me, but you actually make me feel competent using it, which is very motivating. In short: you make me a SQL-fan!

[@satwikburman6841]

Very helpful tutorials. What makes these tutorials stand out in the crowd is focusing on the cases and how to treat different scenarios differently.

[@dalekatz]

Namaste. I took a Microsoft course for this and I must say that I wish I had saved the money and found yours instead. You make every aspect of your tutorials very easy to follow and for this I thank you.

[@krismaly6300]

Revisiting to refresh BASICS. I enjoyed watching this video and recommend others. Thanks for educating the community and appreciate your volunteership. Thanks a bunch

[@Csharp-video-tutorialsBlogspot]

Thank you very much for taking time to give feedback. Express edition is free and will not SSIS, SSAS and SSRS features. Sure, will record and upload a video soon.

[@krismaly6300]

I enjoyed watching this video and recommend others. Thanks for educating the community and appreciate your volunteership. Thanks a bunch

[@Fkn1405]

Thank you very much Kudvenkat for these tutorials. I'm watching from PRETORIA, SOUTH AFRICA. Thank you very much

[@ShabnamKhan-vk7fj]

Amazing instructor! The lectures are so comprehensive and thorough, Hats off to Kudvenkat!

[@shikhaojha1844]

Hello Sir! I'm from biology background nd trying for career transition. I find your tutorial extremely helpful.. especially the small differences you tell that gives clarity. Thank you very much Sir for your efforts and time.

[@youngyyu]

this is The best tutorial by far i have found on KZbin.

[@kandarppatel9866]

Very well explained videos. Kudos Mr.Venkat. Refreshing for my interview and found your videos very informative. Thanks!!

[@salomonks-francais6752]

I wish i could hit the like button a thousand time, thank you a lot Teacher KudVenkat. Your Skills are unmatched.

[@michalroesler]

That's an awesome SQL series. It's the best one I've found on you tube.

[@krismaly6300]

Revisiting to refresh basics I enjoyed watching this video and recommend others. The host is an expert in MS SQL and Dot Net Programming. He is an excellent teacher and a nice person to share the knowledge to community. Note: Host creates the problem and resolves. This will give a good pictiure for audiance to learn how to overcome error. Example he creates a table in Master database then he realizes the table should have been created in the expected database. Thanks for educating the community and appreciate your volunteer-ship. Thanks a lot

[@anythinghere6274]

Oh My GOD You are The best teacher Bow Down To you Sir Best Teacher for DBMS

[@stannisbarracuda5693]

easily the best KZbin teacher.

[@PrasadChallagondla]

I felt in love with your teaching. Mind blowing. Now I have confidence that I can learn database easily.

[@theFJ]

the best ms sql server tutorial I´ve found. Very detailed, congrats!!!

[@baburamshapure]

Hi Venkat, greetings of the day! These tutorials are invaluable. I literally learned SQL Server by going through them. Really admire your work and the way your teach, so exhaustive. Thank you man. God bless you!

[@arnavdev8786]

Really...your videos help me a lot....thnx a lot man...god bless you.....!!!!!

[@sabitamohapatra5879]

Thanks Venkat for the nice tutorial. Your voice is so clear and simple to understand.

[@britishone4759]

I really enjoy learning SQL with your videos. You communicate clearly and make it easy to understand.

[@pragya8398]

Your awesome Sir...The training is just amazing..so easy to understand..there's no doubt left after I watch ur videos :) :) Thank you soo much :)

[@PlacidRodrigues1]

Thank you so much for creating such high quality tutorials.

[@Chinnamnaidu5268]

Sir ...Ur Way Of Explain The Cls Was So Clear Any Student Easily Understand ..Thank You For That .....

[@lindasue1846]

you do a wonderful job. it is so generous of you to share your knowledge with us. GOOD KARMA!

[@abhibt]

Completely agree.

[@chinugundi498]

Thank you soooo much Mr Venkat for these SQL tutorials. The narration and teaching method is awesome. love your Tutorials.

[@alihelmi]

I am watching this in 2018 and it's very interesting and useful. Thank you so much Mr. @KudvenKat.

[@irfany50]

gold bless you mr venkat.Nice tutorial please keep it up........God will give you long life. thank you sir

[@chaparro1097]

one of the best tutorials for sql I've seen

[@saurabhshukla9404]

One of the Best Tutorials for self learning....

[@Travelwithtenzin_]

hello Kudvenkat I had watched lots of videos of yours on c#,mvc,sql,angular they helped me a lot. My laptop hard disk is full of your tutorials.You had explain very well each topic. For you 100 out of 100 from my side.I had also suggested my juniors to watch your videos.

[@aishajahan219]

Your way of explaining the topics is to good, understandable and also to much meaningful for both beginners and experienced.

[@praveenravi2687]

Hi Venkat, Thanks for u r valuable time and effort. Explain very simple and clearly.

[@minamalak3790]

Thank you so much Mr KudVenKat for you tutorials, it seems amazing and very helpful for me, god bless you dear

[@Devilnero1991]

Simple , straightforward and very easy to understand.You are a great teacher.Thanks

[@ViktorLP14]

Man you are awesome, clear and simple and using the visual tables in the blue screen is very helpful.

[@theperfecttime5508]

Thank you... I am able to understand things I couldn't before watching your videos. Thank you SO MUCH!

[@7stefmel7]

YOU ARE THE BEST !!! WELL EXPLAINED !! I WILL SHOW YOUR SITE TO ALL MY FRIENDS! YOU HAVE A GIFT !

[@mithileshnaik9503]

Thank you so much for these videos.. It's a thankless job. Its helping me a lot. I hope you get everything that you wish in life.Thank you so much again.

[@nikhilkadam4914]

Tutorial is very use full, thanks of lot for sharing this in free of cost

[@astuteacerbic]

Hi Mr Venkat. You are awesome explaining things so precisely and empirically. Thanks for sharing. Was trying to find KZbin tutorial for SQL and yours i can easily deem to be the best one.

[@utmdeadman]

Really appreciate your hardwork, sir. Thank you

[@anshulkumarroy3265]

Sir, you are awesome. Keep educating the world the way you are doing.

[@rawofm]

Hi , thanks for best explanation , its a great work, its the most powerful way of study to SQL Server, great voice. thanks a lot

[@남자이우재]

이 강의 너무 좋네요 (This lecture is very Good) 강의 보면서 영어공부도 하고 일석이조 입니다.(I lean this lecture and study english that is killing two birds with one stone.) 고맙습니다.(Thanks.)

[@paulasubonteng-manu7248]

Thank you for breaking this down into smaller piece meal which can be digested... Mr Venkat

[@Rktx001]

watching in 2024.....great explanation .

[@mondal1839]

*Wow, such a great video as well as an absolutely brilliant explanation. Keep Making more and more tutorials.*

[@discoverthedebate8827]

Sir your tutorials are one of the best tutorials in the world. please make a complete tutorial on (HOW to host a asp.net project on online server) or (Hosting related tutorials).

[@mudedlapreethi3431]

IT IS REALLY A GREAT HELP FOR BEGINNERS,THANK U SO MUCH

[@mikan5918]

Hi sir your teaching skill is excellent and your tutorial is easy to understand , i was beginner and 1 of my friend referred your videos and i found it very easy.

[@DemiGod173]

thanks a lot Mr. Venkat, you are very generous to share these videos :)

[@gaganmungi2259]

Hi Mr. KudVenKat, the way you teach is so help full to me and i can complete my SQL course by your videos. can you please provide the Java and Core java tutorials with practical approach ?.

[@sivaasf7443]

thank you sir easily understand non cse students and awesome explanations ,teaching and presentation .

[@TewariTwins]

seriously ... these videos cleared a lot of concepts thanks a ton

[@jebingos]

11 years old still the best SSMS and sql tutorials

[@kpippink]

Thank you so much for the video. Your explanation is very clear and detailed. Best video ever!!!!!!

[@kpippink]

I surely will :D Thanks again for the additional links!!!!

[@bhaskerupreti9969]

"Insert Statement conflicted with foreign key constraint" error, can anybody solve this problem I did same as venkat then also I m getting error why???

[@UmarAdeeb]

Excellent video from an excellent teacher

[@anchal3336]

Damn good tutorial...i cannot find a better tutorial than dis!! The way you xplained each part of it is really good n easy to learn..Its of great help to me..! Hats Off...Thanks alot.

[@elatedGuru]

You are simply brilliant! Your lessons are so smooth, organized and very easy to understand. You are gifted and thanks for sharing the knowledge. I'm sure you'll be very successful.

[@ameya9909]

This is EXCELLENT tutorial. Thanks so much!!

[@syedqqayyum]

Thanks Mr Venkat for these videos uploading on youtube

[@sairamradhakrishna2150]

Mr. Venkat, Very nice & useful tutorial. Thanks

[@karanchand6338]

Thank you so much for creating this tutorial. Many students can learn it by watching these videos.

[@shubhamavdhut7431]

Sir your tutorial are Very Depth And Conceptual i love it so muckh thanks..

[@jamesbarrett1878]

The speed of the lesson is ideal, well done!

[@sudiptosarker6274]

All of your videos are very usefull. Your teaching method is very much understandable even for beginners. Thank you :)

[@buburayam6557]

At first I would like to apologize for thinking that this tutorial would be like another common programming tutorial on youtube. Few tutorials, kind of unclear at some part, etc. Turned out there are 60+ comprehensive tutorials which talk not only about SQL server but also SQL & database basics in general. I am not sure if this is even for beginner. I commend on the content creator for the effort and generosity in creating and sharing these useful tutorials. KUDOS!

[@ritikajaiswal3824]

This foreign key constraints concept is soo amazing MY Goodness

[@varunikagupta4969]

you really are too good at explaining the concepts!

[@MegaMitzio]

You are a Máster...........thanks for your dedication Greetings from Chile

[@rotrose7531]

Thank you. I do not know how much I can thank you.

[@krismaly6300]

I recommend others to watch this video where in subject matter is explained very clearly with example.

[@jagdeeshkp1]

Hi Venkat, This is excellent service and God bless you..I would be happy if you acknowledge this. Reg Jag

[@anitau6771]

you should come to my school and teach seriously even tho i just finish my SQL class with B+ i didn't understand shit till now. thank you MR Venkat. God bless

[@muharremalaca]

Thank you very much, you now how to do your job. Also your accent is very clear, congratulation...

[@chrisdavidson4697]

Thanks a lot, your tutorials are very helpful as it's detailed. Excellent teaching skill.

[@LucaPozzoli]

Thank you so much this is a great guide all concepts are explained very clearly

[@luckyblox317]

Very Good teaching and presentation skills. Just like spoon feeding. Thank You.

[@Lolo_NwanyiOma]

Thanks you, Venkat you are a great TEACHER. God bless you!!!