Explain First Second and Third Normal forms in SQL Server | SQL Server Interview Questions & ANswers
Вставка
- Опубліковано 6 жов 2024
- Buy full Sql Server course from here www.questpond....
For more such videos visit www.questpond.com
For more such videos subscribe www.youtube.co...
See our other Step by Step video series below :-
For more such videos subscribe / questpondvideos
See our other Step by Step video series below :-
JavaScript Interview Questions: • JavaScript Interview Q...
Learn SQL Server Step by Step tinyurl.com/ja4...
Learn MSBI Step by Step in 32 hours:- goo.gl/TTpFZN
Python Tutorial for Beginners:- • Python Tutorial for Be...
Learn Data Science in 1 hour :- tinyurl.com/y5...
Learn Power BI Step by Step:- tinyurl.com/y6...
PHP Interview Questions : • PHP Interview Question...
C# tutorial for beginners(4 hrs):- • C# Tutorial for Beginn...
Learn Azure Step by Step:- • Azure Tutorial for Beg...
Azure AZ-900 fundamentals certification :- • AZ 900 Certification |...
Angular Interview Questions and Answers :- • Angular Interview Ques...
Learn Angular tutorial step by step tinyurl.com/yc...
Learn MVC 5 step by step in 16 hours:- • Learn ASP.NET MVC 5 ( ...
Learn Design Pattern Step by Step goo.gl/eJdn0m
Learn Tableau step by step :- tinyurl.com/kh...
Preparing for C# / .NET interviews start here • C# Interview Questions...
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 questpond@questpond.com with the shared link and we will email you the PDF.
-----------------------------------------------------------------------------------------------
For more details :-
🌐 Website : www.questpond.com
📱 Mob. No. : +91-9967590707 / +91 7700975156 / +91-22-49786776
📧Email : questpond@questpond.com / questpond@gmail.com / questpond@yahoo.com
Share, Support, Subscribe and Connect us on!!!
UA-cam: / questpondvideos
Twitter: / questpond
Instagram : / questpond
Facebook : / questpond
#SQLServerInterviewQuestions #SQLServerNormalForms #SQLServerCourse #SQLServerTutorial #SQLServerInterviewQuestionsforBeginners #NormalFormsinSQL
20+ SQL Server Interview Questions : ua-cam.com/video/SEdAF8mSKS4/v-deo.html
20 MSBI Interview Questions : ua-cam.com/video/Nw_sHEKnOUE/v-deo.html
10+ Power BI Interview Questions : ua-cam.com/video/Cozc9WNBRt4/v-deo.html
SQL Server Joins : ua-cam.com/video/KTvYHEntvn8/v-deo.html
SQL Step by Step - ua-cam.com/video/uGlfP9o7kmY/v-deo.html
Software Architecture Interview Questions : ua-cam.com/video/AtTgcbLOqMM/v-deo.html
Angular Step by Step Tutorial for Beginners : ua-cam.com/video/-9VcW7MBDs8/v-deo.html
25 Angular Interview Questions : ua-cam.com/video/-jeoyDJDsSM/v-deo.html
35 Important JavaScript Interview Questions : ua-cam.com/video/Zb4dPi7CANU/v-deo.html
30 Important C# Interview Questions : ua-cam.com/video/BKynEBPqiIM/v-deo.html
25+ OOPS Interview Questions : ua-cam.com/video/u99wAoBjDvQ/v-deo.html
25 Important ASP.NET Interview Questions : ua-cam.com/video/pXmMdmJUC0g/v-deo.html
20 PHP Interview Questions : ua-cam.com/video/1bpNSynUrl8/v-deo.html
5 MSBI Interview Questions : ua-cam.com/video/5E815aXAwYQ/v-deo.html
20 MySQL Interview Questions : ua-cam.com/video/9hfjC-BpY20/v-deo.html
Best Combination video of theory and practical
Of normalisation
Anyone who has less time or just needs a quick revision, go to 32:45
That was really helpful, you've explained everything in details. Thank you so much. My deadline for this module is tomorrow :)
Wow this guy is very good at it. Practice makes perfect...
Very neat & wonderful explanation . Very easy to understand. Thank you sir.
I seen good no books, does not clear explanation, this tutorial gives great clarity over the subject..
Thank you so much.. Great video on normalization
First Indian guy I enjoyed listening to. GJ man
excellent explanation.
taught such a difficult concept in much easier way.
keep up the good work :)
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 :)
Very good video to understand 3 Normal Forms.
Appreciate your effort.
Thank you
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 ......@neha
Sir - You have explained this well 1NF, 2NF, 3NF
Thank you sir,now i understand the concept clearly.
Is the Id column in tbl_SyllabusSubject needed? It seems that the primary key could instead be (SyllabusId, SubjectId).
Wonderful tutorial! Thanks very much.
thank you, sir, for such a detailed video with amazing examples
very expressive tutorial, great job.
Very nice video Shiv Sir ..... Thanks for posting video.....
thanks a lot for such a simple explanation..
Very informative and well explained
very good video !simple but very informative. It helped me understand the tree forms of normalization ! ^^
ur explanation is awesome !!!
Great Video.Really Appreciate your work & time.Keep Posting.Thank you very much..!!
really nice to learn.. and i learnt.. thanks buddy
Great video..great explanation..can you please tell me what is the software you are using for these creations..
Nice Explanation Sir,,,,,,,
Thanks for posting.....
Hey bro, you're amazing, Could you please share the link of Star & snow flex schema, in the difference in OLAP & OLTP system you said you will make next video. I'm eagerly waiting for that. Thanks!!
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?
+visrom2 Mail us your technical query at questpond@questpond.com
visrom2 yes I was thinking the same, also would it not be best to have a separate table for students?
Fantastic tutorial. Thanks a lot
Sir! I have a doubt, how there can be two primary key in a single table?
Fabulous explanations ☺
This can happen when you need a "visible" primary key (say for API consumption) and a "hidden" primary key that end-users can't modify. Useful for security a DB.
very good tutorial keep it countinou...............
Thank you very much. Great Video!
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
Great Video. Thank you for posting.
Good video, thank you for sharing! Take care
Nice explanation...Thanks!!
very good tutorial thank you
very informative. Super like for this video.
Nice video explains really well.
Thank You Very Much.
Best video ever. 👍🏽
Awesome, you explain very well :)
Good Explaination.......
it is very good, thank you
its great,,,very helpful,,,,thank you!!!
Thank you for the Video...
Good explanation !
Thank you, very helpful
Great job,
Thanks a lot...
great video. thanks sir
nice presentation thanks a lot
explained very nicely..:)
Excellent
Superb...nice one.
nice... comments from bangalore
good tutorial..thank you!
Is the ID column which is primary key in tbl_syllabusSubject table is necessary.?
Good job!
Good video ! thanks !
Sir, Please let me know which editor your using, I mean SQL Editor.
Thanks.
Awesome 👍😊👍😊
Please, Can u teach me how to create stored procedure?
I have one query after the video, sir if I want to fetch data and the databases are in the form of 3NF format then how I can fetch and use the whole data or a part of data
you need to make joins
@@questpondvideos please elaborate it
How can you make 2 primary keys in a table, since it's a clustered index?
good stuff thank you
awsome .................
great
Nice vedio
can you please explain BCNF and 4NF
which software you are using sir??
Why not the syllabussubject table is joined with tbl_standard table
SUPER .. NICE EXPLANATION. :)
great !
nice!
Couldn't understand Indian English.....:(((((
it means u don't know about english or u dont know english..Indians speak good english then any other
hi
Thanks a Lot. It help me very much to understand this.
nice explanation thank you