Triggers and Stored Procedures: A Combined Approach

Focused View

Mike McQuillan

37:09

0 View

1. Course Overview

1. Course Overview.mp4

01:20

2. Using Stored Procedures in Triggers

1. Welcome to the Fantasy Zone.mp4

02:59

2. Deconstructing the Trigger.mp4

03:11

3. Reconstructing the Trigger.mp4

03:02

4. Brave New Trigger World.mp4

05:07

5. Testing, Testing.mp4

04:49

3. Auditing Integrity - Handling Audits and Referential Integrity

1. Multiple Customer Merry Go Round.mp4

02:32

2. A First Trigger Attempt.mp4

03:12

3. Splitting the Trigger.mp4

02:48

4. Creating the Stored Procedure.mp4

03:38

5. A Second Trigger Attempt.mp4

04:31

Description

Want to keep your triggers lean and efficient, whilst centralizing your code? This course will teach you how to use stored procedures to enhance and improve your SQL Server triggers.

What You'll Learn?

Is your trigger code too long? Do you find yourself replicating code in your triggers? Maybe using stored procedures with triggers is the answer! In this course, Triggers and Stored Procedures: A Combined Approach, you’ll gain the ability to integrate stored procedures with triggers. First, you’ll explore how to pass data from triggers into stored procedures, learning how transactions interact between the two. Next, you’ll discover how to implement audit trails within triggers, using stored procedures to handle the auditing. Finally, you’ll learn how stored procedures can be used within triggers to implement referential integrity. When you’re finished with this course, you’ll have the skills and knowledge of triggers and stored procedures needed to create excellent, efficient triggers integrated with world-class stored procedures.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Microsoft SQL

Mike McQuillan

Instructor's Courses

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 doesn't know why he does that either.

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.