MySQL Training: Stored Procedures and Triggers
Optimization and Advanced Functions in MySQL is a comprehensive program designed to help developers and database administrators maximize the performance of their MySQL systems.
This training covers stored procedure optimization, exploration of more efficient alternatives, and the application of best practices in data management.
Participants will also discover advanced functions for handling text, dates, and numbers, as well as the use of cursors for processing complex data.
By the end of this program, they will be able to improve the efficiency and reliability of MySQL databases in real-world environments.
Updated on
The MySQL Training course at a glance
- Length
- 2 days
- Schedule
- 9:00 a.m. to 4:30 p.m.
- Format
- Live virtual class or in person in Montreal and Quebec City
- Audience
- Tous
- Price
- $919 per participant, or $781 for public bodies and non-profits (plus taxes)
- Language
- English
Doussou Formation and MySQL Training: key facts
- Since 2016Doussou Formation has been delivering professional training in Quebec
- 300+specialized courses in our catalogue
- 97 %satisfaction according to client evaluations
- RAP · CPMTAccredited supplier and recognized training organization
Upcoming MySQL Training sessions
MySQL Training course outline
Introduction
- Overview of MySQL.
Course objectives: optimize stored procedures, explore alternatives, and master advanced data processing functions.
Review of SQL Query Writing
- Write simple and complex SQL queries.
- Use WHERE, GROUP BY, HAVING, and ORDER BY clauses.
- Joins (INNER, LEFT, RIGHT, FULL) to combine tables.
- Use subqueries and nested queries.
Optimization and Alternatives to Stored Procedures
- What is a stored procedure and when to use it?
- Advantages and limitations of stored procedures.
- Optimization techniques: indexing, reducing nested queries, managing transactions.
- Alternatives: materialized views, prepared statements, and application-level solutions.
Best Practices and Data Management in MySQL
- Table structuring, efficient indexing, and performance diagnostics.
- Query optimization: specific SELECTs, pagination, and join techniques.
- Text management: CONCAT(), SUBSTRING(), REPLACE(), cleaning and formatting.
- Number processing: SUM(), AVG(), ROUND(), MOD(), statistical and financial calculations.
Advanced Data Comparison and Manipulation Functions
- Date comparison functions: NOW(), CURDATE(), DATEDIFF(), TIMESTAMPDIFF().
- Combined processing of text and numeric data in MySQL.
- Use of regular expressions for advanced data cleaning.
Using Cursors and Looping Techniques
- Definition, syntax, and usage context of cursors in MySQL.
- Practical examples: iterating through records and performing repetitive operations.
Conclusion and Final Case Study
- Summary of key concepts.
- Integrated case study: implementing optimization, advanced functions, and cursors.
Prices and practical information
Preferred rate
$781 / participant
Public bodies and non-profits · plus taxes
Standard price
$919 / participant
Businesses and individuals · plus taxes
Practical information
- Length: 2 days
- Schedule: 9:00 a.m. to 4:30 p.m.
- Format: Live virtual class or in person in Montreal and Quebec City
- Payment: online (PayPal or card) when registering, or by invoice for organizations
Corporate MySQL Training training
Train your whole team as a private group, on your own documents, at your premises or in a virtual class, on the dates that suit you.
Participant reviews
97% satisfaction (end-of-course evaluations, 120 evaluations) · Read all testimonials
Why take this MySQL Training course
Objectives: what you will be able to do
- Master optimization of stored procedures in MySQL.
- Explore and compare more efficient alternatives to stored procedures.
- Apply best practices for data management and processing in MySQL.
- Effectively use advanced functions for text, dates, and numbers.
What is included
- Course materials and exercise files for each participant
- Certificate of attendance
- Optional personalized coaching after the course
- In public in-person sessions:
- Tea and coffee
- Lunch at a nearby restaurant
- Parking (in some cities)
- Wi-Fi access