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.
Relational databases rely on a set of concepts that explain how data is organized and interpreted. The section introduces data structures, relational models, objects and the relationships between them, and also places operators in that framework so later SQL work has a clear conceptual base.
From an organizational and technical perspective, MariaDB is presented as the database management system used throughout the training. The section clarifies its role, the context in which it operates, and how it supports storing, managing, and accessing structured relational data.
Daily work with MariaDB depends not only on SQL itself but also on the surrounding tools. Attention is given to the software that supports query execution, database access, and routine administration, helping place later practical tasks in an appropriate working environment.
SQL serves as the common language for defining, querying, and modifying data in relational databases. This section explains core syntax, the main classification of SQL statements, and the practical areas in which the language is applied when working with database systems.
SELECT is used here as the basis for retrieving and combining information from relational structures. Participants work with date handling, sorting, aggregate functions, UNION, inner and outer joins, and then move to nested and correlated subqueries for more complex retrieval logic.
Working with table data requires precise control over row-level changes. This part focuses on inserting records, including inserts based on query results, as well as deleting rows and updating existing values to keep datasets consistent with operational needs.
DDL commands define how database structures are created and changed in MariaDB. The section covers creating and dropping tables, then extends this foundation with building new tables from query results, which introduces practical patterns for shaping schemas from existing data.
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.
