Scheda corso
NovaNext Training / Oracle / MySQL / MySQL for Database Administrators

MySQL for Database Administrators

Codice
NOVOMYS-2
Durata
5 Giorni
Prezzo
3.400,00 € (iva escl.)
Lingua
Italiano
Modalità
Virtual Classroom
Corso in aula
       

 

Schedulazione
Luogo Data Iscrizione
A Richiesta
Virtual Classroom 26/10/2026

 

Prerequisiti

Some experience with Relational Databases and SQL

 

Obiettivi

The MySQL for Database Administrators enables DBAs and other database professionals to maximize their organization's investment in MySQL:

  • Learn to configure the MySQL Server
  • Set up replication and security.
  • Perform database backups and recoveries.
  • Optimize query performance.
  • Configure for high availability.

 

Contenuti

Install the MySQL server and client programs

Upgrade MySQL on a running server

Describe MySQL architecture 

Explain how MySQL processes, stores, and transmits data 

Configure MySQL server and client programs 

Use server logs and other tools to monitor database activity 

Create and manage users and roles 

Protect your data from common security risks 

Troubleshoot server slowdowns and other common problems 

Identify and optimize poorly performing queries 

Define and implement a backup strategy 

Perform physical and logical backups of your data 

Describe MySQL replication and its role in high availability and scalability 

Configure simple and complex replication topologies 

Administer a replication topology 

Configure and administer InnoDB Cluster