Get a Quote
Course Enquiry
Contact Us

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:

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  
Mon 10 Jul 2017 2 Days
Thu 20 Jul 2017 2 Days Book Now
Thu 10 Aug 2017 2 Days Book Now
Thu 21 Sep 2017 2 Days Book Now
Thu 16 Nov 2017 2 Days Book Now
Thu 22 Feb 2018 2 Days Book Now
Thu 15 Mar 2018 2 Days Book Now