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.

Topics

Introduction to MySQL

  • Portability
  • Connectivity

Installing MySQL

  • Licenses, versions
  • OS (Windows, Linux)

Management Tools

  • Win Mysqladmin
  • Mysql
  • MySQL Control Center

Databases

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

Security

  • Securing connection
  • Security Pyramid
  • Users and Rights.

Backup and Recovery

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

Tuning

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

Target

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.

Language

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.

Investment

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

Certificate

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


Online

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.

References

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