HomeОбразованиеRelated VideosMore From: Questpond

SQL Server :- Can you explain First,Second and Third normal form in SQL server ?

670 ratings | 156895 views
For more such videos visit http://www.questpond.com For more such videos subscribe https://www.youtube.com/questpondvideos?sub_confirmation=1 See our other Step by Step video series below :- Learn SQL Server Step by Step http://tinyurl.com/ja4zmwu Learn MSBI Step by Step in 32 hours:- https://goo.gl/TTpFZN Learn Data Science in 1 hour :- https://tinyurl.com/y5o7qbau Learn angular tutorial step by step https://tinyurl.com/ycd9j895 Learn C# Step by Step https://goo.gl/FNlqn3 Learn Design Pattern Step by Step https://goo.gl/eJdn0m Learn Azure Step by Step :- https://tinyurl.com/y6fmrech Learn Data structures & algorithm https://tinyurl.com/ybx29c5s Learn MVC Core step by step :- http://tinyurl.com/y9jt3wkv Learn ASP.NET MVC 5 step by step :- https://tinyurl.com/y6g69txf Learn Xamarin Mobile Programming Step by Step :- https://goo.gl/WDVFuy Learn SharePoint Step by Step in 8 hours:- https://goo.gl/XQKHeP Learn Tableau step by step :- https://tinyurl.com/kh6ojyo Preparing for C# / .NET interviews start here http://www.youtube.com/watch?v=gaDn-sVLj8Q SQL Server :- Can you explain First,Second and Third normal forms ?. In this video we will see step by step how to implement First,Second and Third normal forms in SQL server. We are also distributing a 100 page Ebook "Sql Server Interview Question and Answers". If you want this ebook please share this video in your facebook/twitter/linkedin account and email us on [email protected] with the shared link and we will email you the PDF.
Html code for embedding videos on your blog
Text Comments (80)
GodOfProgramming (3 years ago)
Most lucid explanation of the RDBMS Normal Forms with real life examples I have ever seen. Thank you!
Kalyan S (26 days ago)
hi
Shaheen Shaikh (27 days ago)
Why not the syllabussubject table is joined with tbl_standard table
manmohan mathur (1 month ago)
Very informative and well explained
Tapas Gaan (1 year ago)
Nyc explanation...but I have one doubt.....can’t we still remove syllabus table...since standard table will be sufficient to build the many-many relation with subject table...because in syllabus table we are just storing 5th syllabus instead of 5th standard...I mean to say logically 5th standard is equal to 5th syllabus
Tapas Gaan (1 year ago)
Is the ID column which is primary key in tbl_syllabusSubject table is necessary.?
Gaurav Deore (1 year ago)
Nice teaching sir...nice work..keep it up😊😊😊
Rahul Kumar (1 year ago)
Thanks.
Zayeem Mohammad (1 year ago)
Sir! I have a doubt, how there can be two primary key in a single table? Fabulous explanations ☺
satish nagotkar (1 year ago)
Sir - You have explained this well 1NF, 2NF, 3NF
Sonny (1 year ago)
Great Video. Thank you for posting.
Yalini Iniya (1 year ago)
Best video ever. 👍🏽
Akshay Chavan (2 years ago)
Anyone who has less time or just needs a quick revision, go to 32:45
Anuj Sethi (2 years ago)
Good and simple examples. Quite descriptive and easy to understand. But you could have reduced this vdo to at least 50% of length. Having insert scripts ready in hand etc would have saved a lot of viewers time. But thanks a lot for the nice explanation :)
sunil sunny (2 years ago)
Great video..great explanation..can you please tell me what is the software you are using for these creations..
Donathon (2 years ago)
First Indian guy I enjoyed listening to. GJ man
Shridhar Patil (2 years ago)
which software you are using sir??
Neha Deshmukh (2 years ago)
Hello sir, You have explained Normalization is very nice manner, You voice and way of explaining the normal forms are quite good, But it will be very nice if you come up with the very basic definition of normalization in with practical example, so that we can understand it well....otherwise the session was excellent...i always use to watch your video lectures.. Thanks.. a lot for it [email protected]
Daniel Graham (3 years ago)
Is the Id column in tbl_SyllabusSubject needed? It seems that the primary key could instead be (SyllabusId, SubjectId). Wonderful tutorial! Thanks very much.
Farhan Bajrai (3 years ago)
Thanks a Lot. It help me very much to understand this.
visrom2 (3 years ago)
Hi, You have explained this well, but I have a question. At 10:14 you are talking about '5th Standard' and 'Fifth standard' being a repeating group. Then you have created a table with the class code 5 and '5th Standard'.  Now, is that really necessary? For all practical purposes the number '5' in the Standard column will suffice isn't it? Is there any need to store '5th Standard' in another table?
1982dpw (2 years ago)
visrom2 yes I was thinking the same, also would it not be best to have a separate table for students?
Questpond (3 years ago)
+visrom2 Mail us your technical query at [email protected]
venkugubba (3 years ago)
can you please explain BCNF and 4NF
kajal teli (3 years ago)
excellent explanation. taught such a difficult concept in much easier way. keep up the good work :)
Sandeep Desai (3 years ago)
awsome .................
amit patil (3 years ago)
Great job, Thanks a lot...
abdul ghaffar (3 years ago)
very good tutorial keep it countinou...............
Akshay Pratap Singh (3 years ago)
very expressive tutorial, great job.
Jase Leow Ds (3 years ago)
very good tutorial thank you
Gopal Baral (3 years ago)
Thanks a lot Koirala sir............
amith0tube (3 years ago)
Fantastic tutorial. Thanks a lot
Calvin Muhammad (4 years ago)
This  is one of  the  best descriptions of normalizing  a database I've come across. Thank you
Harshit Gupta (4 years ago)
thanks a lot for such a simple explanation..
Jeremy Long Yi (4 years ago)
it is very good, thank you
Smit Chaudhary (4 years ago)
good tutorial..thank you!
Yassine_T (4 years ago)
very good video !simple but very informative. It helped me understand the tree forms of normalization ! ^^
praveen yadam (4 years ago)
Superb...nice one.
Kanchana Randika (4 years ago)
Nice explanation...Thanks!!
Amit Kapoor (4 years ago)
great
Smac Zz (4 years ago)
Nice video and very clearly explained in good English. Just curious first and last name are used in examples are Nepalese names i.e. Koirala and Bista. Is the presenter is a Nepali or Indian?.
pranav chaudhary (4 years ago)
explained very nicely..:)
mike k (4 years ago)
Please, Can u teach me how to create stored procedure?
Sri Mahesh S (4 years ago)
I seen good no books, does not clear explanation, this tutorial gives great clarity over the subject..
guruprasad gaikwad (4 years ago)
SUPER .. NICE EXPLANATION. :) 
VamshiKrishna G.M (4 years ago)
Very good video to understand 3 Normal Forms. Appreciate your effort.  Thank you
Mat Fonsos (4 years ago)
nice!
Abadi Weldegebriel (4 years ago)
Thank you very much. Great Video!
Gio joni (4 years ago)
great !
JUDE JOSEPH (5 years ago)
Thank You Very Much.
Shuchen Tian (5 years ago)
Couldn't understand Indian English.....:(((((
Vijay Mehta (4 years ago)
it means u don't know about english or u dont know english..Indians speak good english then any other
Sachin R Shetty (5 years ago)
nice... comments from bangalore
Rajesh Roushan (5 years ago)
nice  presentation thanks a lot
Girish Kaltippi (5 years ago)
Thank you so much.. Great video on normalization
Dipak Shaw (5 years ago)
its great,,,very helpful,,,,thank you!!!
lilungwe Sezuni (5 years ago)
Wow this guy is very good at it. Practice makes perfect...
Phillip Carerros (5 years ago)
Thank you, very helpful
Avinash Karthik (5 years ago)
Thank you for the Video...
Guna Sekhar (5 years ago)
Nice vedio
Aabid Khursheed (5 years ago)
Good Explaination.......
C. Mallikarjuna (5 years ago)
Nice Explanation Sir,,,,,,, Thanks for posting.....
C. Mallikarjuna (5 years ago)
Very nice video Shiv Sir ..... Thanks for posting video.....
Harihara Teja (5 years ago)
Very neat & wonderful explanation . Very easy to understand. Thank you sir.
TheArul1989 (6 years ago)
ur explanation is awesome !!!
nice explanation thank you
Ravikumar Nk (6 years ago)
Good explanation !
Preeti Venkat (6 years ago)
great video. thanks sir
shrawan zadoo (6 years ago)
Good video ! thanks !
shakir1234567 (6 years ago)
Good video, thank you for sharing! Take care
Santosh Kolluri (6 years ago)
Great Video.Really Appreciate your work & time.Keep Posting.Thank you very much..!!
tamilcracker009 (6 years ago)
That was really helpful, you've explained everything in details. Thank you so much. My deadline for this module is tomorrow :)
Anoop Sasidharan (6 years ago)
How can you make 2 primary keys in a table, since it's a clustered index?
psid369 (6 years ago)
Good job!
santosh sinha (6 years ago)
very informative. Super like for this video.
easy1965 (6 years ago)
good stuff thank you
mohan teja (6 years ago)
nice
Selvaraj (6 years ago)
really nice to learn.. and i learnt.. thanks buddy
duminda koattegoda (7 years ago)
Nice video explains really well.
Ninjaviator (7 years ago)
Awesome, you explain very well :)

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.