Managing MySQL

amk-group
Inhouse

3.300 
zzgl. MwSt.
Möchten Sie den Bildungsanbieter lieber direkt anrufen?
030 -... Mehr ansehen
Vergleichen Sie diesen Kurs mit ähnlichen Kursen
Mehr ansehen

Wichtige informationen

  • Seminar
  • Anfänger
  • Inhouse
  • Dauer:
    3 Tage
Beschreibung

This course covers administration and optimization of MySQL servers and applications.

Wichtige informationen

Häufig gestellte Fragen

· Voraussetzungen

This course builds on the knowledge as described for the Using MySQL course

Experience with MySQL required.

Themenkreis

Seminarziel:

This course covers administration and optimization of MySQL servers and applications.

Zielgruppe:

Advanced application developers, administrators.

Inhalt:

  • Identify the various components of a MySQL Server and their function.


  • Identify and navigate elements in the physical structure of a MySQL Server on disk and in memory.


  • Understand the differences between MySQL RPM, binary and source distributions.


  • Perform a custom installation on Windows or any standard Unix.


  • Assess the various upgrade considerations and perform an upgrade.


  • Know where to find/create configuration files and understand their structure.


  • Set up appropriate logging and interpret log output.


  • Understand the concepts of MySQL security, managing user privileges on different levels.


  • Adequately and properly secure a default MySQL installation.


  • List and describe the different (categories of) storage engines, their specific characteristics, choosing the appropriate type.


  • Administer and maintain MyISAM and InnoDB tables on a live server.


  • Create and restore backups, recovery of MyISAM and InnoDB tables.


  • Understand transactions and concurrency control.


  • Tune server settings for different storage engines and environments.


  • Install and control replication and multiple servers.


  • Describe how the MySQL server optimizes and processes queries, including index usage.


  • Analyse query efficiency utilizing different tools and techniques.


  • Compare different design decisions and work out the optimial solution.


  • Optimize all relevant aspects of the server environment, prioritizing appropriately


Voraussetzung:

This course builds on the knowledge as described for the Using MySQL course

Experience with MySQL required.


Vergleichen Sie diesen Kurs mit ähnlichen Kursen
Mehr ansehen