SQL language from scratch for MariaDB – processing business data, improving the efficiency of statements and reports

Training process

Training needs analysis

If you have specific requirements regarding the training programme, we will carry out a training needs analysis for you. This will guide us on which aspects of the programme should receive greater emphasis, so that the training programme meets your specific needs.

What will you gain?

Understanding relational databases - You will build solid database fundamentals and see how tables, objects, and relationships form a consistent model, making it easier for you to design a correct data structure.

Confidence with MariaDB - You will get familiar with the MariaDB environment and its key features, so you can work with a database server more confidently and make practical use of its capabilities.

Better use of tools - You will learn how to use tools that support MariaDB work, helping you run queries faster, review data more efficiently, and handle everyday database tasks with greater ease.

Confident SQL writing - You will master SQL syntax, understand the main language categories, and see where each one is used, so you can start writing correct commands for real database work.

Building advanced queries - You will learn to create SELECT queries with sorting, aggregate functions, UNION, joins, and subqueries, so you can retrieve and analyze the exact information you need.

Modifying table data - You will practice inserting, updating, and deleting rows, including data changes driven by queries, so you can safely perform common operations on records in existing tables.

Creating database structures - You will learn how to create and remove tables and how to build them from query results, giving you the skills to expand a database structure to match project needs.

Working with date data - You will learn how to handle dates in SQL and use them correctly in queries, allowing you to prepare more accurate filters, summaries, and time-based reports.

Training programme

1. Presentation of the basic concepts of databases

data structures – introduction,
relational database models,
objects and relationships between them,
operators.

2. Description of the MariaDB database management system

3. Overview of tools supporting work with the MariaDB database

4. Introduction to the SQL language (Structured Query Language)

SQL syntax,
SQL classification,
application.

5. Detailed discussion of the DQL (Data Query Language) language

SELECT,
date handling,
sorting,
group functions,
UNION,
tables – inner and outer joins,
nested and correlated subqueries.

6. Presentation of the DML (Data Modification Language) language

rows – inserting,
inserting rows through queries,
deleting rows,
row values – changing.

7. Understanding the role of the DDL (Data Definition Language) language in creating and modifying the structure of databases

tables – creating,
deleting tables,
creating tables through queries.

What are the prerequisites for participating in the training?

Computer basics - You should be comfortable using a computer, launching programs, working with system windows, and saving files so you can complete the course exercises without difficulty.

Basic data concepts - You should understand what rows, columns, and tables mean in simple data sets, because this will help you move more quickly into the topic of relational databases.

Reading simple instructions - You should be able to read short technical instructions carefully and follow them step by step, so you can work smoothly with examples and exercises during the course.

Attention to detail - You should work carefully and pay attention to details, because in SQL even a small mistake in a name or in syntax can change a query result or cause an error.