Codice del corso
mysqladm
Durata
14 ore (generalmente 2 giorni pause incluse)
Requisiti
Fundamental knowledge of any database and SQL language.
Overview
My SQL corso di formazione sulla gestione di My SQL è rivolto a chiunque desideri amministrare il server di database My SQL . È un corso completo che copre tutti i compiti di amministratore.
Il corso spiega come My SQL Database funziona, quali strumenti sono disponibili, come possiamo utilizzare, come si possono proteggere il My SQL Database Server e configurarlo. Durante il corso di formazione imparerai come gestire gli account utente e come funziona il sistema di privilegi My SQL Access . Imparerai anche come mantenere il tuo database, eseguire il backup e ripristinare i tuoi database ed eseguire il ripristino di emergenza.
Machine Translated
Struttura del corso
MySQL Server Files and Scripts
- MySQL Programs
- MySQL Server
- MySQL Client
- GUI Tools
MySQL Server Configuration
- mysqld Options
- The Server SQL Mode
- Server System Variables
- Dynamic System Variables
- Server Status Variables
- Shutdown Process
MySQL Security Issues
- Securing MySQL Against Attacks
- Security-Related mysqld Options
- Security Issues with LOAD DATA LOCAL
MySQL Access Privilege System
- MySQL Privilege System Overview
- Privileges Provided by MySQL
- Connecting to the MySQL Server - Stages
- Access Control, Stage 1: Connection Verification
- Access Control, Stage 2: Request Verification
- Access Denied Errors
MySQL User Account Management
- Users and Passwords
- Creating New Users
- Deleting User Accounts
- Limiting User Resources
- Changing Passwords
MySQL Database Maintenance
- Backup and Recovery
- Point-in-Time Recovery
- Maintenance and Crash Recovery
- myisamchk Syntax and Options
- Getting Table Information
- MySQL Local Setting
- National Characters and Sorting
- MySQL Server Time Zone
MySQL Log Files
- Error Log
- General Query Log
- Update Log
- Binary Log
- Slow Query Log
- Log File Maintenance and Rotation
Running Multiple MySQL Servers on the Same Machine
- Running Multiple Servers in Windows
- Running Multiple Servers in Windows as Services
- Running Multiple Servers in Unix and Linux
- Using Client Tools in a Multi-Server Environment
Recensioni
Categorie relative
Corsi relativi
Corsi scontati
I nostri clienti
















.png)


.jpg)
.png)





























is growing fast!
We are looking to expand our presence in Italy!
As a Business Development Manager you will:
- expand business in Italy
- recruit local talent (sales, agents, trainers, consultants)
- recruit local trainers and consultants
We offer:
- Artificial Intelligence and Big Data systems to support your local operation
- high-tech automation
- continuously upgraded course catalogue and content
- good fun in international team
If you are interested in running a high-tech, high-quality training and consulting business.
Apply now!