MySQL is a database management system DBMS (database management system), which uses two licenses - free GPL and commercial. It is a cross-platform database that communicates via SQL.
Designed for participants without knowledge and experience
basic
Language
The course will teach participants the basics of SQL in the environment of the MySQL database system. Participants will explain how data is stored in databases, show commands for manipulating data in tables and especially querying data using the SELECT statement. They will also learn more complex querying options, such as joining tables, query conditions, and using functions. The course is also suitable for complete beginners with SQL language.
Designed for participants without knowledge and experience
basic
Language
MySQL Course - Server installation and administration provides important information about the features of the MySQL database system and acquires skills of effective administration and maintenance. Important course topics include the installation and configuration process in Windows and Linux, database backup and recovery strategies, security configuration, system monitoring, and troubleshooting.
Designed for participants with basic knowledge and experience
intermediate
Language
The MySQL - Advanced Administration course introduces MySQL database server administrators to important advanced administration options. Participants will learn in detail the differences between individual storage engines, explain partitioning and access to metadata, learn to use replication as a supplement to backup for high availability, try to recover data from backups in case of problems and learn basic principles and procedures for optimizing database system performance.
Designed for participants with advanced knowledge and experience
advanced
Language
The course MySQL - advanced querying in SQL deepens the knowledge of participants about the advanced possibilities of the SQL language in the environment of the MySQL database system. Students will learn advanced querying capabilities using the SELECT statement, use subqueries and functions, show the principle of transactions, data import and export options, query optimization and, last but not least, learn to use the new version from MySQL 5.0 - views. If you already have experience writing SQL queries, are working on the MySQL platform and want to learn useful advanced query techniques, this course is ideal for you.
Designed for participants with advanced knowledge and experience
advanced
Language
The MySQL Cluster - High Availability Solution course will teach the experienced MySQL database administration system how to properly create and configure MySQL Cluster to ensure high availability and maximum performance. Participants will learn to use and add individual nodes to the cluster and at the same time better understand the internal functioning and price of the entire cluster on the MySQL platform
