-
Course
- Data
Programming SQL Server Database Triggers and Functions
SQL Server Triggers and Functions can be powerful tools for the DBA. In this course we'll demonstrate best practices, provide solutions to common problems, and identify when Triggers and Functions are the best choice for your requirements.
What you'll learn
As a SQL Server Database Developer, it is often necessary to have business-layer logic that exists within the database to ensure clean, consistent data. Although constraints and foreign key relationships can go a long way to provide the essential relational guarantees, Triggers provide the ability to validate and act on data at the time of modification, while Functions help you provide consistent methods for accessing the data across applications.
In this course, Programming SQL Server Triggers and Functions, you will learn foundational knowledge to better administer and develop efficient, high-performing Triggers and Functions. First, you will learn how to develop DML, DDL, and LOGON Triggers, and how to avoid common mistakes. Next, you will discover the differences between Multi-Statement and Single-Statement functions and how to write the most efficient functions possible. Finally, you will explore some lesser-known features and upcoming improvements in newer versions of SQL Server that can improve your overall experience with Triggers and Functions. When you are finished with this course you will have the skills and knowledge needed to administer and develop efficient, high-performing Triggers and Functions.
Table of contents
- Version Check | 15s
- Overview | 48s
- What Is a DML Trigger? | 2m 2s
- Understanding AFTER vs. INSTEAD OF Triggers | 4m 52s
- Understanding the anatomy of DML Triggers | 5m 26s
- Utilizing the INSERTED and DELETED Virtual Tables | 4m 22s
- Common Use Cases for DML Triggers | 2m 22s
- Using INSERT AFTER Triggers | 1m 1s
- Demo: Creating an AFTER INSERT Trigger | 6m 4s
- Using INSTEAD OF Triggers | 1m 17s
- Demo: Creating an INSTEAD OF Trigger | 3m 11s
- Demo: Correcting Bad Data with INSTEAD OF Triggers | 3m 10s
- Demo: Updating Data through a View | 3m 25s
- Using DELETE Triggers | 1m 3s
- Demo: Protecting Data with DELETE Triggers | 1m 3s
- Demo: Creating an Audit Log with DELETE Triggers | 3m 43s
- Reacting to Modified Data in UPDATE Triggers | 1m 29s
- Demo: Logging Changes with UPDATE Triggers | 3m 42s
- Modifying Trigger Execution Order | 52s
- Demo: Setting Trigger Order | 2m 43s
- Demo: Ordering Triggers for Correct Results | 5m 7s
- Review | 52s
About the author
Ryan loves exploring data and using technology in ways that lead to new discoveries. He’s at the top of his game learning something new about the data platform or teaching others.
More Courses by Ryan