SQL Interview Preparation – Advanced Level

Question: Triggers

Explore how to create MySQL triggers that detect stock increases and update the LastRestockDate automatically. This lesson guides you through using OLD and NEW row values and conditional logic to automate inventory tracking.

We'll cover the following...

Question
Expected output
Try it yourself
Hints

Field	Type
`ProductID`	`int (Primary Key)`
`ProductName`	`varchar(50)`
`CategoryID`	`int`
`Price`	`decimal(10,2)`
`Stock`	`int`
`LastRestockDate`	`date`
`MonthlySales`	`int`
`InventoryTurnoverRate`	`decimal(5,2)`

1.Get Started

2.Transactions and Execution Control

3.Stored Routines

4.SQL Flow Control and Validation

5.Advanced Database Objects

6.Query Plans and Performance

7.SQL Modes and Permissions

8.Data Import and Export

9.Final Remarks

Question: Triggers

Question