Autorizácie

  • Oracle
  • ForgeRock
  • symantec
  • gurulabs
Newsletter

Chcete dostávať od nás najnovšie informácie? Pošlite nám svoj email.


Managing MySQL

ID kurzu : MySQL-MNG Trvanie kurzu : 3 dni

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



Vyberte dátum

ID kurzu :
MySQL-MNG

Cena
Na požiadanie

Trvanie kurzu
3 dni

Objednať

Who Can Benefit

Advanced application developers, administrators.

Prerequisites

This course builds on the knowledge as described for the "Using MySQL" course. Experience with MySQL required. :

Skills Gained

At completion of this course, you should be able to:

  • 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.

Details

Products covered MySQL 4.0 and 4.1, Command-line and graphical clients/tools.

Applies to MySQL Version: 4.0, 4.1