Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Duration 14 hours
Course Outline
MySQL Server Components and Scripts
- MySQL Executables
- MySQL Server Engine
- MySQL Client Interfaces
- Graphical User Interface (GUI) Applications
MySQL Server Configuration Management
- mysqld Command-Line Parameters
- Server SQL Operating Mode
- Server-Level System Variables
- Dynamic System Variables
- Server Status Metrics
- Server Termination Procedures
MySQL Security Considerations
- Mitigating Security Threats
- Security-Oriented mysqld Parameters
- Security Implications of LOAD DATA LOCAL
MySQL Access Privilege Framework
- Overview of the Privilege Model
- Privileges Defined in MySQL
- Client Connection Stages
- Access Control Phase 1: Authentication Verification
- Access Control Phase 2: Permission Verification
- Handling Access Denied Exceptions
MySQL User Account Administration
- Users and Credential Management
- Provisioning New Accounts
- Deactivating or Removing User Accounts
- Resource Limitation Policies
- Credential Update Procedures
MySQL Database Maintenance Operations
- Data Backup and Restoration Strategies
- Point-in-Time Restoration Capabilities
- Routine Maintenance and Crash Recovery
- myisamchk Syntax and Parameters
- Retrieving Table Metadata
- Local Configuration Settings
- Character Sets and Collation Standards
- Server Time Zone Configuration
MySQL Logging Mechanisms
- Error Logging
- General Query Logging
- Update Logging
- Binary Transaction Logging
- Slow Query Logging
- Log File Management and Rotation
Deploying Multiple MySQL Server Instances
- Multi-Instance Deployment on Windows
- Running Multiple Instances as Windows Services
- Multi-Instance Deployment on Unix and Linux
- Client Tool Integration in Multi-Server Environments
Requirements
A foundational understanding of database concepts and SQL programming language is required.
Testimonials (7)
The way of explaining
Bogdn Sabau
Course - MySQL Database Administration
Trainer knew what he was doing and the learning materials were perfect.
Zota Andrei
Course - MySQL Database Administration
The training can use relevant examples in your work.
Aisha - Iziko Museums
Course - MySQL Database Administration
practical examples.
Kesh Mulloo - Vodacom
Course - MySQL Database Administration
The exercises done during the training.
Melvin Joseph Manalo - Stolt Tankers BV
Course - MySQL Database Administration
The training exceeded my expectations on what I was hoping to learn.
Ian Matthews - Cision
Course - MySQL Database Administration
I enjoyed the backup and restore and multiple instances.
