Featured resource
pluralsight tech forecast
2025 Tech Forecast

Which technologies will dominate in 2025? And what skills do you need to keep up?

Check it out
Hamburger Icon
  • Course
    • Libraries: If you want this course, consider one of these libraries.
    • Data

Designing Effective DML Triggers in SQL Server

Trigger your learning instincts and find out how to create and test AFTER and INSTEAD OF triggers in SQL Server. This course will teach you how to effectively write and use DML triggers in SQL Server.

Mike McQuillan - Pluralsight course - Designing Effective DML Triggers in SQL Server
by Mike McQuillan

What you'll learn

New to triggers in SQL Server? Not sure where to start? You just might be in the right place!

In this course, Designing Effective DML Triggers in SQL Server, you’ll gain the ability to create, test, and implement SQL Server triggers of all shapes and sizes! Well, some shapes and sizes anyway.
First, you’ll explore how to create triggers, along with some basic testing principles. Next, you’ll discover how to implement logic within triggers, so you know how triggers can help create business rules whenever an insert, delete, or update occurs. Finally, you’ll learn how to use a trigger to perform an action instead of an insert, delete, or update. When you’re finished with this course, you’ll have the skills and knowledge to start implementing triggers using a variety of best practices.

Table of contents

About the author

Mike McQuillan - Pluralsight course - Designing Effective DML Triggers in SQL Server
Mike McQuillan

Mike loves to mess around with data and programming problems, the bigger the better. He’s worked with a variety of companies, helping to build and improve systems of all shapes and sizes.

More Courses by Mike