SQL training and MySQL/MariaDB database management

Relational databases (DBMS) are one of the most common standardized ways to store structured data and then work with it in various ways. The SQL query language is then used to retrieve data from the relational database.
One of the most commonly used databases, especially in the area of web applications, is the MySQL/MariaDB database.
If you learn to use SQL and MySQL/MariaDB you can be sure that you will apply this knowledge in your profession in IT fields.

Basics of SQL

The aim of the SQL Basics training is to learn how to work with relational databases using SQL

The course is for

The course is intended for those who need to store structured data in relational databases and need to retrieve and update this data, which is what the SQL query language is for.

You will learn at this course

At the training you will learn to use relational databases, i.e. to create database tables, work with data and use the SQL language.

Training syllabus

What is a relational database
DB tools - console, desktop (DBeaver), web ...
Data types
Creating tables
Basic data operations: SELECT, INSERT, UPDATE, DELETE
Sorting, ordering, etc.: Group by, Order, Count
Joining tables. JOIN statement
Subqueries
Integrated functions: SUM, COUNT, ...

Knowledge requirements:

Ability to think about structured data - such as data stored in a spreadsheet (Excel, Calc).

Equipment requirements:

MySql or MariaDB database installed.

I am interested in SQL training

If you are an individual or have a limited budget, you do not have to order a full training right away. Instead, you can book, for example, a one-off consultation or help with a specific problem, which will also be tailored exactly to your needs. Arrange a consultation

MySQL/MariaDB database administration

The goal of the MySQL/MariaDB database administration training is to learn how to work with the database as an administrator - that is, to ensure its operation, sufficient performance and data.

The course is for

The course is intended for administrators of Linux servers

You will learn at this course

At the training you will learn how to install a database server, create databases, create users and assign access credentials, back up the database and optimize database performance.

Training syllabus

Install a MySQL or MariaDB database
Creating databases
Create and manage user accounts
Configuration optimization
Tracking slow queries
Database backup and recovery
Storage engines MyISAM vs InnoDB

Knowledge requirements:

Basic knowledge of GNU/Linux OS and command line work.

Equipment requirements:

GNU/Linux operating system, ideally a Debian distribution.

I am interested in MySQL/MariaDB database administration training

If you are an individual or have a limited budget, you do not have to order a full training right away. Instead, you can book, for example, a one-off consultation or help with a specific problem, which will also be tailored exactly to your needs. Arrange a consultation