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
Author Name: Pinal Dave
Author Description:
Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 22 years of hands-on experience. He holds a Master of Science degree and numerous database certifications. Pinal has authored 14 SQL Server database books and 81 Pluralsight courses. To freely share his knowledge and help others build their expertise, Pinal has also written more than 5,800 database tech articles on his blog at https://blog.sqlauthority.com.

Table of Contents

• Course Overview
  1min
• Getting Started with Stored Procedures
  21mins
• Applying Parameters in Stored Procedures
  19mins
• Returning Information from Stored Procedures
  20mins
• Summary
  6mins