Choose a Topic

MySQL fundamentals, data types, CREATE/ALTER/DROP TABLE, constraints, and schema design basics.

SELECT, INSERT, UPDATE, DELETE, WHERE, ORDER BY, LIMIT, OFFSET, GROUP BY, HAVING, and subqueries.

INNER JOIN, LEFT/RIGHT JOIN, FULL OUTER JOIN, CROSS JOIN, self-joins, and relational design.

B-tree indexes, composite indexes, EXPLAIN, query optimization, covering indexes, and slow query log.

ACID properties, transactions, isolation levels, stored procedures, views, and triggers.