Description

An intensive course which will allow you to acquire all the skills necessary for the efficient and reliable use of the Maria DB database: practice of the SQL language, database objects, security... This course also offers an introduction to administration.

Who is this training for ?

For whom ?

This course is aimed at all IT professionals who have to use MariaDB.

Prerequisites

Training objectives

Training program

• MariaDB Data Server Overview
  • The MariaDB server, history, versions and other projects from MySQL.
  • Databases under MariaDB (creation, deletion, options).
  • MariaDB tools.
  • Tables (type, constraints, indexes, virtual columns, constraints, etc.
  • ).
  • Introduction to the MariaDB storage engine ( MyISAM/Aria,XtraDB/InnoDB, etc.
  • ).
  • Practical work Creation of databases and different types of tables, modifications.
• SQL language
  • The relational model.
  • Referential integrity (show, information_schema, performance_schema).
  • The LMD language: SELECT, GROUP BY, HAVING, ORDER BY, LIMIT, UNION.
  • SQL functions and expressions (CASE, IF, LIKE, numeric functions, date functions, handling of NULL values).
  • Introduction to transactions (ACID and MariaDB standard) .
  • Practical work Implementation of a data model, analysis of constraints and creation of queries.
• Advanced queries
  • Multitable queries (INNER, JOIN, CROSS JOIN, LEFT/RIGHT OUTER JOIN).
  • Subqueries (scalars, lists, derived tables).
  • Transactions (operation, data consistency).
  • Isolation levels (READ COMMITED, REPEATABLE READ, READ UNCOMMITED, SERIALIZABLE).
  • Table locking (type of locks, visualization, deadly locks).
  • Comparison of joins/subqueries: advances in MariaDB.
  • Practical work Creation of queries with joins, subqueries, prepared queries, transactions, and table lock analyzes.
• Query Optimization
  • Execution plan (EXPLAIN, SHOW EXPLAIN, STATISTICS).
  • Query execution and query caching.
  • Indexing and best practices.
  • Securing stored procedures and views.
  • Practical work Analysis of execution plans, indexing of queries.
• Introduction to programming
  • Stored procedures and functions.
  • Cursors.
  • Error handling.
  • Triggers: type, usefulness.