I studied computer engineering at Tshwane University of Technology. I then joined a web development company in 1999 where I began my journey in back-end web development. I had to learn to work with several web technologies including HTML, CSS, JavaScript and PHP. Being a back-end developer also meant learning all about databases and how to interact with them using SQL. I also became very familiar with setting up Linux servers for website hosting.
Around 2001 our company moved into instructor led training where I started training mainly corporate companies in all the technologies I had learnt. I joined Leading Training in 2011 with a primary focus on technical training and managing the IT infrastructure. In the last 5 years my main focus has shifted back to my roots of back-end web development. This now involves writing web-based applications to automate business workflows. For this I mainly make use of a PHP framework called Laravel and a library called Laravel Livewire.
I am very active in my church in all things technical. I enjoy mixing live sound and assisting with the live streaming of services.
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
Leading Training is focusing on providing virtual training
courses for the foreseeable future and will only consider
in-person and classroom training on request, with a required
minimum group size of four delegates. We remain committed to
offering training that is fast, focused and effective.
Save up to 10% by booking and paying
10 business days before the course.
Brochure:
Information may change without notice.
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
There are currently no scheduled dates.
Please note that this course needs a minimum of 6 delegates to schedule
a course. You can choose to be added to the waiting list by clicking the
button below and we will contact you when we have enough delegates
interested. Should we not get enough delegates, we will refund or credit
your paid booking.
Should you need this course urgently, the following options are
available:
Pay for 6 delegates (whether you have them or not) and we will
schedule the course as soon as possible.
If you have fewer delegates and cannot pay for 6, we can negotiate
a shortened course where some of the time will be spent in blended
learning - watching videos and doing tutorials and exercises with
some contact time with the trainer. We would want to discuss what
your core needs are so that we cover those aspects. You need to have
paid for 3 delegates at least.
Bringing your own PC
It is very important that you have full administrator rights to your
computer so that any software needed for the course can be installed
correctly.
Please ensure that you arrive at least 30min early on the first day
of training in order to get your PC setup correctly.
If this is not possible then it will be better to make use of our
computer.