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.
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.
Author Name: Mike McQuillan
Author Description:
Mike is a polyglot architect/developer who loves to mess around with data. He runs a consultancy company in the UK, helping organizations to build better systems and databases. Mike is married and has one daughter and two dogs, Dolly and Bertie. They keep his feet warm when he’s working on courses and articles. Mike has written a book on SQL Server and writes regular articles for sqlservercentral.com. He also likes collecting old computers like the Commodore 64 and Sinclair Spectrum. No, he doe… more
Table of Contents
- Course Overview
1min - Introducing and Creating Triggers
19mins - Creating Useful After Triggers
15mins
There are no reviews yet.