MySQL Stored Procedures is a full-day training, designed for novice to expert MySQL users. Intended audience includes DBAs, database engineers, analysts and data scientists. Developers can benefit from the training if they plan to work with stored procedures and triggers.
The training covers the necessary skills to implement simple or complex business logic into the database using stored procedures, stored functions, triggers and events. Using JSON for better working with external flows is an important part of the course.
- Overview of stored programs
- Stored procedures and functions
- MariaDB stored aggregate functions
- Parameters and variables
- Control structures
- Error handling
- Passing and returning JSON documents
- Output and debug messages
- Saving status
- Using triggers to validate data, transform data, or apply defaults
- Good and bad practices
- Advantages and disadvantages of stored procedures
Cost and timing
The MySQL Stored Procedures training has a cost of 1,600GBP and its duration is 1 full day.
Strong discounts can be negotiated if your company has more than three attendees.
If the training is not remote and does not take place in London, Europe, the cost of travel and accommodation will be added to the total.
Some knowledge of SQL and basic programming skills are required. The attendees need to know how to write a
SELECT and understand what a loop is, for example.
Attendees are strongly encouraged to bring their laptops with MySQL installed. For exercises and examples, the recommendation is to use mysql or mycli command-line interface. However, any program will work. A code editor is also necessary to write and edit SQL code.
If your company is going to host the course, please be sure that a projector and a whiteboard are in the room.
Request a course
To request a course or ask for more information, please contact me:
+44 7739 427279 (London time)
Or visit the contact page.