Infrastructure at your Service

Homepage » Trainings » MySQL / MariaDB DBA essentials workshop

MySQL / MariaDB DBA essentials workshop

dbi InSite Workshops

You have MySQL/MariaDB databases running on your IT infrastructure and need to acquire the best practices in database administration (DBA) to get the best out of MySQL or MariaDB? You want to know more on MySQL/MariaDB backup and security strategy? In this case, you should try our MySQL/MariaDB essentials for DBAs workshop course. In this two-day training, you will understand the MySQL/MariaDB architecture, acquire the best practices in MySQL/MariaDB DBA, and learn how to safely perform backups and restores.

Training’s dates

On-site/Online On demand
2 days
CHF 1800.- *

Trainers

  • Saïd Mendi
    Saïd Mendi

By booking a dbi services’ InSite workshop, the customer commits to respecting the Sales and Service General Conditions

(*) Prices are to be considered per participant and without VAT

SOUG (Swiss Oracle User Group) The members of the SOUG (Swiss Oracle User Group) benefit from a 5 % reduction.

Training objectives

  • Understand MySQL database architecture and storage engines as well as the differences with MariaDB
  • Install and configure MySQL/MariaDB databases according to the best practices
  • Operate and secure MySQL/MariaDB databases
  • Backup and recover MySQL/MariaDB databases

Topics

  • MySQL semantic structure and the differences to MariaDB
  • MySQL/ MariaDB architecture: files, memory, processes
  • MySQL/MariaDB storage engines
  • MySQL/MariaDB network layer
  • MySQL/MariaDB installation according to the OFA standard
  • Running several MySQL/MariaDB servers in different versions on the same host
  • Starting/stopping MySQL/MariaDB
  • Backup strategies with MySQL/MariaDB
  • Securing MySQL/MariaDB databases
  • Upgrading MySQL/MariaDB databases

Method

  • Presentation with countless practical exercises and trainings
  • Case studies, Live demos, discussions
  • Networking during coffee break, lunch, and apéro on last day (included in price, except for on-site workshop courses)

Target groups

  • Database administrators (DBA), developers, etc.

Language & documentation

  • Workshop training normally held in English; French or German as course language are also possible
  • Documentation: content details, scripts, case study solutions as PDF file (in English)

dbi InSite Workshop on-site/online - request & information

You want dbi services to hold an "on-site" workshop (in your premises) or an online workshop for you ? You have special requirements, e. g. regarding the content, the duration, the date, or the number of participants?
We have good news for you: Our dbi InSite Workshops can be flexibly adapted to your needs! Please just fill in the form below and we will come back to you as soon as possible. You may also use this form to inquire on the future dates of our dbi InSite Workshops.





Please contact me via :

E-mailPhone

Where did you know dbi services ?