MySQL Training Course

MySQL database administration and design training. Learn how to install MySQL, model and design a database, work with basic SQL, manage users and privileges, how to backup and restore MySQL databases, configure and maintain a MySQL server.

What must I know already to attend the course?

• Excellent computer literacy
• Technically inclined
• SQL Course or Equivalent Knowledge

Who should attend attend the course?

• MySQL Database administrator
• Database Designers

What Will I Learn on this Course?
This course is a package consisting of the following courses:

SQL

This course will teach you all you need to know about SQL from basics to advanced joins.

MySQL Administration

The price for the package is a 10% discount on the sum of all its constituent courses. Booking and paying for the entire package in advance secures the discount.

Cost: R5090.9090909091 excl VAT Duration: 5 days

If you have a query relating to this course, please complete the form below.

Name
Email
Contact Number
Query
Security Code
Verify Code

Table of contents

• Introducing SQL
• Getting started with SQL
• Creating a database table
• Inserting data into tables
• Retrieving data from tables
• Sorting retrieved data
• Simple data filtering
• Complex data filtering
• Generating calculated fields
• Manipulating data
• Grouping table data
• Making complex queries
• Joining database tables
• Reference section

1. Introduction to MySQL
2. 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
3. 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
4. Modeling and Designing Databases
   • How Not to Develop a Database
   • The Database Design Process
   • The Entity Relationship Model
   • Using Tools for Database Design
5. Doing More with MySQL
   • Loading Data from Comma-Delimited Files
   • Writing Data into Comma-Delimited Files
   • The EXPLAIN Statement
6. 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
7. 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
8. 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
9. Configuring and Tuning the Server
   • The MySQL Server Daemon
   • Server Variables
   • Checking Server Settings