Section outline

    • resource icon
      Trigger in Database File

      Lecture Objectives

      • What is DB Trigger?  Trigger Syntax, Explanation of Trigger Syntax, Trigger Example
    • Students must
      Mark as done

      Trigger Content by IJN

      Trigger content-1 by IJN (CLICK HERE)

      Trigger Practice content-1 by IJN (CLICK HERE)

      Trigger Practice content-2 by IJN (CLICK HERE)

    • resource icon
      Store Procedure and View in database File

      Lecture Objectives

      • What is DB Procedure?   Procedure Syntax, Explanation of Procedure Syntax, Procedure Example.
      • What is View? View Syntax, Explanation of View Syntax, View Example.
    • Students must
      Mark as done

      Procedure and View Content by IJN

      Procedure content-1 by IJN (CLICK HERE)

      Procedure Practice content-1 by IJN (CLICK HERE)

      View Practice content-1 by IJN (CLICK HERE)