MySQL Administration Course Details
Audience:
- MySQL Database administrator
Pre-Requisites:
- Excellent computer literacy
- Technically inclined
- SQL Course or Equivalent Knowledge
Duration:
Price:
$440.00 If you are currently resident in South Africa you will need to pay VAT at 14%. *Discount availablePC Hire:
$66 *Bring a PCNote: 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 | |
|---|---|---|---|
| Mon 30 Oct 2017 | 2 Days | Scheduled | Book Now |
| Thu 23 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 |