Advanced SQL Server Triggers: Optimizing and Troubleshooting

Focused View

32:40

0 View

1. Course Overview

1. Course Overview.mp4

01:25

2. Nested Triggers in SQL Server

1. Implement Nested Triggers.mp4

05:28

2. Control Trigger Recursion.mp4

05:16

3. Optimize Trigger Performance.mp4

05:08

3. Real-world Advanced Trigger Scenarios

1. Real-world Example Using Triggers.mp4

05:36

2. Integrated Flow of Data Processing.mp4

09:47

Description

The use of triggers is a fundamental concept in SQL Server as they provide a powerful way to automatically run complex business logic. This course will teach you to use nested triggers and to improve the performance of your SQL Server code.

What You'll Learn?

Triggers in SQL Server provide powerful and flexible ways to automatically perform a wide range of actions in response to various events within the database system. Understanding when and how to use triggers effectively is crucial for database design and management.

In this course, Advanced SQL Server Triggers: Optimizing and Troubleshooting, you’ll learn to implement nested triggers in SQL Server.

First, you’ll explore the concepts of nested triggers and trigger recursion and how to configure them.

Next, you’ll discover how to optimize performance by writing efficient nested triggers.

Finally, you'll see a real-world example of how nested triggers improve the flow and the performance of data processing.

When you’re finished with this course, you’ll have the skills and knowledge needed to create and use nested triggers to improve the performance of your SQL Server code.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Microsoft SQL

Pluralsight

View courses Pluralsight

Pluralsight, LLC is an American privately held online education company that offers a variety of video training courses for software developers, IT administrators, and creative professionals through its website. Founded in 2004 by Aaron Skonnard, Keith Brown, Fritz Onion, and Bill Williams, the company has its headquarters in Farmington, Utah. As of July 2018, it uses more than 1,400 subject-matter experts as authors, and offers more than 7,000 courses in its catalog. Since first moving its courses online in 2007, the company has expanded, developing a full enterprise platform, and adding skills assessment modules.