Managing MySQL

amk-group
Inhouse

3.300 
zzgl. MwSt.
Möchten Sie den Bildungsanbieter lieber direkt anrufen?
030 -... Mehr ansehen
Möchten Sie sich zu diesem Kurs beraten lassen?
User, die sich für diesen Kurs interessiert haben, interessierten sich auch für...
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.

Erfolge des Zentrums


User, die sich für diesen Kurs interessiert haben, interessierten sich auch für...
Mehr ansehen