MySQL & MariaDB fundamentals course (EN/NL/FR)

Tijdsduur
Locatie
Op locatie, Online
Startdatum en plaats

MySQL & MariaDB fundamentals course (EN/NL/FR)

ABIS
Logo van ABIS
Opleiderscore: starstarstarstarstar_border 8 ABIS heeft een gemiddelde beoordeling van 8 (uit 1 ervaring)

Tip: meer info over het programma, prijs, en inschrijven? Download de brochure!

Startdata en plaatsen

placeLeuven
21 mei. 2024 tot 23 mei. 2024
Toon 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. 2024
Toon 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…

Lees de volledige beschrijving

Veelgestelde vragen

Er zijn nog geen veelgestelde vragen over dit product. Als je een vraag hebt, neem dan contact op met onze klantenservice.

Nog niet gevonden wat je zocht? Bekijk deze onderwerpen: MySQL, SQL, Microsoft SQL Server, Web applicatie ontwikkeling en Data Science.

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

Er zijn nog geen ervaringen.
  • Vraag informatie aan over deze cursus. Je ontvangt vanaf dan ook een seintje wanneer iemand een ervaring deelt. Handige manier om jezelf eraan te herinneren dat je wilt blijven leren!
  • Bekijk gerelateerde producten mét ervaringen: MySQL.

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.

Download gratis en vrijblijvend de informatiebrochure

(optioneel)
(optioneel)
(optioneel)
(optioneel)
(optioneel)
(optioneel)
(optioneel)

Heb je nog vragen?

(optioneel)