Capturing Logic with Stored Procedures in MariaDB

by Pinal Dave

In this course, you’ll get started with Maria DB stored procedures, look into complex business logic inside stored procedures, and learn how to efficiently shape data per business requirements.

What you'll learn

Stored Procedures are very powerful for retrieving or updating data from tables, which is one of the most important routines for DBAs and developers when dealing with set-based operations.

In this course, Capturing Logic with Stored Procedures in MariaDB, you’ll gain the ability to work with complex business logic inside stored procedures.

First, you’ll learn how to create stored procedures.

Next, you’ll discover how to use various different parameters in stored procedures.

Finally, you’ll explore how to work with multiple stored procedures together and return various different information from the stored procedures.

When you’re finished with this course, you’ll have the skills and knowledge of stored procedures needed to work with complex business logic.

Software required: MariaDB

About the author

Pinal Dave is a SQL Server Performance Tuning Expert and an independent consultant. He has authored 11 SQL Server database books, 25 Pluralsight courses and has written over 5000 articles on the database technology on his blog at a https://blog.sqlauthority.com. Along with 16+ years of hands-on experience, he holds a Masters of Science degree and a number of database certifications.

Ready to upskill? Get started