MySQL & MariaDB fundamentals course (EN/NL/FR)
Startdata en plaatsen
placeLeuven 21 mei. 2024 tot 23 mei. 2024Toon rooster event 21 mei 2024, 09:00-17:00, Leuven event 22 mei 2024, 09:00-17:00, Leuven event 23 mei 2024, 09:00-17:00, Leuven |
computer Online: Online 21 mei. 2024 tot 23 mei. 2024Toon rooster event 21 mei 2024, 09:00-17:00, Online event 22 mei 2024, 09:00-17:00, Online event 23 mei 2024, 09:00-17:00, Online |
Beschrijving
This 3 day ABIS 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.
Attention is 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 Maria…
Veelgestelde vragen
Er zijn nog geen veelgestelde vragen over dit product. Als je een vraag hebt, neem dan contact op met onze klantenservice.
This 3 day ABIS 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.
Attention is 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.
Remark: Course description in English; Dutch and French versions are available on the ABIS website. Courses are planned in Dutch, English, and French. Consult the ABIS website for alternate course formats.
Main Topics - Content:
- Introduction: the MySQL and MariaDB environment; client-server-model; position within the relational model
- SQL data definition language (DDL): database objects (like tables, storage engines (esp. InnoDB), indexes, views, triggers); data types; characteristics; creation of objects, using them, and parameters
- SQL embedded in a program, esp. for supporting dynamic web pages
- Metadata: the INFORMATION_SCHEMA; the DESCRIBE and SHOW statements
- Securing the database environment and assigning authorizations
- Utilities: export/import of external data; defragmentation; check and repair; master/slave replication
- Use of the commands "mysql" and "mysqladmin", of the MySQL Workbench, and of the new MySQL Shell
- Data integrity, locking and transactions
- Performance: basic principles; use of indexes to improve performance; the 'EXPLAIN' statement
- Basic installation and configuration of the MySQL Community Server, of MySQL Cluster, and of MariaDB Server
Audience: Analysts, developers, and database administrators (web server maintainers) who will be using MySQL and/or MariaDB.
Background: The participants must have insight in relational database systems and SQL. Some knowledge of a programming language is not necessary. The course will however briefly treat - if need exists - the typical ways to access MySQL and MariaDB from one of the programming languages: PHP, Java, or Perl.
Didactics: Classroom instruction with practical exercises.
Duration: 3 days.
Blijf op de hoogte van nieuwe ervaringen
Deel je ervaring
Heb je ervaring met deze cursus? Deel je ervaring en help anderen kiezen. Als dank voor de moeite doneert Springest € 1,- aan Stichting Edukans.Er zijn nog geen veelgestelde vragen over dit product. Als je een vraag hebt, neem dan contact op met onze klantenservice.