NOTICE
We are open for classroom training with strict Covid-19 Level 1 protocols in place.
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.
Delivery Methods
| Delivery Method | Duration | Price (excl. VAT) | |
|---|---|---|---|
| Fulltime | 2 Days | R 5,258.00 | |
| Webinar | 2 Days | R 3,698.00 |
Discounts Available
Save up to 10% by booking and paying 10 business days before the course.
Brochure:
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 | Status | |
|---|---|---|---|
| Thu 22 Oct 2020 | Woodmead | Scheduled |