Company: Pluralsight Author: Ryan Booz Full Title: Programming SQL Server Database Triggers And Functions Year: 2019 Language: English Genre: Educational: Databases Skill Level: Intermediate Price: - - Files: MP4 (+ Exercise Files, Slides .PDF) Time: 03:20:07 Video: AVC, 1280 x 720 (1.778) at 30.000 fps, 350 kbps Audio: AAC at 96 Kbps, 2 channels, 48.0 KHz 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. 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. Lessons: 1. Course Overview 01. Course Overview 2. Validating and Modifying Data with DML Triggers 02. Overview 03. What Is a DML Trigger? 04. Understanding AFTER vs. INSTEAD OF Triggers 05. Understanding the anatomy of DML Triggers 06. Utilizing the INSERTED and DELETED Virtual Tables 07. Common Use Cases for DML Triggers 08. Using INSERT AFTER Triggers 09. Demo: Creating an AFTER INSERT Trigger 10. Using INSTEAD OF Triggers 11. Demo: Creating an INSTEAD OF Trigger 12. Demo: Correcting Bad Data with INSTEAD OF Triggers 13. Demo: Updating Data through a View 14. Using DELETE Triggers 15. Demo: Protecting Data with DELETE Triggers 16. Demo: Creating an Audit Log with DELETE Triggers 17. Reacting to Modified Data in UPDATE Triggers 18. Demo: Logging Changes with UPDATE Triggers 19. Modifying Trigger Execution Order 20. Demo: Setting Trigger Order 21. Demo: Ordering Triggers for Correct Results 22. Review 3. Protecting the Database with DDL and Logon Triggers 23. Overview 24. What Is a DDL Trigger? 25. Understanding the Anatomy of DDL Triggers 26. Examining DDL Trigger Events and Event Groups 27. Common Use Cases for DDL Triggers 28. Using DDL Triggers to Audit Events and Prevent Changes 29. Demo: Preventing Schema Changes with DDL Triggers 30. Demo: Logging Schema Changes with DDL Triggers 31. What Is a LOGON Trigger? 32. Understanding the Anatomy of LOGON Triggers 33. Common Use Cases for LOGON Triggers 34. Demo: Preventing Connections with LOGON Triggers 35. Demo: Logging Authentications with LOGON Triggers 36. Review 4. Working Smarter with Triggers 37. Overview Our members see more. Join us! ------------- Our members see more. Join us!
