Course/Module 9/Topic 3 of 3Advanced

Stored Procedures & Functions - Practice

Put your stored procedures & functions skills to the test with practical exercises and challenges.

50 min•By Priygop Team•Last updated: Feb 2026

Hands-On Practice

Practice makes perfect! In this section, you'll work through practical exercises that reinforce the concepts covered in this module.

Exercises

Exercise 1: Apply basic stored procedures & functions concepts
Exercise 2: Solve intermediate-level challenges
Exercise 3: Build a mini-project using stored procedures & functions
Exercise 4: Debug and fix common issues

Practice: Stored Procedures & Functions

Practice: Stored Procedures & FunctionsJavaScript⚠ 1 error

⚠ Syntax Issues (1)

Line 1: JS Error: Unexpected identifier 'a'

💡 Check syntax near the highlighted line.

JavaScript Editor

✕ 1 errorTab = 2 spaces

-- Create a simple function
CREATE FUNCTION calculate_tax(price DECIMAL, tax_rate DECIMAL DEFAULT 0.08)
RETURNS DECIMAL AS $$
BEGIN
  RETURN ROUND(price * (1 + tax_rate), 2);
END;
$$ LANGUAGE plpgsql;

-- Use the function
SELECT 
  product_name,
  price,
  calculate_tax(price) AS price_with_tax
FROM products;

Result

Click ▶ Run to see the result

Edit the code on the left, then click Run

JavaScript|14 lines|310 chars|1 error, 0 warnings

UTF-8

Review Quiz

Next Module →

Chat on WhatsAppPriygop - Leading Professional Development Platform | Expert Courses & Interview Prep