Consult our trainings :

Digital
Technologies

Management
Personal Development

Business
Administration

> formation Technologies numériques > formation SGBD > formation MySQL, PostgreSQL et autres SGBD > formation MySQL, administration

MySQL, administration Training

Name: Formation MySQL, administration
SKU: MSA

Stage pratique

Best

Duration : 3 days

Ref : MSA

Price 2020 : 1840 € excl. taxes

Free breaks and lunches

Program
Participants / Prerequisite
Intra/Tailored

Program

Instructional goals

Learning objectives

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

PROGRAM

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

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

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

» 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

» 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. Incremental backup and restore.

PDF

Send

Participants / Prerequisite

» Participants

Prerequisites

» Prerequisite

TRAINING PROGRAM

Intra/Tailored

For how many persons*

Preferred Cities*

Preferred Dates*

Comments

Contact Informations

Gender*

Name*

Surname*

Company*

Establishment

Department*

Address*

City*

Zip code*

Country*

Phone*

Professional email*

By checking this box, I certify that I have read and accepted the conditions for the use of my data regarding the General Data Protection Regulation (GDPR).

You can at any time modify the use of your data and exercise your rights by sending an email to rgpd@orsys.fr

By checking this box, I agree to receive commercial and promotional communications from ORSYS Training*. You can unsubscribe at any time by using the link included in our communications.

Book your place

Click on a session for reserving.

Time schedule

Generally, courses take place from 9:00 to 12:30 and from 14:00 to 17:30.

However, on the first day attendees are welcomed from 8:45, and there is a presentation of the session between 9:15 and 9:30.

The course itself begins at 9:30. For the 4- or 5-day hands-on courses, the sessions finish at 15:30 on the last day