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

Practical course in person or remote class

Ref. MSA
  3d - 21h00
Price : Contact us

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