Training: MySQL Stored Procedures

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.

Topics

  • Overview of stored programs
    • Stored procedures and functions
    • MariaDB stored aggregate functions
    • Triggers
    • Events
  • Parameters and variables
  • Control structures
  • Error handling
  • JSON arrays and objects
  • 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.

Requirements

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:

info@federico-razzoli.com
+44 7739 427279 (London time)
Skype: fede.razzoli
Telegram: federico_razzoli

Or visit the contact page.

Related courses