courses take place here
Open Source Training: (gleicher Kurs auf deutsch)

MySQL advanced

MySQL for advanced DBA's

MySQL/MariaDB is easily and quick to install. But what then? The amount of data grows, the database becomes business-critical...

In this course you will learn the different kinds of how to install MySQL/MariaDB, tricks for creating tables, querying or changing data and many other interesting useful commands.

Setting-up a database is one thing. But operations of a database is another thing. We will discuss the user privileges and the security concept of MySQL/MariaDB an look at the further steps which are necessary to operate a MySQL/MariaDB database.

Everybody has a backup and who thinks about the restore? You will learn what is important for backup and restore and what possibilities you have with MySQL.

Further the performance tuning is an important task. For most of the MySQL/MariaDB users it has the highest priority. You will learn a systematical way to find and solve MySQL/MariaDB performance problems.


5 days, 2,468.00 € + 16% vat = 2,862.88 €

Full eight clock hours per day, complete set of literature, WiFi, complimentary notebook, full board, drinks (selected wines are charged separately), pastries, homemade cakes, sauna, social program

Extended/reduced amenities on demand:

Surcharge per guest night in two bed rooms (spacious and comfortable rooms) 59.00 € + 5% vat = 61.95 €per night
Surcharge per guest night in the Linuxhotel-flat share 83.00 € + 5% vat = 87.15 €per night
Surcharge per guest night in single rooms (depending on availabity, early reservation recommended) 129.00 € + 5% vat = 135.45 €per night
Reduction for half board instead of full board accomodation -29.00 € + 16% vat = -33.64 €per day
Reduction w/o social program -8.00 € + 16% vat = -9.28 €per evening

Tax deductibility * Terms of cancellation


Please select your favourite reservation date


Oli Sennhauser was for 3 years working as consultant for the company MySQL. Now he is independent MySQL/MariaDB consultant for his own customers.

Thanks to his countless assignments he is very familiar with the matter. The learnings at his customers he passes later on to the next customers. Of course he incorporates all his collected know-how into this course.

prerequisites for attending

The participants should be used in using the Linux console and cope with the most important UNIX commands.

Further the participants should be already familiar with MySQL/MariaDB and the SQL language. For this please have a look at the contents of the courses MySQL/MariaDB and SQL.

If you feel uncertain on this point, we look forward to assist you via email or phone * (call +49-201 8536-600 on weekdays between 9-17 hours to reach Martin Gerwinski or Laura Trinowitz) .

Course contents

Backup, restore, recovery

Master/slave and master/master replikation

Synchronous multi-master replikation with Galera Cluster for MySQL/MariaDB


System configuration



Course schedule

Diese Webseite verwendet Cookies, um Inhalte und Dienste bereitzustellen. Mit der Nutzung erklären Sie sich damit einverstanden, dass wir Cookies verwenden.    weitere Infos