Vous avez déjà un compte client ORSYS
Se connecter
Vous êtes nouveau chez ORSYS
Créer un compte
Vous ne souhaitez pas créer de compte
Poursuivre sans me connecter

Course : MySQL, Administration

MySQL, Administration




Instructional goals


INTER
IN-HOUSE
CUSTOM

Training at your location, our location or remotely

Ref. MSA
  3d - 21h00
Would you like to transpose this course—without changes—for your company?

Download in PDF format

Share this course by email




Instructional goals


Teaching objectives
At the end of the training, the participant will be able to:
Installing the MySQL DBMS
Determining the main features of MySQL database administration
Creating and managing a database
Managing access to users
Managing database security.
Participants

Intended audience
Prerequisites

Prerequisites
TRAINING PROGRAM

Course schedule

1
» Introduction and installation

  • Versions and types of licenses.
  • Mysql, mysqlshow, myphpadmin tools.
  • Configuring the server (my.cnf, sql_mode, strict mode, etc.).
  • Starting and stopping.
  • Installations (binary, from source code, etc.).
  • Mysqladmin.
  • Installing MySQL Workbench.
  • Changing versions, migration.
  • Hands-on work ¤Installation in Linux/Windows. Installing MySQL Workbench.

2
» Objects of a MySQL database

  • Types of tables (MyISAM, MEMORY, MERGE, etc.).
  • Changing the definition of a table.
  • Index.
  • View management.
  • The INFORMATION_SCHEMA database.
  • Hands-on work ¤Creating and using views. Changing the definition of a table.

3
» Connections, access rights, security

  • User authentication
  • Structure of "mySQL" database tables.
  • Managing users and their privileges.
  • Rights to views and stored workflows.
  • Using SSL.
  • Hands-on work ¤Complete securing of post-installation. Creating MySQL accounts. Managing privileges and passwords.

4
» Storage engines and plug-ins

  • MyISAM and InnoDB storage engines.
  • Architecture and configuration of InnoDB.
  • Transactional operation of the InnoDB engine.
  • Locking tables.
  • Plug-ins: Configuration and start-up.
  • Hands-on work ¤Changing the InnoDB configuration. Implementing transactions

5
» Maintaining a MySQL server

  • Session status (variables, "show status" command), force-killing a session.
  • Loading: LOAD DATA, myimport, SELECT INTO OUTFILE, mysqldump.
  • Logs (general, errors, slow queries, etc.).
  • Backup strategies.
  • InnoDB Hot Backup, mysqlbinlog.
  • Incremental backup and restore.
  • Scheduling.
  • Hands-on work ¤Activating logs. Using loading/unloading tools. Backup and restore with "mysqldump". Using the binary log