• SQL Server training :- When do we apply de-normalization ?(Interview question)
    Articles,  Blog

    SQL Server training :- When do we apply de-normalization ?(Interview question)

    In the previous part of the video we saw the benefits of normalization we also saw how normalization help’s you to avoid redundant data and error data enter into your systems now i am sure that somewhere in your mind the three normal forms have must becomes golden rules for database designing but that hang one there is other side of the story as well we need to understand before we go and apply this normalization as golden rules for database designing in order to understand the other part of the story let us first understand the larger classification of IT systems from the data perspective from the data perspective…

  • 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…

  • 08 common Interview question and answers – Job Interview Skills
    Articles,  Blog

    08 common Interview question and answers – Job Interview Skills

    Hello my name is Niharika. When you apply for a job and your’e called for an interview, there are various questions that are asked and the better prepared you are, the more successful your interview would be. Well, you might have come across various videos online that talk about the most common interview questions and answers. This video would be a little different, because it’s not just about the questions and answers, we are gonna talk. I’m also gonna explain that what exactly the interviewer thinks, when he’s asking certain questions. What exact answers he’s looking at and what are the common mistakes that you usually do. The first most…