workshop

Wenn Sie bereits mit MySQL vertraut sind und nun vor der Herausforderung stehen, eine ernsthafte MySQL Enterprise Infrastruktur zu betreiben, ist diese Schulung die richtige für Sie.

If you are already familiar with MySQL and you are challenged to operate a serious MySQL Enterprise infrastructure this training is the right one for you.

Requirements

You are familiar with the MySQL basics and have already some experience with MySQL operations. The SQL language does not look strange to you any more. Further you are familiar with the Linux console and rule the most important UNIX commands.

FromDual bietet verschiedene MySQL, Galera Cluster und MariaDB Schulungsmodule an. Unsere Schulungstermine finde sie unter MySQL und MariaDB Schulungstermine.

SQL für Einsteiger (3 Tage)

Diese Schulung ist für all diejenigen, welche die Grundlagen der Sprache SQL erlernen wollen. Zukünftige DBAs, Datenbank-Entwickler und Daten-Analysten.

FromDual offers different MySQL, Galera Cluster and MariaDB training modules. For training dates see our MySQL and MariaDB training class schedule.

SQL for Beginners (3 days)

This training is made for all who want to learn the basics of the SQL language. Future DBAs, database developers and data analysts.

You are already familiar with the MySQL or MariaDB and you are challenged to operate a serious MySQL database. If this is the case this training is the right one for you.

Possible exercises during the workshop

• Set-up a Master-Master replication with 2 Slaves
• Load balance on master with MySQL Proxy and on Slaves with LVS.

Workshop topics

• Partitioning
  • Partitioning by time (temporal data)
  • Optimizer and Partitioning
  • Limitations
  • New 5.5 and 5.6 features of Partitioning
• InnoDB Architecture
  • Clustered PK
  • InnoDB Internals
  • InnoDB Online features
  • New Performance Features in 5.5 and 5.6
  • Operations of InnoDB

Workshop topics

• Partitioning
  • Partitioning by time (temporal data)
  • Optimizer and Partitioning
  • Limitations
  • New 5.5 and 5.6 features of Partitioning
• InnoDB Architecture
  • Clustered PK
  • InnoDB Internals
  • InnoDB Online features
  • New Performance Features in 5.5 and 5.6

With a partner we are planning and Advanced MySQL DBA workshop. As the name says it should be a workshop. Its planned duration is 2 days. So within 2 days we can cover 4 to 8 topics more deeply.

Requirements: VirtualBox, VMware, own Laptop?

FromDual bietet Schulungen für MySQL, MySQL Enterprise, Galera Cluster, MariaDB oder Percona Server an.

FromDual offers trainings for MySQL, MySQL Enterprise, Galera Cluster, MariaDB or Percona Server.