Free to read ยท Three levels

MySQL: Relational Queries, Concurrency, and Operations

Build reliable MySQL 8.4 LTS schemas, queries, transactions, analytical reports, and recovery plans through a coherent stationery-shop laboratory.

18 lessonsEnglish + ArabicContent reviewed
Start learning

In this course

This bilingual public theory course develops MySQL knowledge from relational modeling to operational reasoning. Eighteen substantial lessons use a synthetic stationery shop to connect query results, integrity rules, concurrent changes, and recovery decisions. Each lesson includes explained SQL, realistic failures, worked exercises, and official references.

The target is MySQL 8.4 LTS with InnoDB. Examples are illustrative and marked non-runnable; displayed deterministic results are derived from the declared fixture, while performance and administrative output are explicitly environment-dependent. The material neither connects to configured databases nor requests production changes. MariaDB differences are identified where portability matters.

What you will learn

  • Model identities, relationships, exact amounts, and missing values.
  • Write deterministic reports with joins, aggregates, CTEs, and windows.
  • Protect state changes with constraints, guarded writes, transactions, and safe parameters.
  • Read optimizer evidence and diagnose locking without inventing performance guarantees.
  • Explain JSON contracts, stored programs, tested backups, GTID progress, and failover boundaries.

Your learning path

Three levels

Relational foundations and precise SQL

Model the shop and write correct reads and scoped changes.

  1. Relational thinking and the shop laboratory
  2. Selecting, filtering, and missing values
  3. Joins and relationship cardinality
  4. Aggregation and questions inside questions
  5. Safe INSERT, UPDATE, and DELETE
  6. Types, normalization, and schema evolution
Explore this level

Reliable applications and analytical queries

Connect isolation, constraints, plans, reusable relations, analytics, and security.

  1. InnoDB transactions and isolation
  2. Constraints and purposeful indexes
  3. Reading EXPLAIN without guessing
  4. Views, CTEs, and recursive reasoning
  5. Window functions and analytical frames
  6. Accounts, roles, and safe query construction
Explore this level

Concurrency, performance, and operations

Diagnose contention and plan sustainable performance, document contracts, and recovery.

  1. Locking, waits, and deadlock recovery
  2. Optimizer evidence and sustainable performance
  3. JSON and relational boundaries
  4. Stored routines, handlers, and responsibility
  5. Backup, restore, and point-in-time recovery
  6. Replication, GTIDs, and operational readiness
Explore this level

Who this is for

  • Developers learning relational SQL and MySQL application design.
  • Engineers who need to reason about transactions, query plans, and operational recovery.

Before you start

  • Basic familiarity with programming variables and simple arithmetic.
  • No existing database connection is required; optional practice needs a separately provisioned disposable MySQL 8.4 lab.

Related technical solutions

Access denied: account, host, plugin, or privilege?Classify a failed MySQL 8.4 connection before changing credentials or grants.ONLY_FULL_GROUP_BY: repair the report meaningResolve aggregate ambiguity without disabling the SQL mode or masking arbitrary values.Deadlocks and lock waits: diagnose before retryingUse read-only lock evidence, distinguish rollback scope, and bound complete-business-operation retries.