Training Course:MySQL Database AdministrationSchool/Trainer:NobleProg
London, United Kingdom
Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced
Course Description:
'' 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.
Training course outline
MySQL Server Files and Scripts
MySQL Programs
Extended MySQL Server (mysqld-max)
mysqld_safe, mysql.server
mysqld_multi
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
...''
Please go to the school's official website for training price and schedule:
http://www.nobleprog.co.uk/
Phone:+44 7929 173 122
School Address:
13 New North Street
London WC1N 3PJ, UK
Jobs & Resumes: London
Houses & Roommates: London
Other training courses offered by NobleProg:
Drupal 5.x Optimization
Drupal Category
Drupal for Developers
Drupal Installation and Configuration
CSS
Sun Certified Java Programmer (SCJP)
Linux Installation and Configuration
Linux Networking
Linux System Administration
AndroMDA
MySQL Introduction
Oracle 10g XE Administration
SQL
UML
Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
Tips:
Schools can use this unlimited free web marketing service by submitting their course descriptions and school introductions. Two outbound links will be granted to each posting. |
|
| 
