Learnit Training
Course MySQL Administering
  • Small groups
  • Covid-19 safe
  • Experienced teacher
  • Possible online
  • Practical training

Ben je een MySQL database-administrator of wil je dat worden? In deze training leer je een MySQL-databasesysteem opzetten en onderhouden. Leg een goede basis voor je werkzaamheden in deze training.

Yes, I want to know more

"Clear explanation about the installation and management of MySQL. Including the possible problems that can arise, and how you can solve them. Pace was doable. The trainer responded to the wishes/questions of the students. Is good at transferring his knowledge to students." - Review: 9.2

learnit MySQL Administering

Course MySQL Administering

With MySQL, a relational database management system, you can build, query and maintain a database of this system. In our three-day training MySQL Administering you'll get started and you'll learn to lay a good foundation for your work.


Introduction to MySQL

  • Portability
  • Connectivity

Installing MySQL

  • Licenses, versions
  • OS (Windows, Linux)

Management Tools

  • Win Mysqladmin
  • Mysql
  • MySQL Control Center


  • Types of databases
  • Create New Database
  • Type of tables
  • Creating, checking, repairing, and deleting tables


  • Securing connection
  • Security Pyramid
  • Users and Rights.

Backup and Recovery

  • Disaster Strategies
  • Replication:
    • Replication behavior
    • Master and slave set up


  • OS-Tuning
  • Hardware Tuning
  • Database-tuning, indexes, concurrency


This training is suitable for participants who want to set up a MySQL database system and/or are responsible for managing one or more MySQL databases.

Training materials

You will receive a clear book with exercises and practice files at the start of the training. This can also be used as a reference book after the training. The material is modular; Each chapter starts with a theoretical part, which is passed on by each participant in his own temo. It uses hands-on examples. Because you are actively engaged in the theory, it beklijft better. Ambiguities or questions are personally explained by the trainer. In addition to speaking the assignments, the trainer can give additions and answer specific questions, for example from your work situation. To guarantee personal attention, we accompany up to eight participants per group.

Prior knowledge

This training requires basic knowledge of SQL.


The training is provided by default in Dutch. The trainer controls the English language. English course material can be used. When registering at least 3 participants, the training can also be provided entirely in English.


Mentioned prices are per person, including course material. Lunch is included in the training on location.

On location Online
Duration 3 days 6 sessions of three hours
Price per day, excl. VAT € 475,- € 390,-
Total, incl. VAT € 1724,25 € 1415,70


After completing the training, a LEARNIT certificate will be issued as proof of participation.


We also organize this training online. For this we use Webbex or Zoom. Logging in with Skype is also possible. On request this training can also be organized with Microsoft Teams.

Amsterdam Wednesday 29 July 2020, 10:00-17:00

  • Until one year after the training you can participate for free.
  • Against payment of the catering costs you can also participate in a classroom training.


De cursus MySQL Administering is beoordeeld met een gemiddelde van 8.

“Duidelijke uitleg over de installatie en het beheer van MySQL. Inclusief de mogelijke problemen die er kunnen ontstaan, en hoe je die kunt oplossen. Tempo was goed te doen. De trainer speelde in op de wensen/vragen van de cursisten. Is goed in het overdragen van zijn kennis op de cursisten.” - Be­oor­de­ling: 9.2

J. Adriaanse, Gemeente Renkum - MySQL Administering