You are here

MySQL and MariaDB developer training

You are already a database application developer or on the way there. Now you would like to learn more about, what MySQL and MariaDB features are available which you can use later to build even better applications, to develop more efficiently applications and shorten your time to market.

Requirements

You are already familiar with the SQL language and have already some experience with MySQL or any other relational SQL database system.

Audience

  • Future MySQL application developer
  • MySQL and MariaDB database administrators

Contents

  • Connecting and MySQL-Tools
  • JOIN, UNION, SUBQUERY
  • Transactions
  • Locking
  • Deadlocks
  • Import and export of data
  • Views, Materialized Views, Virtual Columns
  • MySQL Functions
  • Spatial Functions
  • Fulltext search
  • Prepared Statements
  • Variables
  • Stored Routines
  • Stored Functions
  • Triggers
  • Events
  • Compound Statements and Cursor
  • Dynamic SQL
  • Exceptions and error handling
  • Debugging and Logging
  • Profiling
  • User Defined Functions
  • Schema Tuning
  • Query Tuning
  • Software Profiling

Duration

3 days

Booking trainings

Trainings for Germany can be booked on-line here and trainings in Switzerland here.

Advanced trainings