home 
 
 
 
nlfr
 
Home
About ABIS
Services
Courses
Resources
Contact
MyABIS
C
All CoursesbalkjeGeneral » Introduction to HW & SW » Soft skills » TracksOperating systems » MVS - z/OS » UNIX - Linux - AIX » Mac OS X » iPad and iPhone iOSDatabases and middleware » Relational databases & SQL » DB2 for z/OS » DB2 for LUW » Oracle » SQL Server » MySQL & MariaDB » IMS » CICS » IBM MQ » WebSphere » Big data and analyticsApplication development » Methods and techniques » TOGAF » PRINCE2 » Agile development and Scrum » Programming languages » Internet development » Object Oriented systems » Java » Development tools » SAS » XML » SOA & web servicesSystems management » ITIL » SecuritybalkjePractical informationRegistration 
MySQL & MariaDB fundamentals course

Objectives

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

  • how recent versions of the software package "MySQL/MariaDB server" are built;
  • the use of the "client" tools: command line interface, graphical interfaces, admin interface;
  • the MySQL and MairaDB objects for data storage and manipulation;
  • creating databases, tables, and users;
  • preparing a database for use, viz. 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.

Main topics

  • 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, 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
  • Data integrity, locking and transactions
  • Performance: basic principles; use of indexes to improve performance; the 'EXPLAIN' statement
  • Basic installation and configuration of a MySQL or MariaDB server.
 

Intended for

Analysts, developers, and database administrators who will be using MySQL and/or MariaDB; web server maintainers who are not yet familiar with MySQL or MariaDB; and anybody wanting to gain knowledge of the detailed workings of a relational database system.

Background

The participants must have insight in relational database systems and SQL (see course SQL and relational databases fundamentals). You can test for yourself to see whether you have sufficient background by filling out the online self-test.

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 (cf. PHP programming: fundamentals course), Java (cf. course Java programming), or Perl (cf. Perl programming: fundamentals course).

Training method

Classroom instruction with exercises (about 50% of the time).

Course leader

Peter Vanroose.

Duration

3 days.

Schedule

You can enrol by clicking on a date
datedur.lang.  location  price
03 Jul3NWoerden  (NL)1350 EUR  (exempt from VAT) 
06 Nov3NWoerden  (NL)1350 EUR  (exempt from VAT) 
04 Dec3?Leuven  (BE)1350 EUR  (excl. VAT)