Writing MySQL User-defined functions: eLearning Course

• Do you need to use functionality from external libraries and applications in your SQL statements?
• Do you need aggregate functions that MySQL does not support natively?
• Do you need to improve performance of your stored SQL functions?
• Do you need to know what has changed in the UDF interface as of MySQL 5.1
• Then the “Writing MySQL User-defined functions” Virtual Course is for you!

This instructor-led course is designed for MySQL users who would like to use User-defined functions. This course provides in-depth information in a “virtual” classroom format that is easily accessible and affordable.

At the completion of this course, you should be able to:

• Understand the key concepts of functions in general
• Know the different kinds of functions in the MySQL database, their differences and similarities
• The advantages and disadvantages of User-defined functions as compared to stored SQL functions
• Understand and use the UDF intereface
• Create UDF implementation functions using the C language
• Compile UDFs into a dynamically loadable library
• Correctly deploy and undeploy a UDF library, including (de)registering the UDFs contained therein
• Understand and predict the calling sequence of UDF implementation functions
• Understand the effect of the optimizer on the calling sequence
• Understand and use UDF dataflow
• Make UDFs return values of various types
• Handle UDF arguments
• Employ error handling to validate arguments and signal error conditions
• Create and use aggregate UDFs

Who should Attend

• This course will be interesting mainly to database Application Developers and DBAs, especially for those that:
• require specialized or domain-specific data processing
• require utmost performance of calculations
• require advanced aggregate or analytical functions.
• are looking for compatibility with other RDBMS-es

Prerequisites

• Basic SQL skills
• Programming Skills in a language such as PHP or Java.
• Basic Knowledge of the C programming language is highly recommended
• Linux, Mac OS/X or Windows operating system
• Linux / Mac OS/X users: The GNU C compiler gcc
• Windows Users:
  • Visual C++ compiler (MS Visual Studio Express or Professional edition)
  • Microsoft Platform SDK

Format

Online access, with synchronous delivery of presentation slides. Instructor led, with interactive performance labs. Each student will be provided with a student guide, including the lab instructions prior to the delivery of the course.

Applies to MySQL Version:

5.1., 5.0

Duration

2 days of 4 hours