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
Course Overview Hi everyone. My name is Pinal Dave. Welcome to my course, Capturing Logic with Stored Procedures in MariaDB. I'm a SQL performance expert at sqlauthority.com. MariaDB is the world's most widely-used free and open source database. This course gives you a comprehensive view of major components of stored procedures in MariaDB. And this course requires no prior experience with database. Some of the major topics we will cover include getting started with stored procedures, applying parameters in stored procedures, returning information from stored procedure, and, finally, we will sum this all up in the summary module. Many of the modules contain additional learning resources to strengthen the further learning. By the end of this course, you will have a solid foundation to get started with capturing logic with stored procedures. I hope you will join me in this journey to learn MariaDB with the Capturing Logic with Stored Procedures in MariaDB course, at Pluralsight.