Linux Training+32 (0)2 747 47 01Registration FormMail

MySQL image MySQL Course/Workshop

Course Overview
This course is perfect for those wanting to maintain a Linux system with MySQL, MariaDB and Percona Server for MySQL. System Administrators, Database Administrators and Embedded Developers using MySQL. The course starts with setting up and explaining the differences between the different MySQL flavors, phpmyadmin and other administrative tools and basic administration tasks. As the course advances, more advanced topics are handled such as troubleshooting and analysing performance related problems and query analysis.

Knowledge prerequisites
IT Background and general Linux skills. Linux Power User or simular experience. Some notion of what a SQL query is.

Method Course/Workshop, classical education with practical exercises.

Participants Everybody who is responsible for designing and maintaining Mys Systems.

Course Flow

First day: MySQL flavors and basics
  • The MySQL ecosystem: Oracle MySQL, MariaDB and Percona
  • MySQL engines: InnoDB, MyISAM and others
  • Phpmyadmin and basic tasks
  • Backup and Restore

Day 2: Using MySQL

  • Using MySQL from the command line, shell scripts and PHP
  • Database design and normalisation or not
  • MySQL Security
  • Special commands to effectively use MySQL

Day 3: Troubleshooting MySQL

  • Point-in-Time-Recovery (PiTR)
  • General performance considerations and hardware choices
  • Indexing and SQL query tuning
  • Profiling

Administrative Information
Course Dates:
On Demand

Courseware: Course materials are provided.

Price 2.050,- € + VAT

More information
Phone: +32 (0)2 747 47 01

MySQL is a registred trademark of Oracle, Inc.
MariaDB is a registred trademark of MariaDB Corporation Ab.
Percona Server is a trademark of Percona, Inc.

Course Registration Form

Back to Linux Belgium Education

You can find the Full Calendar here.

Copyright 2001-2023, Linux Belgium. All rights reserved. Linux is a trademark of Linus Torvalds.
Linux Belgium is a registered trademark of Linux Belgium b.v.b.a. All other trademarks are the property of their respective owners.