MySQL Database Administration Training Course


Detailed information

Course code:189
Duration:14 Hour
Total hours of lesson:7
Requirements:Fundamental knowledge of any database and SQL language.
Students per class:6

Do you need further information?
Contact the person in charge , free and at no obligation, for information on how to register, enrollment limit, availability and more.

Request information

Course program

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
MySQL Query Cache
The Concept of Query Cache
Testing Query Cache with SELECT
Configuring Query Cache
Checking Query Cache Status and Maintenance

Course location

Search similar to MySQL

Sponsored links