Details
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.
Cost
$459.80 If you are currently resident in South Africa you will need to pay VAT at 15%.Duration:
2 DaysBrochure:
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.
Audience
- MySQL Database administrator
Pre-Requisites
- Excellent computer literacy
- Technically inclined
- SQL Course or Equivalent Knowledge
Course Outline / Curriculum
- 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
Schedule Dates and Booking
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 | Branch | Duration | Status | |
|---|---|---|---|---|
| Thu 24 Jan 2019 | Woodmead | 2 Days | Provisional | |
| Thu 16 May 2019 | Woodmead | 2 Days | Provisional | |
| Thu 11 Jul 2019 | Woodmead | 2 Days | Provisional | |
| Thu 5 Sep 2019 | Woodmead | 2 Days | Provisional | |
| Thu 3 Oct 2019 | Woodmead | 2 Days | Provisional | |
| Thu 28 Nov 2019 | Woodmead | 2 Days | Provisional |