✅ Stored Procedures 💯

🧠 1. What is a Stored Procedure?
A Stored Procedure is a saved SQL program
• Stored inside the database
• Can be executed anytime

Think like this 👇
“Reusable SQL code block”

⚡ 2. Why Use Stored Procedures?
• Reuse SQL logic
• Reduce repeated code
• Better security
• Faster execution for repeated tasks

⚡ 3. Basic Syntax

👉 MySQL Example:
DELIMITER //

CREATE PROCEDURE GetEmployees()
BEGIN
SELECT * FROM employees;
END //

DELIMITER ;

▶️ 4. Execute Stored Procedure
CALL GetEmployees();

🔥 5. Procedure with Parameter
DELIMITER //

CREATE PROCEDURE GetDeptEmployees(IN dept_name VARCHAR(50))
BEGIN
SELECT * FROM employees
WHERE department = dept_name;
END //

DELIMITER ;

▶️ 6. Execute Parameterized Procedure
CALL GetDeptEmployees('IT');

❌ 7. Drop Stored Procedure
DROP PROCEDURE GetEmployees;

🎯 8. Real Example
Increase salary for all IT employees:

DELIMITER //

CREATE PROCEDURE IncreaseSalary()
BEGIN
UPDATE employees
SET salary = salary + 5000
WHERE department = 'IT';
END //

DELIMITER ;

🎯 9. Practice Tasks
1. Create procedure to show all employees
2. Create procedure for HR employees
3. Create procedure with salary parameter
4. Execute stored procedure
5. Drop procedure

⚡ Mini Challenge 🔥

Create procedure to return employees with salary > given value

✅ Solution

DELIMITER //

CREATE PROCEDURE GetHighSalaryEmployees(IN min_salary INT)
BEGIN
SELECT *
FROM employees
WHERE salary > min_salary;
END //

DELIMITER ;

▶️ Execute Procedure

CALL GetHighSalaryEmployees(50000);

✔ Returns employees earning more than 50k

Key Difference:
• Function → returns value
• Procedure → performs action / multiple operations

Double Tap ❤️ For More