Explain First Second and Third Normal forms in SQL Server | SQL Server Interview Questions & ANswers

Поделиться
HTML-код
  • Опубликовано: 24 дек 2024

Комментарии • 87

  • @questpondvideos
    @questpondvideos  3 года назад

    20+ SQL Server Interview Questions : ruclips.net/video/SEdAF8mSKS4/видео.html
    20 MSBI Interview Questions : ruclips.net/video/Nw_sHEKnOUE/видео.html
    10+ Power BI Interview Questions : ruclips.net/video/Cozc9WNBRt4/видео.html
    SQL Server Joins : ruclips.net/video/KTvYHEntvn8/видео.html
    SQL Step by Step - ruclips.net/video/uGlfP9o7kmY/видео.html
    Software Architecture Interview Questions : ruclips.net/video/AtTgcbLOqMM/видео.html
    Angular Step by Step Tutorial for Beginners : ruclips.net/video/-9VcW7MBDs8/видео.html
    25 Angular Interview Questions : ruclips.net/video/-jeoyDJDsSM/видео.html
    35 Important JavaScript Interview Questions : ruclips.net/video/Zb4dPi7CANU/видео.html
    30 Important C# Interview Questions : ruclips.net/video/BKynEBPqiIM/видео.html
    25+ OOPS Interview Questions : ruclips.net/video/u99wAoBjDvQ/видео.html
    25 Important ASP.NET Interview Questions : ruclips.net/video/pXmMdmJUC0g/видео.html
    20 PHP Interview Questions : ruclips.net/video/1bpNSynUrl8/видео.html
    5 MSBI Interview Questions : ruclips.net/video/5E815aXAwYQ/видео.html
    20 MySQL Interview Questions : ruclips.net/video/9hfjC-BpY20/видео.html

  • @akshaychavan5457
    @akshaychavan5457 7 лет назад +15

    Anyone who has less time or just needs a quick revision, go to 32:45

  • @Kalika1972
    @Kalika1972 3 года назад +1

    Best Combination video of theory and practical
    Of normalisation

  • @donathon680
    @donathon680 8 лет назад

    First Indian guy I enjoyed listening to. GJ man

  • @lilungwesezuni5029
    @lilungwesezuni5029 11 лет назад

    Wow this guy is very good at it. Practice makes perfect...

  • @tejasurubhotla
    @tejasurubhotla 11 лет назад

    Very neat & wonderful explanation . Very easy to understand. Thank you sir.

  • @tamilcracker009
    @tamilcracker009 12 лет назад

    That was really helpful, you've explained everything in details. Thank you so much. My deadline for this module is tomorrow :)

  • @chigicherla007
    @chigicherla007 11 лет назад

    Very nice video Shiv Sir ..... Thanks for posting video.....

  • @nnbb69
    @nnbb69 2 года назад

    Thank you sir,now i understand the concept clearly.

  • @qwert5432110
    @qwert5432110 12 лет назад

    really nice to learn.. and i learnt.. thanks buddy

  • @visrom2
    @visrom2 9 лет назад +2

    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?

    • @questpondvideos
      @questpondvideos  9 лет назад

      +visrom2 Mail us your technical query at questpond@questpond.com

    • @1982dpw
      @1982dpw 7 лет назад

      visrom2 yes I was thinking the same, also would it not be best to have a separate table for students?

  • @dnlgrhm
    @dnlgrhm 8 лет назад +1

    Is the Id column in tbl_SyllabusSubject needed? It seems that the primary key could instead be (SyllabusId, SubjectId).
    Wonderful tutorial! Thanks very much.

  • @kaltippi1
    @kaltippi1 11 лет назад +1

    Thank you so much.. Great video on normalization

  • @dhanushantbishnoi
    @dhanushantbishnoi 5 лет назад +1

    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

  • @dailylifeayurveda5420
    @dailylifeayurveda5420 9 лет назад +3

    excellent explanation.
    taught such a difficult concept in much easier way.
    keep up the good work :)

  • @chigicherla007
    @chigicherla007 11 лет назад

    Nice Explanation Sir,,,,,,,
    Thanks for posting.....

  • @satishnagotkar886
    @satishnagotkar886 7 лет назад

    Sir - You have explained this well 1NF, 2NF, 3NF

  • @TheArul1989
    @TheArul1989 11 лет назад

    ur explanation is awesome !!!

  • @srimaheshs1371
    @srimaheshs1371 10 лет назад

    I seen good no books, does not clear explanation, this tutorial gives great clarity over the subject..

  • @kollurisantosh
    @kollurisantosh 12 лет назад

    Great Video.Really Appreciate your work & time.Keep Posting.Thank you very much..!!

  • @mmmathur06
    @mmmathur06 5 лет назад

    Very informative and well explained

  • @abdulghaffar9569
    @abdulghaffar9569 9 лет назад

    very good tutorial keep it countinou...............

  • @MrGMVK
    @MrGMVK 10 лет назад

    Very good video to understand 3 Normal Forms.
    Appreciate your effort.
    Thank you

  • @duminda99
    @duminda99 12 лет назад

    Nice video explains really well.

  • @gangadharkaratlapally708
    @gangadharkaratlapally708 3 года назад

    Sir, Please let me know which editor your using, I mean SQL Editor.

  • @santoshsinha5428
    @santoshsinha5428 12 лет назад

    very informative. Super like for this video.

  • @spratapakshay
    @spratapakshay 9 лет назад

    very expressive tutorial, great job.

  • @AnujSethi12
    @AnujSethi12 8 лет назад

    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 :)

  • @tapasgaan7371
    @tapasgaan7371 6 лет назад

    Is the ID column which is primary key in tbl_syllabusSubject table is necessary.?

  • @nehadeshmukh5797
    @nehadeshmukh5797 8 лет назад

    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

  • @MegaAakashgupta
    @MegaAakashgupta 3 года назад

    Awesome 👍😊👍😊

  • @sunil5031
    @sunil5031 8 лет назад

    Great video..great explanation..can you please tell me what is the software you are using for these creations..

  • @shakir1234567
    @shakir1234567 12 лет назад

    Good video, thank you for sharing! Take care

  • @amith0tube
    @amith0tube 9 лет назад

    Fantastic tutorial. Thanks a lot

  • @Ninjaviator
    @Ninjaviator 12 лет назад

    Awesome, you explain very well :)

  • @tapasgaan7371
    @tapasgaan7371 6 лет назад

    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

  • @praveenyadam2617
    @praveenyadam2617 10 лет назад

    Superb...nice one.

  • @yaliniiniya1234
    @yaliniiniya1234 7 лет назад

    Best video ever. 👍🏽

  • @ravikelakam
    @ravikelakam 12 лет назад

    Good explanation !

  • @HarshitGupta1990
    @HarshitGupta1990 9 лет назад

    thanks a lot for such a simple explanation..

  • @anukkutt
    @anukkutt 12 лет назад

    How can you make 2 primary keys in a table, since it's a clustered index?

  • @KanchanaRandika
    @KanchanaRandika 10 лет назад

    Nice explanation...Thanks!!

  • @ravimishra8564
    @ravimishra8564 4 года назад

    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!!

  • @Aabidkhursheed
    @Aabidkhursheed 11 лет назад

    Good Explaination.......

  • @yassine_t
    @yassine_t 10 лет назад

    very good video !simple but very informative. It helped me understand the tree forms of normalization ! ^^

  • @rsetty33
    @rsetty33 10 лет назад

    nice... comments from bangalore

  • @afzaalawan
    @afzaalawan 3 года назад

    Excellent

  • @farhanbajrai
    @farhanbajrai 9 лет назад

    Thanks a Lot. It help me very much to understand this.

  • @mikek830
    @mikek830 10 лет назад

    Please, Can u teach me how to create stored procedure?

  • @shaheenshaikh6701
    @shaheenshaikh6701 5 лет назад

    Why not the syllabussubject table is joined with tbl_standard table

  • @KannadatechieKA28
    @KannadatechieKA28 8 лет назад

    which software you are using sir??

  • @rajeshroushan1466
    @rajeshroushan1466 11 лет назад

    nice presentation thanks a lot

  • @pranavchaudhary1
    @pranavchaudhary1 10 лет назад

    explained very nicely..:)

  • @jeremylongyi5649
    @jeremylongyi5649 9 лет назад

    it is very good, thank you

  • @prabhugade
    @prabhugade 12 лет назад

    nice explanation thank you

  • @Sonny0276
    @Sonny0276 7 лет назад

    Great Video. Thank you for posting.

  • @PratibhaVenkat
    @PratibhaVenkat 12 лет назад

    great video. thanks sir

  • @samzengineer9066
    @samzengineer9066 10 лет назад

    Thank you very much. Great Video!

  • @dipakshaw6247
    @dipakshaw6247 11 лет назад

    its great,,,very helpful,,,,thank you!!!

  • @psid369
    @psid369 12 лет назад

    Good job!

  • @amitpatil-pk1px
    @amitpatil-pk1px 9 лет назад

    Great job,
    Thanks a lot...

  • @josephukraine
    @josephukraine 10 лет назад

    Thank You Very Much.

  • @shrawanzadoo
    @shrawanzadoo 12 лет назад

    Good video ! thanks !

  • @zayeemmohammad5882
    @zayeemmohammad5882 7 лет назад

    Sir! I have a doubt, how there can be two primary key in a single table?
    Fabulous explanations ☺

    • @c.michaelfisher1123
      @c.michaelfisher1123 2 года назад

      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.

  • @avinashkarthik9340
    @avinashkarthik9340 11 лет назад

    Thank you for the Video...

  • @smitchaudhary6645
    @smitchaudhary6645 9 лет назад

    good tutorial..thank you!

  • @phillipcarerros4971
    @phillipcarerros4971 11 лет назад

    Thank you, very helpful

  • @venkugubba
    @venkugubba 9 лет назад

    can you please explain BCNF and 4NF

  • @guruprasadgaikwad6504
    @guruprasadgaikwad6504 10 лет назад

    SUPER .. NICE EXPLANATION. :)

  • @gunasekhar2749
    @gunasekhar2749 11 лет назад

    Nice vedio

  • @easy1965
    @easy1965 12 лет назад

    good stuff thank you

  • @RahulKumar-vr4cm
    @RahulKumar-vr4cm 6 лет назад

    Thanks.

  • @sandeepdesai7264
    @sandeepdesai7264 9 лет назад

    awsome .................

  • @giojoni8135
    @giojoni8135 10 лет назад

    great !

  • @amitkapoor6959
    @amitkapoor6959 10 лет назад

    great

  • @mfonsos
    @mfonsos 10 лет назад

    nice!

  • @KalyanS
    @KalyanS 5 лет назад

    hi

  • @silverswan8
    @silverswan8 10 лет назад +1

    Couldn't understand Indian English.....:(((((

    • @LazyYoutuberVJ
      @LazyYoutuberVJ 10 лет назад +1

      it means u don't know about english or u dont know english..Indians speak good english then any other

  • @dhanushantbishnoi
    @dhanushantbishnoi 5 лет назад

    thank you, sir, for such a detailed video with amazing examples

  • @decemberswitch
    @decemberswitch 9 лет назад

    very good tutorial thank you