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
- Licenses, versions
- OS (Windows, Linux)
- Win Mysqladmin
- 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 behavior
- Master and slave set up
- 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.
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.
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.
||6 sessions of three hours
|Price per day, excl. VAT
|Total, incl. VAT
After completing the training, a LEARNIT certificate will be issued as proof of participation.