+44 20 7558 8274
MySQL Database Administration
Overview
MySQL Administration training course is for anyone who wants to administrate the MySQL database server. It is a comprehensive course covering all administrator duties.
The course explains how MySQL Database works, what tools are available, how we can use them, how we can secure the MySQL Database Server and configure it. During the training course you will learn how to manage user accounts and how the MySQL Access Privilege System works. You also will learn how to maintain your database, backup and recover your databases and perform crash recovery.
Public course price from just only 585 GBP per person!
Book Public Course Now! >>
Closed, on-site or individual: get quote >>
Too expensive? Tell us your price!
All prices exclude VAT!
Book Public Course Now! >>
Closed, on-site or individual: get quote >>
Too expensive? Tell us your price!
All prices exclude VAT!
Following Courses
No following Courses Found.
Related Training
Training Course Outline
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
Training Course Dates
| Date | Training Outline | Venue | Price | Details | ||
|---|---|---|---|---|---|---|
| 2010-04-19 09:00 - 2010-04-21 17:00 | MySQL Database Administration | North Acton, London | From 585 GBP per person | Check Price! >> | ||
| 2010-06-14 09:00 - 2010-06-16 17:00 | MySQL Database Administration | North Acton, London | From 585 GBP per person | Check Price! >> | ||
| 2010-08-09 09:00 - 2010-08-11 17:00 | MySQL Database Administration | North Acton, London | From 585 GBP per person | Check Price! >> | ||
| 2010-10-04 09:00 - 2010-10-06 17:00 | MySQL Database Administration | North Acton, London | From 585 GBP per person | Check Price! >> | ||
| 2010-11-29 09:00 - 2010-12-01 17:00 | MySQL Database Administration | North Acton, London | From 585 GBP per person | Check Price! >> |
