Building and Optimizing Triggers in SQL Server Course

Name: Building and Optimizing Triggers in SQL Server
Rating: 4.809302325581395 (215 reviews)

Building and Optimizing Triggers in SQL Server

IntermediateSkill Level

4.8+

215 reviews

Updated 02/2022

Learn how to design and implement triggers in SQL Server using real-world examples.

Create Your Free Account

By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.

Course Description

Auditing your SQL Server database and keeping data integrity can be a challenging task for DBAs and database developers. SQL Server triggers are special types of stored procedures designed to help you achieve consistency and integrity of your database. This course will teach you how to work with triggers and use them in real-life examples. Specifically, you will learn about the use cases and limitations of triggers and get practice designing and implementing them. You will also learn to optimize triggers to fit your specific needs.

Prerequisites

Intermediate SQL Server

Introduction to Triggers

An introduction to the basic concepts of SQL Server triggers. Create your first trigger using T-SQL code. Learn how triggers are used and what alternatives exist.

Introduction

50 XP

Types of trigger

50 XP

Creating your first trigger

100 XP

Practicing creating triggers

100 XP

How DML triggers are used

50 XP

When to use triggers

50 XP

Creating a trigger to keep track of data changes

100 XP

Trigger alternatives

50 XP

Triggers vs. stored procedures

100 XP

Triggers vs. computed columns

100 XP

Start Chapter

Classification of Triggers

Learn about the different types of SQL Server triggers: AFTER triggers (DML), INSTEAD OF triggers (DML), DDL triggers, and logon triggers.

AFTER triggers (DML)

50 XP

Tracking retired products

100 XP

The TrackRetiredProducts trigger in action

100 XP

Practicing with AFTER triggers

100 XP

INSTEAD OF triggers (DML)

50 XP

Preventing changes to orders

100 XP

PreventOrdersUpdate in action

50 XP

Creating the PreventNewDiscounts trigger

100 XP

DDL triggers

50 XP

Tracking table changes

100 XP

Using FOR in a trigger

50 XP

Preventing table deletion

100 XP

Logon triggers

50 XP

Enhancing database security

100 XP

Defining a logon trigger

50 XP

Start Chapter

Trigger Limitations and Use Cases

Find out known limitations of triggers, as well as common use cases for AFTER triggers (DML), INSTEAD OF triggers (DML) and DDL triggers.

Known limitations of triggers

50 XP

Trigger limitations

50 XP

Creating a report on existing triggers

100 XP

Use cases for AFTER triggers (DML)

50 XP

Keeping a history of row changes

100 XP

Table auditing using triggers

100 XP

Use cases for INSTEAD OF triggers (DML)

50 XP

Preventing changes to Products

100 XP

Checking stock before placing orders

100 XP

Use cases for DDL triggers

50 XP

Database auditing

100 XP

Preventing server changes

100 XP

Start Chapter

Trigger Optimization and Management

Learn to delete and modify triggers. Acquaint yourself with the way trigger management is done. Learn how to investigate problematic triggers in practice.

Deleting and altering triggers

50 XP

Removing unwanted triggers

100 XP

Modifying a trigger's definition

100 XP

Disabling a trigger

100 XP

Re-enabling a disabled trigger

100 XP

Trigger management

50 XP

Managing existing triggers

100 XP

Counting the AFTER triggers

50 XP

Troubleshooting triggers

50 XP

Keeping track of trigger executions

100 XP

Identifying problematic triggers

100 XP

Wrapping up

50 XP

Start Chapter

Building and Optimizing Triggers in SQL Server

Course
Complete

Earn Statement of Accomplishment

Add this credential to your LinkedIn profile, resume, or CV
Share it on social media and in your performance reviewEnroll Now

Don’t just take our word for it

*4.8

from 215 reviews

84%

14%

Sort by

Alexander

2 days ago

Really good course about complex SQL. Good examples and questions.

Kalvin Pierce

5 days ago

One task required counting the After Triggers but was a miscount

Felix

6 days ago

Mark Erickson

last week

AMIT

2 weeks ago

Manicomix

2 weeks ago

"Really good course about complex SQL. Good examples and questions."

Alexander

Felix

Mark Erickson

FAQs

What types of SQL Server triggers does this course cover?

You will learn AFTER triggers, INSTEAD OF triggers, DDL triggers, and logon triggers, covering the full range of trigger types available in SQL Server.

Why would a database developer need to learn about triggers?

Triggers help maintain data integrity and enable auditing in SQL Server databases. They automatically execute stored procedures in response to data changes or database events.

Does this course cover trigger optimization?

Yes. The final chapter focuses on trigger optimization and management, teaching you how to fine-tune triggers to fit your specific performance and functionality needs.

What prior SQL Server experience do I need?

You should complete Introduction to SQL Server and Intermediate SQL Server before starting. No other prerequisites are required for this beginner-level course.

What are the known limitations of triggers that this course addresses?

The third chapter specifically covers known limitations of triggers alongside practical use cases for AFTER triggers, INSTEAD OF triggers, and DDL triggers.

Join over 19 million learners and start Building and Optimizing Triggers in SQL Server today!

Create Your Free Account

By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.

Building and Optimizing Triggers in SQL Server

Create Your Free Account

Training 2 or more people?

Course Description

Prerequisites

Introduction to Triggers

Classification of Triggers

Trigger Limitations and Use Cases

Trigger Optimization and Management

Earn Statement of Accomplishment

Don’t just take our word for it

FAQs

What types of SQL Server triggers does this course cover?

Why would a database developer need to learn about triggers?

Does this course cover trigger optimization?

What prior SQL Server experience do I need?

What are the known limitations of triggers that this course addresses?

Join over 19 million learners and start Building and Optimizing Triggers in SQL Server today!

Create Your Free Account

Grow your data skills with DataCamp for Mobile

Course Description

Earn Statement of Accomplishment

Don’t just take our word for it

FAQs

Why would a database developer need to learn about triggers?

Does this course cover trigger optimization?

What prior SQL Server experience do I need?

What are the known limitations of triggers that this course addresses?

Join over .css-nklxlk{color:var(--wf-brand--main, #03EF62);}19 million learners and start Building and Optimizing Triggers in SQL Server today!

Create Your Free Account

Grow your data skills with DataCamp for Mobile

Join over 19 million learners and start Building and Optimizing Triggers in SQL Server today!