Take this
course

Test Prep / Software Exams

SQL Server 2012 (70-464): Data Manipulation via Triggers

You would normally think that data can be managed or manipulated using only the data definition and data manipulation statements, but SQL Server provides a few more options. In this course you will be learning about the different options that SQL Server provides for manipulating data with triggers. Learn about when you should use constraints and when they should use triggers. This course will include demos on several of the concepts that will be discussed.

Description

You would normally think that data can be managed or manipulated using only the data definition and data manipulation statements, but SQL Server provides a few more options. In our course, Data Manipulation via Triggers, the student will be learning about the different options that SQL Server provides for manipulating data with triggers. This course will teach the students about when they should use constraints and when they should use triggers. This course will include demos on several of the concepts that will be discussed. These will offer the student a real world example of these concepts in action.


Topics Covered Include:
-Designing DML Triggers
-Implementation of DML Triggers
-Advanced Concepts in DML Triggers

Full details

Curriculum

  • Course Orientation
    Course Orientation
    1:54
    Data Manipulation via Triggers: Supplemental Materials
    "Take advantage of all our extra downloadable supplemental materials. This .zip file includes PDF versions of our Script, PPT Slides, Quiz Questions, and vocabulary tools to better enhance your understanding for this ""SQL Server 2012 (70-464): Data Manipulation via Triggers"" Course."
  • Designing DML Triggers
    Introduction
    0:47
    Introduction to DML Triggers
    1:57
    Firing DML Triggers
    3:06
    Designing DML Triggers
    2:59
    Virtual Tables
    1:05
    Virtual Tables in Triggers
    1:36
    Returning Rowsets
    1:08
    Trigger Considerations
    1:51
    Knowledge Check
    0:34
  • Implementation of DML Triggers
    AFTER INSERT Triggers
    2:11
    SHOW ME Demonstration: AFTER INSERT Triggers
    1:50
    AFTER DELETE Triggers
    1:16
    SHOW ME Demonstration: Executing AFTER DELETE Triggers
    1:59
    AFTER UPDATE Triggers
    0:59
    SHOW ME Demonstration: AFTER UPDATE Triggers
    2:08
    INSTEAD OF Triggers
    2:13
    SHOW ME Demonstration: INSTEAD OF Triggers
    1:30
    Nested Triggers
    1:17
    Knowledge Check
    0:24
  • Advanced Concepts in DML Triggers
    Recursive Triggers
    1:31
    UPDATE Function
    1:07
    Triggers' Firing Order
    1:17
    Alternatives to Triggers
    1:48
    SHOW ME Demonstration: Replacing Triggers with Computed Columns
    1:45
    Best Practices
    1:26
    Knowledge Check
    0:32
    Conclusion
    1:42

Skills

  • Database Management System (DBMS)
  • Database Management
  • SQL Server

Similar Courses

More Courses by this Instructor