Facebook Page Contact Us Terms and Conditions Gautrain

Fast • Focused • Effective
Leading Training Solutions
IT and Business Skills Courses South Africa

MySQL Administration

TRAINING COURSE

MySQL Administration Course Details

Audience:

MySQL Database administrator

Pre-Requisites:

Excellent computer literacy
Technically inclined
SQL Course or Equivalent Knowledge

Duration:

2 Days

Price:

$440.00 If you are currently resident in South Africa you will need to pay VAT at 14%. *Discount available

PC Hire:

$66 *Bring a PC

Note: information may change without notice.

Download Brochure:

About MySQL Administration

MySQL database administration training. Learn how to install MySQL, manage users and privileges, how to backup and restore MySQL databases, configure and maintain a MySQL server.

Course Outline

Introduction to MySQL
Installing MySQL
- Installation Choices and Platforms
- Using the Command-Line Interface
- Downloading and Verifying Files from the MySQL AB Web Site
- Installing Under Linux
- Installing Under Windows
- Configuring Access to the MySQL Server
Using the MySQL Monitor
- Starting the Monitor
- Style, Case, and Semicolons
- The Monitor Help
- Running the Monitor in Batch Mode
- Loading the Sample Databases
- MySQL Monitor Program Options
- Graphical Clients
Doing More with MySQL
- Loading Data from Comma-Delimited Files
- Writing Data into Comma-Delimited Files
- The EXPLAIN Statement
Managing Users and Privileges
- Understanding Users and Privileges
- Creating and Using New Users
- Privileges
- The GRANT OPTION Privilege
- How Privileges Interact
- Users and Hosts
- Checking Privileges
- Revoking Privileges
- Removing Users
- Understanding and Changing Passwords
- The Default Users
- Devising a User Security Policy
- Managing Privileges with SQL
- Privileges and Performance
- Resetting Forgotten MySQL Passwords
Backups and Recovery
- Dumping a Database as SQL Statements
- Loading Data from an SQL Dump File
- Scheduling Backups
- The Binary Log
- Checking and Repairing Corrupted Tables
- Re-Creating Damaged Grant Tables
Using an Options File
- Configuring Options for the MySQL Monitor
- Structure of the Options File
- Scope of Options
- Search Order for Options Files
- Determining the Options in Effect
Configuring and Tuning the Server
- The MySQL Server Daemon
- Server Variables
- Checking Server Settings

Delivery Method

Instructor Led classroom based training. Scheduled classes are normally held in Woodmead - near to Sandton in Johannesburg, Gauteng, South Africa. Stationary and textbook included. Refreshments, including 2 tea breaks and a cooked meal for lunch are provided for full time courses. Contact hours are between 9am to 4pm.

Scheduled Dates

To apply for a booking, click on the relevant "Book Now" button below.
Note: places are only fully secured once payment has been made.

Start Date	Duration	Status
Thu 21 Sep 2017	2 Days	Scheduled	Book Now
Thu 16 Nov 2017	2 Days	Scheduled	Book Now
Thu 22 Feb 2018	2 Days	Scheduled	Book Now
Thu 15 Mar 2018	2 Days	Scheduled	Book Now