Learn to use SQL Views, Stored Procedures, and Triggers. Build real-world skills with hands-on practice, and run SQL queries directly in your browser.

Become a Database Professional with SQL

This module guides you through key concepts like Views, Stored Procedures, and Triggers. You'll learn to create, update, and manage views. Next, you'll explore stored procedures—covering variables, parameters, loops, conditionals, cursors, and error handling with SIGNAL and RESIGNAL. You'll also explore stored functions. Finally, you’ll master triggers for INSERT, UPDATE, and DELETE operations, including handling multiple triggers. You'll practice SQL directly in your browser and gain real-world skills through hands-on tasks.

SQL Views, Stored Procedures and Triggers

# Stored Procedures
Procedures are a simple way to save queries for later access. A stored procedure can be defined as a set of SQL statements stored in the MySQL server. For example a __SELECT__ statement that returns all the male actors can be turned into a stored procedure. A stored procedure an be invoked using __CALL__ statement which executes the query and returns the result.

When the stored procedures are called, MySQL compiles the code of the procedure and stores it in the cache. Then the code is executed. Any subsequent calls to the same stored procedure result in execution of the previously compiled code.

Just like functions, we can pass parameters to stored procedures. Stored procedures have conditional statements and loops, and can call other stored procedures.

There are several advantages of using stored procedures. They reduce the traffic between applications and server because instead of sending queries, only the name of the stored procedure is sent to the server. Since a stored procedure can be called by other procedures, it reduces the duplication of code. Performance gains are also achieved by using store procedures because the code can be pre-compiled instead of parsing the query every time. Stored procedures can be used for security by giving users access to certain procedures without giving access to the tables.


This lesson presents an introduction to stored procedures and reviews their advantages and drawbacks.

What are Stored Procedures?

Stored Procedures