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

Are you a MySQL database administrator or do you want to become one? In this training you learn how to set up and maintain a MySQL database system. Lay a good foundation for your work in this training.

Yes, I want to know more

"Clear explanation about the installation and administration of MySQL. Including the possible problems that can arise and how you can solve them. The pace was good. The trainer responded to the wishes/questions of the course participants. Is good at transferring his knowledge to the course participants." - Rating: 9.2

learnit MySQL Administering

MySQL Administering Course

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

Topics

Introduction to MySQL

  • Portability
  • Connectivity

Installing MySQL

  • Licences, versions
  • OS (Windows, Linux)

Tools for management

  • (Win)MySQLAdmin
  • MySQL
  • MySQL Control Center

Databases

  • Types of databases
  • Create new database
  • Type of tables
  • Create, check, repair and delete tables

Security

  • Secure connection
  • Security pyramid
  • Users and rights.

Backup and recovery

  • Disaster strategies
  • Replication:
    • operation of replication
    • Set up master and slave

Tuning

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

Target group

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 material

At the start of the training you will receive a clear book with exercises and practice files. You can also use this as a reference book after the training. The material is modular; each chapter starts with a theoretical part, which each participant goes through at his or her own pace. Hands-on examples are used. Because you are actively working with the theory, it will sink in better. Uncertainties or questions are clarified by the trainer in person. In addition to discussing the assignments, the trainer can provide additional information and answer specific questions, for example from your work situation. In order to guarantee personal attention, we supervise a maximum of eight participants per group.

Prior knowledge

Basic knowledge of SQL is required for this course.

Language

The training is provided in Dutch as standard. The trainer has a good command of the English language. Use can be made of course material in English. With a minimum of three participants, the training can also be provided entirely in English.

Investment

Prices mentioned are per person, including course material. Lunch is included in the on-site training.

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

Certificate

After completion of the training, a Learnit certificate is issued as proof of participation.


Online

We also organise this training online. For this we use Webbex or Zoom. Login with Skype is also possible. On request, this training can also be organised with Microsoft Teams.

The training lasts 6 sessions of 3 hours, spread over 6 weeks.

  • You can participate again free of charge up to one year after the training.
  • For an additional catering fee, you can also participate in a classroom training.

References

The course MySQL Administering has been assessed with an average of 8.

"Clear explanation about the installation and administration of MySQL. Including the possible problems that can arise and how you can solve them. The pace was good. The trainer responded to the wishes/questions of the course participants. Is good at transferring his knowledge to the course participants." - Rating: 9.2

J. Adriaanse, Municipality of Renkum - MySQL Administering