Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

LinkedIn Learning

SQL Server Database Triggers

via LinkedIn Learning

Overview

Learn how to use SQL Server database triggers to automate routine tasks and facilitate a more consistent, reliable, and predictable system.

SQL Server database triggers help database developers automate routine tasks. Triggers wait for an activating event to occur, then immediately respond with preprogrammed operations. This course, from database expert Adam Wilbert, takes a deep dive into leveraging these powerful and flexible components of a SQL Server database. Follow along and learn how to create and deploy different types of triggers, and get hands-on experience using triggers to solve common problems, such as timestamping data changes or collecting information about table events. Adam also helps you manage your database triggers: enabling, disabling, and reordering triggers as necessary. Plus, follow along with a hands-on project in chapter six, which uses triggers to perform tasks automatically in an inventory management system, such as updating inventory when new product is received.

Syllabus

Introduction
  • Automate SQL Server with triggers
  • What you should know
  • Make the most of the exercise files
1. Trigger Fundamentals
  • What are SQL Server triggers?
  • Two triggers types: INSTEAD OF and AFTER
  • Create a trigger to print a message
  • Timestamp a table modification
  • Firing INSTEAD OF triggers
  • Challenge: Create a trigger
  • Solution: Create a trigger
2. Work with Modified Data
  • Read values modified by a trigger
  • Using the inserted logical table
  • Using the deleted logical table
3. Database- and Server-Level Triggers
  • Triggers on CREATE, ALTER, or DROP
  • Rollback database modifications
  • Reading the EVENTDATA() XML
  • Writing data from the EVENTDATA() function
  • Challenge: Create a DDL trigger
  • Solution: Create a DDL trigger
4. Trigger Management
  • View all triggers in a database
  • Enable and disable triggers
  • Disable nested triggers
  • Recursive triggers
  • Reorder trigger execution
5. Project: Managing Inventory
  • Creating triggers to maintain inventory
  • Counting shipments received
  • Subtract items sold
  • Reorder items when low
Conclusion
  • Next steps

Taught by

Adam Wilbert

Related Courses

Reviews

Start your review of SQL Server Database Triggers

Never Stop Learning!

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free