MySQL & MariaDB fundamentals course

This course presents a description of MySQL and of the very similar MariaDB: what it is, what it is intended for, and how it can be used. The participant will learn

• the structure of recent versions of the MySQL database software, and the similar MariaDB software;
• the use of the "client" tools: command line interface, graphical interfaces, admin interface;
• the objects for data storage and data manipulation;
• creating databases, tables, and users;
• preparing a database for use, especially authorisations and indexes.

Attention is also paid to the use in the context of a web server, to MySQL and MariaDB in relation to other RDBMS, and to specific topics like models for data storage, integrity, authorisations, and performance.

Moreover, this course will explain how to install the system and use it in practice, both on Unix/Linux systems and on MS-Windows. After completion, the participants will not only have the necessary theoretical background of MySQL and MariaDB as RDBMS but also will have had sufficient practical training to start working with MySQL or MariaDB in an independent way.

Together with SQL and relational databases fundamentals this course forms a well-balanced whole, in such a way that after successful conclusion of this course, the participants will have a 'complete overview' of MySQL and MariaDB as RDBMS.