MySQL

MySQL Architecture

MySQL Data Types

DDL — CREATE, ALTER, DROP

DML — INSERT, UPDATE, DELETE

SELECT Queries & Filtering

JOINs — INNER, LEFT, RIGHT, CROSS

Subqueries

GROUP BY & Aggregation

HAVING Clause

UNION & UNION ALL

Window Functions

Common Table Expressions (CTE)

Stored Procedures

Triggers & User-Defined Functions

Views

String Functions

Date & Time Functions

Indexes Overview

B-Tree Index

Composite Index

Covering Index

Full-Text Index

Index Selectivity & Cardinality

EXPLAIN & Query Analysis

Query Optimisation Techniques

Slow Query Log

InnoDB Storage Engine

ACID Properties

Transaction Isolation Levels

MVCC (Multi-Version Concurrency Control)

Deadlocks & Locking

Row-Level vs Table-Level Locking

Foreign Keys & Referential Integrity

Normalisation (1NF–BCNF)

Denormalisation

Table Partitioning

JSON Data Type & Functions

Replication (Primary-Replica)

Group Replication & InnoDB Cluster

Sharding Concepts

Connection Pooling

Backup & Recovery

Performance Schema

MySQL Security Best Practices

MySQL Configuration Tuning

MySQL with Spring Boot / JDBC