Free to read ยท Three levels

MariaDB: relational SQL and dependable operations

A complete bilingual theory course from relational queries to MariaDB-specific performance, recovery and compatibility decisions.

18 lessonsEnglish + ArabicContent reviewed
Start learning

In this course

Learn MariaDB through a synthetic harbor logistics domain: customers, bookings, parcels, shipments and inventory. Eighteen developed lessons connect accurate SQL to storage engines, concurrency and operational evidence.

Every lesson includes worked SQL, reasoned expected results, common failures with remedies, solved exercises and official references. Examples are explanatory and marked non-runnable because no isolated database execution was performed. No application database connection is required.

What you will learn

  • Design constrained multilingual relational schemas and correct reports.
  • Coordinate transactional writes, indexes, roles and analytic SQL.
  • Evaluate MariaDB recovery, replication, JSON compatibility and controlled migrations.

Your learning path

Three levels

Basic: relational foundations

Model valid data and write deterministic SQL before changing rows.

  1. MariaDB server, client and storage engines
  2. Schemas, exact values and multilingual text
  3. Keys and relational integrity
  4. Filtering and deterministic results
  5. Joins, counts and grouped reports
  6. Insert, update and delete with a clear boundary
Explore this level

Intermediate: concurrency and reusable SQL

Coordinate transactions, indexes, named queries, privileges and recoverable backups.

  1. Transactions, snapshots and locking
  2. Indexes and reading EXPLAIN
  3. Views and common table expressions
  4. Window functions and ranking
  5. Accounts, roles and authentication
  6. Backup design and logical exports
Explore this level

Advanced: evidence and reliable operations

Investigate workloads and plan recovery, replication, compatibility and controlled change.

  1. Optimizer evidence and workload performance
  2. Restore rehearsals and point-in-time recovery
  3. Replication, GTIDs and Galera concepts
  4. JSON and MariaDB compatibility boundaries
  5. Stored routines, triggers and events
  6. Migration and operational reliability
Explore this level

Who this is for

  • Developers learning relational databases and MariaDB application design.
  • Engineers reviewing database correctness, performance and recovery practices.

Before you start

  • Basic familiarity with files, applications and tabular data.
  • Read SQL examples as theory; a disposable MariaDB environment is optional for independent supervised practice.

Related technical solutions

Diagnose socket, TCP and authentication failuresSeparate endpoint reachability from account authentication before changing application connection settings. All diagnostics are read-only examples for an already authorized session.Diagnose incompatible collations in comparisonsTrace the character set, collation and coercibility of both operands before applying a query-level remedy. Preserve the intended equality rules.Diagnose replica lag: retrieval or applicationSeparate transport failures, stopped apply and resource-limited catch-up using read-only evidence. Do not skip events or reconfigure replication to hide the symptom.