• Articles

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

    In this video will talk about three important database techniques First normal form Second normal form and Third normal form We have created a simple database called as University Inside the University we have created a very simple table called as tblSchool In this table we have some 7 fields The first field says this student is belong to which Standard The second column says what is the roll number of student The third column says what is the first name, last name and the surname of the student what kind of syllabus the student has taken How much marks has acquired till now The total number of subjects which…

  • Articles

    SQL Server interview training :-What are triggers , inserted and deleted tables ?

    In this video will talk about what exactly are triggers, and in what scenario we should be using them While we do that will talk about two important types of tables one is called as inserted table and the other one is called as deleted table Will talk about two different kinds of triggers i.e called as the Instead of trigger and the After trigger Triggers are logic like stored procedures which can be executed before the updation happens on a table or after the updation happens on a table If you want to execute pre processing or post processing logic after the updation or before the updation you can…